DanBev has asked for the wisdom of the Perl Monks concerning the following question:
Hi monks, I've an issue connecting to MS SQL Server with DBI. I've read all tutorials and configurations of TDS but my code still not works...
Simply I try my $dbh = DBI->connect(DBI:Sybase:server=xx.xx.xx.xx, "USERNAME", "PASSWORD") ; and the error is
DBI connect('server=xx.xx.xx.xx','USERNAME',...) failed: OpenClient me +ssage: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (41) Server xx.xx.xx.xx, database Message String: Unable to connect: Adaptive Server is unavailable or d +oes not exist at check_ultima_chiamata.pl line 19 Cant' connect to database: OpenClient message: LAYER = (0) ORIGIN = (0 +) SEVERITY = (78) NUMBER = (41) Server xx.xx.xx.xx, database Message String: Unable to connect: Adaptive Server is unavailable or d +oes not exist
My TDS configuration is
[xx.xx.xx.xx] host = xx.xx.xx.xx port = 1433 tds versione = 7.0
Instead, trying in shell it works
root@___# /usr/local/freetds/bin/tsql -S xx.xx.xx.xxx -U USER Password: locale is "it_IT.UTF-8" locale charset is "UTF-8" using default charset "UTF-8" 1>
Please help me to understand...
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: issue with DBI and MS SQL SERVER
by blue_cowdawg (Monsignor) on Sep 15, 2014 at 14:26 UTC | |
by DanBev (Scribe) on Sep 15, 2014 at 14:50 UTC | |
Re: issue with DBI and MS SQL SERVER
by GotToBTru (Prior) on Sep 15, 2014 at 14:55 UTC | |
by DanBev (Scribe) on Sep 15, 2014 at 15:01 UTC | |
by Anonymous Monk on Sep 15, 2014 at 22:46 UTC | |
by DanBev (Scribe) on Sep 16, 2014 at 07:53 UTC | |
Re: issue with DBI and MS SQL SERVER
by GotToBTru (Prior) on Sep 15, 2014 at 14:48 UTC |
Back to
Seekers of Perl Wisdom