[dba-SQLServer]Changing Connection string server

Create a User or System DSN via code.  If you would like the code for how to
do it, email me offline.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of David
Emerson
Sent: Sunday, July 13, 2003 11:44 PM
To: dba-SQLServer at databaseadvisors.com
Subject: [dba-SQLServer]Changing Connection string server


I have an application with an AXP ade and SQL2000 BE.  When an updated FE 
is ready I can connect to the SQL Server using Access and set the 
connection using File .. Connection.

However, I now have a situation where the SQL BE will be in another 
city.  I need a way for the users to be able to open an updated FE and 
connect to their data base.  They will not have Access XP and the process 
is to be as simple as possible.

Can anyone give me some pointers to how I can do this.  I will know the 
server name so if there was something I could do in code then this would be 
acceptable.

Regards

David Emerson
DALYN Software Ltd
25b Cunliffe St, Johnsonville
Wellington, New Zealand
Ph/Fax (877) 456-1205 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com