ODBC to database on remote machine 
Author Message
 ODBC to database on remote machine

Hi All

I hope someone has some ideas for me...

I am trying to connect my webserver to an Access table another NT Server
machine.
The database has to stay on the other machine, since it is used by a
pile of VB client front-ends all day.
The other machine is on the other side of a dedicated 64K leased line.

I have set up the logins & permissions on the remote machine, which is
not part of my NT Domain, so that the Web-server can use the database
through an ODBC connection. The problem is that I can only select the
remote database if I map a remote logical drive, which means that
someone has to be logged on all the time?

Surely that isn't right?
How can I get this to work without having a user logged on to the local
NT box, and his/her mapped drive in use by ODBC?

Cheers
Vaughn



Mon, 19 Mar 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Create ODBC DSN on a remote machine

2. RDC and a remote database (not on my machine)

3. How to verify if remote machine exists, and remote admin enabled

4. How to verify if remote machine exists, and remote admin enabled

5. How to verify remote machine exists, and remote admin enabled

6. ODBC database location different between machines?

7. How to use remote database by ODBC?

8. Using a Server machine's Access Database from a clients machine

9. Remote Server Machine Does Not Exist or Unavailable

10. Adding data to a spreadsheet on a remote machine

11. Error 463 - Remote server machine does not exist or is unavailable

12. WithEvents and Run-time error 462: The remote server machine does not exists or is unavailable

 

 
Powered by phpBB® Forum Software