in reply to Re: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
in thread Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
First of all thankyou for replying to my query. I have checked odbcinst.ini file and i have a different driver name Please find the below details
[SQL Server Native Client 11.0] Description=Microsoft SQL Server ODBC Driver V1.0 for Linux Driver= /.../..../libsqlncli-11.0.so.1790.0 Threading=1 UsageCount=1
Now i have modified the code as below
my$dbh1 = DBI->connect("dbi:ODBC:DRIVER={SQL Server Native Client 11.0 +};Server=abc.cde.corp.org\\XYZ;Database=TEST;UID=$user;PWD=$password" +);
Now i got a different error Please find the below
DBI connect('DRIVER={SQL Server Native Client 11.0};Server=abc.cde.cor +p.org\XYZ;Database=TEST;UID=abc;PWD=defv','',...) failed: [unixODBC][ +Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed (SQL +-IM004)
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
by mje (Curate) on Feb 12, 2013 at 13:55 UTC | |
by venu_hs (Novice) on Feb 12, 2013 at 14:15 UTC | |
by mje (Curate) on Feb 12, 2013 at 14:53 UTC | |
by venu_hs (Novice) on Feb 12, 2013 at 15:28 UTC | |
by mje (Curate) on Feb 12, 2013 at 15:47 UTC | |
|
In Section
Seekers of Perl Wisdom