comment on

Help!!! We installed the new mssql driver (https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-tools#a-idrhelainstall-tools-on-rhel-7) on RHEL 7 .. Can connect via sqlcmd without issues, but cannot connect via perl

odbcinst -j

unixODBC 2.3.1

DRIVERS............: /etma/bin/conf/odbcinst.ini

SYSTEM DATA SOURCES: /etma/bin/conf/odbc.ini

FILE DATA SOURCES..: /etma/bin/conf/ODBCDataSources

USER DATA SOURCES..: /home/etmadev/.odbc.ini

SQLULEN Size.......: 8

SQLLEN Size........: 8

SQLSETPOSIROW Size.: 8
[download]

Using DBI ver 1.616 and DBD::ODBC 1.31getting this: '[unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.1.so.9.0' : file not found (SQL-01000)'

However, that driver is successfully installed.... Any pointers please?........ Thank you... We had no issues on RHEL5...+

2017-09-27 Athanasius added code and paragraph tags

In reply to connecting to mssql on rhel7 with new mssql driver by vcoderv2

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Problems? Is your data what you think it is?
	PerlMonks