File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
Help for Access-JDBC
DB on Local Files System
connecting to database
MS Access Database
command execution error