PROBLEM?
It seem to me that my previous post was unsuccessful.
My problem is: i bought a web storage for my website at Webvision. I need to do JSP using JDBC:ODBC to connect/bridge my MS Access database.
I normally register my database at ODBC 32bit in the control panel, now the server is not mine, how do i do it. I ask my web service provider, all they say was they do not do it for me, they just provide me with the storage space.
So i am asking is there another way to register my database without using control panel ODBC?
[551 byte] By [
meowo] at [2007-9-26 7:02:42]
You can specify the DSN's properties within the connection string:
An example for connecting to an Access db c:/access/mydb.mdb as user myuser with password mypw:Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection con = DriverManager.getConnection( "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:/access/mydb.mdb",
"myuser", "mypw" );
Watch out: there have to be blanks at specific places, maybe not clearly visible here! Copy this line and change it in your editor.
Only the JDBC-ODBC bridge driver requires you to configure ODBC like that. Other drivers can access the database more directly. Since you are running your own website, I would suggest doing the professional thing and getting a professional JDBC driver for MS Access.
>...my MS Access database.
Meaning a database that is on site at Webvision right? Not one that is on your local computer. Because if it is on your local computer I seriously doubt you will be able to use JDBC-ODBC to access it.
If on the webvision site then use the DSN-less connection as Hartmut suggested.
