index > Windows Forms Designer > Microsoft ODBC for Oracle driver Error in Oracle 10g

Microsoft ODBC for Oracle driver Error in Oracle 10g

I am trying to connect to an Oracle 10g database using the Microsoft ODBC for Oracle driver; I used following connection string

conn.ConnectionString = "Driver={Microsoft ODBC for Oracle};Server=myservername;Uid=myuserid;Pwd=mypassword;"

Below error occurred when I trying to connect database.

ERROR [08001] [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS: Could not resolve the connect identifier specified

ERROR [IM006] [Microsoft][ODBC Driver Manager]
Driver's SQLSetConnectAttr failed

ERROR [01000] [Microsoft][ODBC Driver Manager]
The driver doesn't support the version of ODBC behavior that the
application requested (see SQLSetEnvAttr).�?/span>

Some one help me how resolve this issue;

Edited bySureshkumar G Saturday, August 15, 2009 5:52 AMModified the line

Sureshkumar G Saturday, August 15, 2009 5:48 AM

Hi Sureshkumarg,

Do you use the OracleClient component offered by .NET framework? I think you'd better use the Connection component offered by Oracle. OracleConnection works great for Oracle 9i, but I am not sure it can work for oracle 10g. I did meet similar problem with oracle 10g also. So you'd better download the connection component from oracle.

I suggest you consulting from oracle forum about "How can I connect to Oracle 10g with .NET applicaiton, which component should I download and install" something like this. Please understand this is beyond the support area of Microsoft.

Please inform me the result and come back to me when you meet any problem.

Sincerely,
Kira Qian

Please mark the replies as answers if they help and unmark if they don't.