JDBC Bridge question

[FatStratCat]

I have been using msaccess2000 with an ODBC driver to print out records from my remote hosted mysql database. 2 weeks ago it stopped working, and I was told by my provider they don't support odbc, but that they do support jdbc.

I know there is a jdbc bridge available, but I don't know how to modify what I currently have to get it to work. I have a menu driven interface in MSAccess with search and print capabilities that have worked just fine untilthe provider stopped supporting it.

I can't find any links on how to get this done. my provider does have the jdbc driver installed in my "tomkat classpath", but how I can use this info to get my msaccess 2000 db interface linked up to it is where I'm at a loss.

Thanks for any help.

 

[SteveMc]

Found this link - it might be helpful...

http://www.javaworld.com/javaworld/javaqa/2000-09/03-qa-0922-access.html

 

[FatStratCat]

The part that confuses me is this. Basically I have a form in msaccess that uses an odbc driver I DL'ed to access the MYSQL database, with no coding required. The msaccess program simply found the driver,and after I entered the correct info it connected.

How do I implement this JDBC driver? There seems to be a lot of coding involved, where does it go?

Finally, when I went to sun to find the drivers, the ones that seem to be appropriate for my needs cost $400. my ISP does have a jdbc driver, but I don't know if it is the one that is a bridge between odbc and mysql, and if it is, where do I put it to get my msaccess 2000 form to link to the DB?

Sorry if I'm an idiot, but odbc was easy to install, and I'm at a loss on this jdbc set up.