Please Help!

[Steve Tharp]

I need to be able to connect my Java program on my local system to an access database on a remote server. I am using the following code for the url:
jdbc dbc:http://www.sample.com/fpdb/test.mdb
and I am getting an error that the URL is too long.
I can get it to work fine if the DSN is set to the name of the DSN on my machine but I cannot get the DSN to point to the database at my web host provider. Can anyone help me on this? Thanks

[Thomas Paul]

When you are using ODBC you must set up the database in your ODBC section of the control panel. You then use the ODBC name that you specified.

[Steve Tharp]

Originally posted by Thomas Paul:
When you are using ODBC you must set up the database in your ODBC section of the control panel. You then use the ODBC name that you specified.

I have tried to do that but when I Select a Database from the Control Panel, it only gives me the option of selecting a database from my hard drive. I don't see an option anywhere to specify an IP address or http://