This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30123
    
150

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: 8904

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: 8904

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
 
Similar Threads
DSN less MS access Connection using JSP - help needed
Data source name not found and no default driver specified
Problem on JDBC -- help urgent
Please Help!
EJB and JavaMail