Re: issues connecting with perl DBD::ODBC

"Dan Wierenga" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <24CF2B9B9D2BCC4B8F6EA9528B63C8360D45D338@LA-EXCLUST01.corp.valueclick.com>
> -----Original Message-----
> From: [email protected] [mailto:freetds-
> [email protected]] On Behalf Of Kulik, Scott
> 
> Anyone have any luck getting connected to a SQL server database with
> DBD::ODBC in perl?  I'm hoping to try to get this issue fixed this
week
> but I'm out of ideas.
> 
> Here is the output from the script:
> 
> [root@trafficdev1 root]# ./test_odbc.pl
> 
> Unable for connect to server  at ./test_odbc.pl line 7.

When my setup references an invalid host in the connection string, I
get:
Unable for connect to server [unixODBC][FreeTDS][SQL Server]Unable to
connect to data source (SQL-08001)(DBD: db_login/SQLConnect err=-1)

And not the blank $DBI::errstr that you get.   The blank errstr is
really odd.   When things mysteriously die on Redhat servers with no
error messages, I'm always inclined to have a look at the SELinux logs
to see if SELinux is bushwhacking my connections silently.  You might
try looking there.

HTH,
Dan




This email and any files included with it may contain privileged,
proprietary and/or confidential information that is for the sole use
of the intended recipient(s).  Any disclosure, copying, distribution,
posting, or use of the information contained in or attached to this
email is prohibited unless permitted by the sender.  If you have
received this email in error, please immediately notify the sender
via return email, telephone, or fax and destroy this original transmission
and its included files without reading or saving it in any manner.
Thank you.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.