aspose file tools*
The moose likes JDBC and the fly likes Connecting to Access DB on website Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting to Access DB on website" Watch "Connecting to Access DB on website" New topic
Author

Connecting to Access DB on website

Steve T
Greenhorn

Joined: Mar 19, 2001
Posts: 2
Hi all,
I have created a website that contains an MS Access DB. I have also created a Java application that offers the ability to make changes to the DB. There is no problem when the DB is on my system but I cannot figure out how to connect to the DB on the website.
This code works fine on my system:
String user = "";
String password = "";
String url = "jdbc dbc:afl";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
How can I write the URL to connect to the website DB?
I have tried "jdbc dbc:www.nflultra.com:nflultra-afl" (where nflultra-afl is the DSN) and it gives me an error message "URL name too long"
Any advice would be greatly appreciated!

[This message has been edited by Thomas Paul (edited March 19, 2001).]
Frank Carver
Sheriff

Joined: Jan 07, 1999
Posts: 6920
"Steve T",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements.
Thanks.


Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Connecting to Access DB on website
 
Similar Threads
connecting to database
DB on Local Files System
command execution error
Help for Access-JDBC
MS Access Database