Welcome to Omgili,
Omgili ( Oh My God I Love It ;) is a search engine for discussions. With Omgili you can find answers and solutions, debates, discussions, personal experiences, opinions and more... To learn more about Omgili click here.
This is a complete preview of the discussion as it was indexed by Omgili crawlers. Use this preview if the original discussion is unavailable.
Click here to view the original discussion.
 |
|
 |
|
ERROR [IM002] [Microsoft][ODBC Driver Manager] From VB.Net in VS.2008 on Vista x64 but Test Connection works...
I wrote an application in VB.Net in VS2008 running on Vista x86, which conects to an Oracle database using the ODBC drivers and Oracles "Instant Client".
I have moved this to a PC running Vista x64, and Iget the error message "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" whenit tries to connect to the database.
I have the ODBC Data Source set up and Test Connection works.
The Data Source is named Oracle11 and the conection string is "DSN=Oracle11;UID={username};PWD={password}".
The application still works fine on the Vista x86 PC.
|
|
 |
|
 |
|
|
|
|
Hi Dave,
Welcome to MSDN Forums!
Do you rebuild the VB.NET project after you move it to the Vista x64 machine?
By default, if the project is built as “ Any CPU ”, it will be a 64-bit application when building on x64 systems and a 32-bit application when building on x86 system.
For 64-bit application, we may need a 64-bit ODBC driver.
So please make sure that the machine has the correct 64-bit ODBC driver installed.
Also, you can try to build the application as “ x86 ” to make it run as a 32-bit application.
Besides, we can use Process Explorer to make sure the certain driver dll has been loaded correctly.
(Select the VB.NET application process instance and then press “ Ctrl + D ” to see the loaded DLLs)
If you have any questions, please feel free to let me know.
Have a nice day!
Best Regards,
Lingzhi Sun
|
|
|
|
|
|
|
|
|
I've found some info but it isn't working yet.
Suggestions I've found are to disable User Account Control (didn't work), to set the project for x86 CPU only (didn't work), and to install 32 bit drivers.
I'm not an Oracle expert & can't swear that the drivers are 64 bit, but they show up in Administration Tools-->Data Sources, and not in Windows/SysWOW64/odbcad32.exe, so presumably they are 64 bit drivers, even though some files names imply that they are 32 bit, e.g.
Sqora32.dll.
My guess now is that the drivers are not 32 bit, but so far as I can tell, there is no separate 32 bit dirver download from Oracle - I'm using version 11.1.0.7.
Version 10.x.x.x does have a 32 bit download.
Does anyone know if I should drop back to version 10, or if there is a procedure to get 32 bit drivers from the version 11 files?
(My other problem is that we can't download huge files, and these are around 700MB, so I'm hoping I won't have to do this.)
|
|
|
|
|
|
|
|
|
It sounds like the 64-bit drivers are installed so I'm not sure why you're app would be having a problem locating them.
That is, unless the app has been compiled with the x86 option, in which case it's running in WoW64 and looking for the 32-bit drivers.
The 32-bit drivers can be found at the below link:
http://www.oracle.com/technology/software/tech/windows/odbc/index.html
|
|
|
|
|
|
|
|
|
Hi Dave,
How is the problem going now?
Have a nice day!
Best Regards,
Lingzhi Sun
|
|
|
|
|
|
|
|
|
Deadlines being what they are, I ran out of time to persue this.
I moved back to an x86 PC and everything is fine.
I will look into it again when I need to do an x64 version of the app.
It will probably be easier to use the x64 PC for x64 apps only, and use an x86 PC for all x86 apps.
I'm sure it is possible to do everything on the x64 PC but right now it takes too much time and effort to get around these issues.
Thanks for the assistance.
|
|
|
|
|
|
|
|
|
Hi Dave,
If you need any further assistance, please feel free to let me know.
Have a nice day!
Best Regards,
Lingzhi Sun
|
|
|
|
|
|
|
|