• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Please Help!

 
Steve Tharp
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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://
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic