Database cannot be connected

[Samarth Mehta]

My java knowledge is very basic
I wanted to know where to store the database so that i can access it from java code
I have the Db in MsAccess
I am using JdbcOdbcDriver
I need the url by which I can connect to the Db
Can you please help me out

[Herman Schelti]

hi,

You will have to create a Datasource via your Windows Control Panel.
There's an example at http://www.mundayweb.com/progs/jdbc-odbc-tut.php

It's a bit old, but you'll figure it out.

Herman
[ April 18, 2008: Message edited by: Herman Scheltinga ]

[Manuel Leiria]

Originally posted by Herman Scheltinga:
hi,

You will have to create a Datasource via your Windows Control Panel.

[ April 18, 2008: Message edited by: Herman Scheltinga ]

You don't necessarily have to! Example:

public static Connection getConnection() throws Exception {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/DB_CSJ/SPV.mdb");
return c;




}