This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi Floks, I have created one DSN using Oracle Driver. DSN Name = jdbctest DSN Description = "" Service Name = "" User id = scott After creation of DSN i tried to test Oracle ODBC Test i got below error can any one have any idea why i got below error. SQL STATE:01000 Native Error Code :444 Driver Message : The Driver returned invalid [or failed to return] SQL_DRIVER_ODBC_VER:03:51 Thanks in advance for help Bye Satish
Hi s reddy, You are doing a pretty good job of creating the dsn. the only thing you are missing is the service name. Service Name is used by the oracle driver to connect to the data base. You need to create a service using Oracle SQL Net tools. When a service is created, oracle basically writes the connection configuration into tnsnames.ora file. which should look something like this. (description=(address=(host=ServerName)(protocol=tcp)(port=1521))(connect_data=(sid=orcl))) And after you are done with the service created, specify the service name in your dsn configuration. it should work. Satish