Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 397
  • Last Modified:

UNIT TEST ORACLE CONNECTION

Hi
i have the following problem.
I have create a unit test Sub in vb.net where i Open a simple Oracle Connection in the
following way :

MyConnection = New OracleConnection("Password=giseltest;Persist Security Info=True;User ID=giseltest;Data Source=GISELDB")
MyConnection.Open()

Now if i execute the test on a pc where the operating system is Windows XP Professional
everything is ok, but if i execute the test on a pc where the operating system is Windows 7 64 bit Home i have always the following error : ORA - 12154

Thanks in advance
0
NUCLEARE
Asked:
NUCLEARE
  • 3
1 Solution
 
George K.Commented:
Check this: In 64 bit machines 32 bit programs are found under C:\Program files (x86)\
-The two () parenthesis here are a problem
In case of XP  it is  C:\Program files
0
 
George K.Commented:
Normally you should change the location where the corrsponding applications/program are - install  on another folder.
0
 
CodeCruiserCommented:
Do you have the 64bit Oracle provider installed?
0
 
NUCLEAREAuthor Commented:
I add this two notes:
1) I have not  64bit Oracle provider installed
2) I compile solution in 32bit (x86)
3) And the same code in a normal vb.net project works without error

0
 
George K.Commented:
Then, have you checked my suggestions?
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now