in reply to Access to MS Server
You can write code to set up the data source. I've only done it using Win32::ODBC.
use strict; use warnings; use Win32::ODBC; my $server = 'matt'; my %data_source = Win32::ODBC::DataSources(); if (not defined($data_source{$server})) { # # Create a system DSN to the SQL Server # if (!Win32::ODBC::ConfigDSN(ODBC_ADD_SYS_DSN, 'SQL Server', ( "DSN=$server", "DESCRIPTION=$server", "SERVER=$server", 'DATABASE=First_trial', 'NETWORK=DBMSSOCN' ) )) { die "Unable to create DSN for $server"; } }
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Re: Access to MS Server
by Win (Novice) on Nov 10, 2003 at 10:40 UTC | |
by monktim (Friar) on Nov 12, 2003 at 22:48 UTC | |
A reply falls below the community's threshold of quality. You may see it by logging in. |
In Section
Seekers of Perl Wisdom