Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connecting with Oracle 10g database from .Net 3.5

Arun PrasathSep 14 2013 — edited Sep 19 2013

Hi all,

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

"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 notresolve 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 theapplication requested (see SQLSetEnvAttr).”

When i run the application from VisualStudio 2008 itself, i m not getting any error.I m getting this error in another computer where i m executing the .exe of that project.

I have installed .Net FrameWork 3.5 and CrystalReports redistribution on the deploying machine.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2013
Added on Sep 14 2013
14 comments
762 views