Oracle ODBC connection in .NET application
Posted on 2013-01-25
I am migrating a VB.NET 32 bit application from a 32 bit environment over to a 64 bit Windows 2008 server environment. I have VS set up on a dev machine in the new environment and have put my application on here and am now trying to get it to work properly. I use ODBC to connect to Oracle through Oracle 10G Client(or 11G for 64 Bit)
I am having issues with my ODBC connection. When I change the target platform to X86 in my application, I get an error stating " Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" so I believe I have driver issues. We do have a driver set up using c:\windows\sysWOW64\odbcad32.exe which I thought if I used X86 it would point to this 32 bit driver but I am not sure. We have also set up a 64 bit driver and DSN using c:\windows\system32\odbcad32.exe. which I thought would get pointed to when target platform is x64. When I change my platform to x64 it does at least get a connection but I then get an "Arithmetic operation resulted in an overflow." when I do a DataAdapter.fill command.
I would like to just keep this as an x86 application(platform) and thought this would point it to the sysWOW64 folder for the drvier connection but can't seem to get it working. I also do not have much experience with drivers and migrating .NET applications to a 64 bit environment. Any suggestions?? Thanks
Also, i have checked path variables as well as setting up Global Object. I am running this app as an administrator on the 64 BIT machine. Thanks