This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes ODBC Test Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ODBC Test " Watch "ODBC Test " New topic
Author

ODBC Test

satishind Reddy
Ranch Hand

Joined: Oct 17, 2000
Posts: 33
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
Satish Kasala
Greenhorn

Joined: Dec 19, 2000
Posts: 16
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ODBC Test
 
Similar Threads
about servlets(very urgent)
about servlets (very urgent)
Data source name not found and no default driver specified
connecting to database through servlets
Connecting to database form servlets