from perldoc DBD::ODBC
Example (using MSSQL Server):
my $DSN = 'driver={SQLServer};Server=server_name;
database=database_name;uid=user;pwd=password;';
my $dbh =DBI->connect("dbi:ODBC:$DSN") or die "$DBI::errstr\n";
At 09:18 AM 5/4/2001 +0200, justin todd wrote:
>Hi all.
>
>I am running a IIS webserver and a separate MSSQL database.
>
>Could anyone please tell me what the connection string will look like to
>access a database on a separate server.
>
>This is what I have so far.
>
>$dbh = DBI->connect("DBI:ODBC:database name","username");
>
>This is obviously to connect to the same machine though.
>
>Thanks folks
>Justin
