Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to Connect to a Remote Database  RSS feed

 
Chris Morrell
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello. I am trying to connect to an access database on my company's web host. I have tried a number of possibilities without success. Here is what I'm trying right now:



Do I need to use a different driver? Is the connection string incorrect? Any ideas?

Thanks in advance for your help.
 
Ernest Friedman-Hill
author and iconoclast
Sheriff
Posts: 24217
38
Chrome Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to JDBC
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 66142
141
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"jdbc:odbc://<ip_address>;dsn=<dsn_name>;uid=<user_id>;pwd=<password>"


Is this the actual string that you used? You did substitute real values, didn't you?
 
Paul Clapham
Sheriff
Posts: 22374
42
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"jdbcdbc://<ip_address>;dsn=<dsn_name>;uid=<user_id>;pwd=<password>"

Nope. Your "ip_address" part is meaningless. If your database is "remote" then you'll need to configure the DSN appropriately. Whether this is possible or not depends on the ODBC driver; some can be configured for databases on other machines and others cannot. If your next question was going to be about MS Access, its driver is in the latter category. Unless you map a drive to its "remote" location, which makes it basically local.
[ October 23, 2005: Message edited by: Paul Clapham ]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!