Can not connect oracle db from vb dot net application in 64 bit windows 7

Question

User-290626477 posted

Hi,

My dot net windows application (visual studio 2008, vb.net) is running fine on 32 bit windows XP. But in 64 bit windows 7 it can not connect the oracle 10g database. The application was originally on vb6. It was converted into vb.net. I am using the following connection string.

StrConn = "Provider=MSDAORA.1; Data Source=ABC;User Id=XYZ;Password=XYZ123;"

Any help would be appreciated.

 

Answer 1

User-417784260 posted

What error are you getting? I suspect that either the database is not accessable from the windows 7 box or or the application is compiled for any cpu and there are not 64 bit odbc drivers available for oracle.  You can fix the latter by compiling for the x86 processor.

Answer 2

User-290626477 posted

Thanks Ken. I comiled in x86 and it solved the problem

Answer 3

User197322208 posted

What error ? And  , as I remember, the Oracle provider have not  a 64 bit version...

Answer 4

User269602965 posted

Install the ODP.NET 32-bit Client install into a new Oracle home directory.

The 32-bit client will then contact the 64-bit database using the same connection string in the application.