I'd be glad for any insight into a connection string problem. Here's the
code from the original post. Do you [or anyone else] see any problems in the
code?
> Here's the stripped down code which does not work as a DSNless connection.
> -----------------------------------------
> use strict;
> use DBI;
>
> my ($strDBServer, $dsnSQL_Server, $dbhSQL_Server);
>
> $dsnSQL_Server = "Driver={SQL
Server};Server=rpt-nt01;Database=DatabaseName";
>
> $dbhSQL_Server = DBI->connect("dbi:ODBC:$dsnSQL_Server", "UserID",
"UserPassword",
> {RaiseError => 1, PrintError => 1, AutoCommit => 1
> } ) or die "Connection to SQL Server Application Support
database failed: " . $DBI::errstr . "\n";
>
>
> $dbhSQL_Server->disconnect;
> -----------------------------------------
-----Original Message-----
From: Bart Lateur [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 11, 2001 11:06 AM
To: Dbi-Users
Subject: Re: DSN vs. DSNless connection
On Thu, 11 Oct 2001 10:35:50 -0500, Ron Rohrssen wrote:
>I guess I'll break down and go back to a DSN connection. I hate to do this.
>This sort of seems like a Perl DBI problem. But, I don't know what to look
>for when stepping into DBI.
Perhaps it's your connection string syntax.
--
Bart.
