This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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!