CODEWITHSUNDEEP
c#asp.netoracle-database
Waqas Ali
Waqas Ali

Reputation: 21

ODBC connection in Windows Server 2008 R2

In Windows Server 2008 R2 not showing Microsoft ODBC for Oracle 64 bit.

I made a connection string. Go to C:\Windows\SysWOW64\odbcad32.exe and add username and server and select Microsoft Odbc for Oracle but When I run my application it shows:

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

My connection string is following:

<connectionStrings>
<add name="conct" connectionString="DSN=mydb;UID=123;PWD=334"/>
</connectionStrings>

How I remove this error and How I check which one wrong my connection string or driver not found?

Upvotes: 2

Views: 2497

Answers (1)

Mr. Kite
Mr. Kite

Reputation: 101

C:\Windows\SysWOW64\odbcad32.exe is used for accessing 32-bit ODBC drivers on Windows x64. If your desired driver is 64-bit, you need to use c:\windows\system32\odbcad32.exe.

Upvotes: 3

Related Questions