1
I have an x64 application written in C# with .Net Framework 4 you need to connect to the Microsoft ODBC for Oracle driver.
When using this driver with the application in x86 mode, this connection usually works. But when using the application in x64 mode it cannot connect and presents the following error:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I would like to know a way my x64 app can open a connection OdbcConnection
using this driver.
Obs: I need to connect to this driver so I don’t need to use the TNS file configuration inside the client.
I think the only way is to make your application run in 32 bits. This would be a problem for you?
– Maniero
@bigown It would be. Is there any other possibility? Or you would know how I can make a connection to Oracle 11g without the need of TNS file configuration?
– Arthur Menezes
Immediately I see no other solution but if you find something, I put.
– Maniero
@bigown as you are not sure of the solution, could give a vote to the question? So it goes into evidence so that other users can also help. thanks
– Arthur Menezes
I think psNytrancez asks this question because he has a computer in 32bits, with the database, and as the new computer are in 64, the 32 does not work but... I have a friend in France who has the same problem. After much research... it does not seem to have a 'perfect' solution. Here is an answer and there are several others about the same problem : https://community.oracle.com/thread/3577044
– Peter
@Peter What happens is this: There is an odbc driver called "Microsoft ODBC for Oracle" (MDAC) in which it only exists in the 32bit version. My application runs in x64 mode, before that it does not see the mentioned driver. I wonder if it is possible for the x64 application to see this x86 driver cited earlier.
– Arthur Menezes
I know that it exists only in 32 bits. Unfortunately. I will get the answer from my friend Frances, but I think there is no solution.. I found a strange point: - A v. 32 bits of Odbcad32.exe is in %systemdrive% Windows Syswow64. -A v. 64 bits of Odbcad32.exe is in the folder %systemdrive% Windows System32. Which means you have the 2 ???????!!!!
– Peter
@Peter these paths that you quoted is only to access the Data Source Administrator ODBC 32bits and 64bits. It escapes some of the question itself.
– Arthur Menezes
It is possible to put a code of how the connection is performed in the body of the question?
– Leonel Sanches da Silva
@Ciganomorrisonmendez this question is old, I managed to solve by other ways, nor in the project I am more, but I could not realize this type of connection. Anyway... it was a: Odbcconnection Connection = new Odbcconnection(odbcConnectString)
– Arthur Menezes