The DSN's are for a 3rd party app, so using this approach won't work in this instance. There are potentially a number of databases coming online in my environment which will each require a separate System DSN connection on each of ~15 Win2k Terminal Servers. I was hoping to reduce my time to do this.
I've been delving into the registry to see if it can be done that way, which it looks like it can. I will probably have to do it this way - Win32::ODBC seemed a little cleaner and did a bit of the ground work for me... oh well :) Cheers, Simo -----Original Message----- From: Bullock, Howard A. [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 3:58 PM To: 'Simon Horn'; '[EMAIL PROTECTED]' Subject: RE: Create ODBC DSN Remotely..?.. For my SQL Server I do not create DSNs but rather define the connect string on the fly to connect to my remoter servers. #--------------------------------------------------------------------------- --- # Connect to Integration Database # Two connections are required. The first will permit us to step through a # multi-record SELECT. The second is required to update the database. #--------------------------------------------------------------------------- --- my $Con = "Driver=SQL Server;" . "Server=pipsqueak;" . "Trusted_Connection=Yes;" . "DATABASE=Infrastructure"; my $db1 = new Win32::ODBC($Con); if (! $db1) { &Log($LogFile, "Error connecting db1($Con): " . Win32::ODBC::Error()); exit; } my $db2 = new Win32::ODBC($Con); if (! $db2) { &Log($LogFile, "Error connecting db2($Con): " . Win32::ODBC::Error()); exit; } -----Original Message----- From: Simon Horn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 11:27 PM To: '[EMAIL PROTECTED]' Subject: Create ODBC DSN Remotely..?.. Hi, I was wondering if it was possible to create an ODBC System DSN remotely to a bunch of servers? I can currently successfully create a System DSN locally using Win32::ODBC, but have a requirement to create the same connection on a heap of servers. Any help on this would be appreciated. Cheers, Simo Simon Horn Mincom [EMAIL PROTECTED] Phone +61 (0) 7 3364 9876 Fax +61 (0) 7 3364 9777 <http://www.mincom.com> Mincom. The People. The Experience. The Vision. This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. _______________________________________________ Perl-Win32-Admin mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
