my dog learned polymorphism*
The moose likes JDBC and the fly likes Please Help! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Please Help!" Watch "Please Help!" New topic
Author

Please Help!

Steve Tharp
Greenhorn

Joined: Mar 19, 2001
Posts: 10
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
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
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

Joined: Mar 19, 2001
Posts: 10
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://aspose.com/file-tools
 
subject: Please Help!