it is working fine with one SQL server.. but when am trying to another SQL Server i got the following error. java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
But on configuring DSN i'm able to connect to the server and it says "TEST COMPLETED SUCCESSFULLY".
Also i'm able to connect to the SQL thru Query Analyzer. Only problem upon connecting thru the above Java coding. PLease help me to resolve this. Thanks in Advance
Ramjane Thanks for your reply...
After registering in Enterprise Manget also i'm not able to connect.. But i'm able to connect from another machine using the same code.. is anything needs to be done on Machine specific???