[unixODBC-support] [S1000][DataDirect][ODBC SQL Server Driver]

Fahad Ali fahad01hbti at gmail.com
Wed Nov 20 09:17:51 GMT 2013


I have a Microsoft sql server installed on windows 2008 R2 server. I am
trying to connect to sql server from linux machine. I have installed the
unixODBC manager and driver.

I am able to connect and see the below output
[root at MUMLPBMAMTDV001 config]# isql -v MOMDB MOMDBUSER Pbcms at 1234
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |

After that, it is showing me error whenever I am trying to run any query,

[S1000][DataDirect][ODBC SQL Server Driver]@Ô¿
[S1000][DataDirect][ODBC SQL Server Driver]
[ISQL]ERROR: Could not SQLPrepare

My linux machine is -   Linux MUMLPBMAMTDV001 2.6.18-348.6.1.el5 #1 SMP Fri
Apr 26 09:21:26 EDT 2013 x86_64 x86_64 x86_64 GNU/Linux

SQl Driver - file /sasinst/sqlodbc/lib/S0msss22.so
/sasinst/sqlodbc/lib/S0msss22.so: ELF 64-bit LSB shared object, AMD x86-64,
version 1 (SYSV), not stripped
[root at MUMLPBMAMTDV001 config]# ldd /sasinst/sqlodbc/lib/S0msss22.so
        linux-vdso.so.1 =>  (0x00007fff96f6f000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00002b6b9bbeb000)
        libS0icu22.so => /usr/lib64/libS0icu22.so (0x00002b6b9be08000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00002b6b9c9aa000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00002b6b9cbc2000)
        libc.so.6 => /lib64/libc.so.6 (0x00002b6b9cdc7000)
        libstdc++.so.5 => /usr/lib64/libstdc++.so.5 (0x00002b6b9d11f000)
        libm.so.6 => /lib64/libm.so.6 (0x00002b6b9d3fa000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00002b6b9d67e000)
        /lib64/ld-linux-x86-64.so.2 (0x0000003211200000)

Can someone please suggest me what is going wrong ?


*Thanks & Regards,Fahad Ali*
*Mob: +91 9535 086 088*
E-mail: fahad01hbti at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20131120/3acec1bd/attachment-0001.html>

More information about the unixODBC-support mailing list