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
