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.