aspose file tools*
The moose likes JDBC and the fly likes DSN Creation gives error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DSN Creation gives error" Watch "DSN Creation gives error" New topic
Author

DSN Creation gives error

Betsy Camel
Ranch Hand

Joined: Oct 02, 2003
Posts: 119
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

Joined: May 26, 2003
Posts: 31057
    
232

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?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Betsy Camel
Ranch Hand

Joined: Oct 02, 2003
Posts: 119
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

Joined: Feb 27, 2002
Posts: 8919

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 ?


Groovy
Betsy Camel
Ranch Hand

Joined: Oct 02, 2003
Posts: 119
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

Joined: Feb 27, 2002
Posts: 8919

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DSN Creation gives error