• Post Reply Bookmark Topic Watch Topic
  • New Topic

DSN Creation gives error

 
Betsy Camel
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
I am using Sql server in my application. when i am creating the dsn, it gives an error saying "test case failed" while testing the connection.
Please help as soon as possible as it is very urgent.
Thanks
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36027
431
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Betsy,
Let's look for some more information. Is there an exception being thrown/caught. Try e.printStackTrace() to get the full error message. Can you post some code?
 
Betsy Camel
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
DSN stands for Data Source Name.And this is how it is created.
In the control panel, you have the administrative tools here there is a ODBC driver click on it & then follow the steps.
the last step is to test the connection & this is were i am getting an error saying "test case failed ".
Can anyone help, its very urgent
 
Pradeep bhatt
Ranch Hand
Posts: 8933
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Betsy Camel:
DSN stands for Data Source Name.And this is how it is created.
In the control panel, you have the administrative tools here there is a ODBC driver click on it & then follow the steps.
the last step is to test the connection & this is were i am getting an error saying "test case failed ".
Can anyone help, its very urgent


Are you sure that the database server is up and running ? Have you selected the correct ODBC driver , user name & password correct ?
 
Betsy Camel
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
yes , the DB server is up & the name & password given are also correct. Is there anything else i need to take care of !
 
Pradeep bhatt
Ranch Hand
Posts: 8933
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Betsy Camel:
yes , the DB server is up & the name & password given are also correct. Is there anything else i need to take care of !


I dont know what is wrong. Does the test case failed message contain more detailed message. Why don't you try using other JDBC driver like JDBC type 4 driver.
 
Would you turn that thing down? I'm controlling a mind here! Look ... look at the tiny ad ...
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!