[AccessD] ODBC Driver Automation

Thanks Eric, I think I can use 'DBEngine.RegisterDatabase' to do what I
need.

Mark

-----Original Message-----
From: StaRKeY [mailto:starkey at wanadoo.nl] 
Sent: Wednesday, November 19, 2003 1:36 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] ODBC Driver Automation

Mark,

setting up the driver or the ODBC (user/system/file) dsn?
The driver has to be installed on the system, no way to automate this
but
with execution of the driver installation file.

As for setting up an ODBC connection to a database you could look into
this
hint: dbengine.RegisterDatabase

I also found this code on the web:
http://www.utteraccess.com/forums/access/access173548.html


Regards,
Eric Starkenburg


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark Boyd
Sent: woensdag 19 november 2003 18:32
To: AccessD at databaseadvisors.com
Subject: [AccessD] ODBC Driver Automation


Does anyone know of a way to automate the process of setting up an ODBC
driver to a SQL Server?

This would be extremely helpful.



Thanks,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 18-11-2003
Tested on: 19-11-2003 19:36:17
avast! is copyright (c) 2000-2003 ALWIL Software.
http://www.avast.com



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com