freelanceprogrammers.org Forum Index » Java

View previous topic :: View next topic

dsn-less connection

c_beginner2001 Posted: Wed Feb 20, 2002 5:00 am

Joined: 31 Jan 2002

Posts: 24

dsn-less connection

Hi everyone, Can anyone tell me how the source
code to create a dsn-less connection to a Microsoft
Access 2000 database called "Test" (using the source
code rather than the control panel to setup the
database). So far I have found this code, it compiles but when
I run it I get the following error
message: Connection Exception: java.sql.SQLException:
[Microsoft][ODBC Microsoft Access Driver] Could not find file
`(unknown)`. Could anyone tell me whats wrong and how to fix it
please. ----------------------- Code: import
java.sql.*; public class
MakingTheConnection3 { public static void main(String[] args)
{ Connection connection; Statement statement; String
url = System.getProperty("user.dir") +
"\catalogo.mdb"; String conStr = "jdbc:odbc:Driver={Microsoft
Access Driver (*.mdb)};DBQ=" + url; try{ 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connection =
DriverManager.getConnection(conStr); connection.createStatement(); }
catch
(Exception ex){ System.out.println("Connection
Exception: " + ex); } } } Thanks everyone

mcconnell_stephen Posted: Wed Feb 20, 2002 6:00 am

Joined: 01 Feb 2002

Posts: 73

dsn-less connection

What does your url String look like if you do a
System.out.println(url)? Does it look like a path to a valid
file? It appears your connect string is OK with finding
the driver, but not able to find the
file... I`ve done DNS"less" connections in VB and C++, but not
in Java... for some reason it just didn`t work (lack
of patience in the devloper, probably). You seem to
be on the right track, but just check the value of
your "url". Sorry that I couldn`t be of more
help, but I haven`t use MS Access for database in
years. Stephen McConnell <a href=http://www.crosslogic.com
target=new>http://www.crosslogic.com</a>

freelanceprogrammers.org Forum Index » Java

All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help