• 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
Marshal
Posts: 34072
334
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: 8927
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: 8927
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.
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic