File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "Connecting to Access DB on website" Watch "Connecting to Access DB on website" New topic

Connecting to Access DB on website

Steve T

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" (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

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 . 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.

Read about me at ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
I agree. Here's the link:
subject: Connecting to Access DB on website
It's not a secret anymore!