CODEWITHSUNDEEP
c#.netoracle-databaseiis
Webster Alexander III
Webster Alexander III

Reputation: 69

C#.net connection to Oracle database error

I have a C#.net application that I need to connect to an Oracle db. I built the connection string and datagrid and both show connection and pulling data. Problem is when I try to view the page it gives me this error;

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

I have gone into IIs on my server and set the connection string but still get the error. Here is my page code... " ProviderName="<%$ ConnectionStrings:CFO_INTRANET1.ProviderName %>" SelectCommand="SELECT DATE_ENTERED, EMAIL, SUGGESTION FROM CFO_INTRANET.SUGGESTIONS"> My Connection,

What am I missing??

Upvotes: 0

Views: 297

Answers (1)

bastos.sergio
bastos.sergio

Reputation: 6764

To setup an ODBC link for a 32bit application you must use:

C:\Windows\SysWOW64\odbcad32.exe

To setup an ODBC link for a 64bit application you must use:

C:\Windows\System32\odbcad32.exe

Upvotes: 1

Related Questions