Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting to Access DB on website

 
Steve T
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 6920
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic