Please Help!
Steve Tharp
Greenhorn
Posts: 10
posted 16 years ago
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
jdbc
dbc:http://www.sample.com/fpdb/test.mdband 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
mister krabs
Ranch Hand
Ranch Hand
Posts: 13974
posted 16 years ago
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.
Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
Steve Tharp
Greenhorn
Posts: 10
posted 16 years ago
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://
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://
