This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
To create a DSN called "TEST" do the following: 1. Click Start in windows and select run or open comand promt. 2. Type "odbcad32" and press enter. 3. When the "ODBC data source administrator" opens click on "Add". 4. In the window "Create new data source" select "Microsoft Access Driver (*.mdb)" then click finish 5. In the window "ODBC Microsoft access setup", type "TEST" into the "Data source name" text box. 6. Next click "Select" under "Database", then browse and select you Microsoft access databse and click "Ok". 7. Then click "Ok" on the "ODBC Microsoft access setup" window. 8. Then click "Ok" on the "ODBC data source administrator" window. 9. Re run the page.
Since the ODBC-JDBC bridge ships with Java, there is nothing particular to Servlets or JSP that needs to be done when using it. For this reason, I think this issue really belongs in the JDBC forum. Moving....
First, make sure that you create a "System" DSN whenever the calling code is located inside a service. Since you're using a Web server (Tomcat or something similar I assume?) and thus probably running it as a service, you need to make sure your DSN is a System DSN, NOT User. The service cannot access a user DSN unless you happen to create the user DSN as the same user that the service is running as. However, it's best just to make it a system DSN. Also, you can use a File DSN if you need to, as they work like system DSNs.
Second, DSN names are case sensitive. So, if your DSN is named "Test" and you try to use the connect URL of jdbcdbc:TEST, it will fail.
Jeff Ash<br /><a href="http://www.excellentiasoftware.com" target="_blank" rel="nofollow">Excellentia Software</a>
Joined: Jan 23, 2006
Yes I created DSN as told by discussion.Still its not connecting? Whats might be the problem...Is it CLASSPATH variable problem or any other?