wood burning stoves 2.0*
The moose likes JDBC and the fly likes odbc sql connection test fails Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "odbc sql connection test fails" Watch "odbc sql connection test fails" New topic

odbc sql connection test fails

vishvar hariraman

Joined: Apr 04, 2006
Posts: 20
hi everybody,

i m new to sql server and odbc connection
sql server functions well with login and password

but from a servlet,i am connecting to database.
for that i opened ODBC from adminstrative tools.
I added SQL server in System DSN tab, then I give DSN name.
In the drop down menu i cud not find 'local server' on the question "which SQLserver u want to connect it?".

Even then i typed local and proceeds the connection test failed.
wat s the cause for this error?
pls friens clarify this doubt

Thx in advance
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: odbc sql connection test fails
Similar Threads
Connect FoxPro DB using JDBC ODBC Bridge
Syntax of getConnection() method
how to get started with jdbc
Microsoft JDBC Driver Connection Problem
problem to connect to SQL server 7