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
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com