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
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30548
    
152

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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: DSN Creation gives error