vj#: Problems with java.sql in J# -- vj#

Problems with java.sql in J#

Cpierswim
3/19/2005 11:05:02 AM

vj#:

I need to stick to regular java code in this program I'm making and I'm
having trouble using the java.sql package. This is what this problem is:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")
- Gives me a Class Not Found Exception.
String url = "jdbc:odbc:DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=c:\\Time Site\\Time_Site_Database.mdb";
Connection con = DriverManager.getConnection(url);

RE: Problems with java.sql in J#

Cpierswim
3/19/2005 1:11:04 PM

Nevermind - I figured out the Class.forname problem.

Now I'm having problem with the String url =

Gives me an SQL error. I'm trying to figure it out, but haven't yet. What
would be the correct URL to connect to an Access database at that C:\
location?

[quoted text, click to view]

RE: Problems with java.sql in J#

Cpierswim
3/19/2005 1:21:02 PM

Ok - Nevermind. I figured out both problems. My database wasn't located
where I told the driver - duh. Lol

[quoted text, click to view]

Re: Problems with java.sql in J#

Lars-Inge Tønnessen (VJ# MVP)
3/22/2005 1:41:02 PM

Nice ! =:o)

Regards,
Lars-Inge

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the vj# group.