File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
It is sorta covered in the JavaRanch Style Guide.
subject: odbc sql connection test fails
It's not a secret anymore!