Convert User DSN to System DSN

Convert User DSN to System DSN

Post by Yair Sagee » Fri, 13 Aug 2004 02:00:33


Hi all,

I stupidly setup a database as a userDSN but now want to make it a system
dsn so that I can access it from another machine. I have an access db that
uses msde linked tables for the back end, which is installed locally on 1
machine in the network. I want to be able to add new features to the access
database from another machine and then copy over the improved version to the
other machine. What should I do?
 
 
 

Convert User DSN to System DSN

Post by rboy » Fri, 13 Aug 2004 02:19:14

You cannot access a DSN from another machine unless you are using a remote
sofware program, such as Terminal Server, to connect to the machine that
houses the DSN.

Either way, there is no way to make a user DSN a system DSN. You will need
to recreate it using the ODBC Admin applet.

Rand
This posting is provided "as is" with no warranties and confers no rights.

 
 
 

Convert User DSN to System DSN

Post by Yair Sagee » Fri, 13 Aug 2004 03:22:55

So how do people connect to a sql server running on another machine? I have
3 machines and 1 server, the server is running SQL Server and I want the 3
machines to have the same access database with linked tables.
 
 
 

Convert User DSN to System DSN

Post by Lisa Pearl » Sat, 14 Aug 2004 09:13:30

You create a user DSN on your OWN machine which gives the address (ip number
for example) of the machine running SQL server, to connect to a remote SQL
server.



have


remote
need
rights.