in reply to DBI + SQL Server AND Special Character
HTHuse strict; use DBI; my $server_name = 'FOO'; my $database_name = 'bar'; my $database_user = 'baz'; my $database_pass = 'xyzzy'; my $DSN = "driver={SQL Server};Server=$server_name;database=$database_ +name;uid=$database_user;pwd=$database_pass;"; my $dbh = DBI->connect("dbi:ODBC:$DSN") or die $DBI::errstr; my $sth = $dbh->prepare('EXEC my_stored_procedure'); $sth->execute or die $DBI::errstr; # ... $dbh->disconnect;
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: DBI + SQL Server AND Special Character
by Zitoune (Beadle) on Nov 05, 2002 at 17:13 UTC |