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: jdbcdbc: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
mister krabs
Ranch Hand
Joined: May 05, 2000
Posts: 13974
posted
0
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.
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://
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
dbc:http://www.sample.com/fpdb/test.mdb
