how to query a remote microsort sql database from AIX?

CSIA AN
CSIA AN used Ask the Experts™
on
I need to query a remote microsoft database, no matter which version, from an AIX box.

Is there any free jdbc driver or something similar for AIX OS?

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Not pretty sure work for AIX but from here you can download ODBC driver for SQL server on Linux

https://msdn.microsoft.com/en-us/library/hh568451(v=sql.110).aspx

http://download.openlinksw.com/downwiz/product_matrix.vsp?p=l_os&c=28&df=2

Author

Commented:
Hi,
Thanks for reply.

No, first link is only for Linux..

Second link it's available for an unsuported version of AIX 5.3.
Most Valuable Expert 2013
Top Expert 2013
Commented:
Hi,

I'm not really familiar with this kind of stuff, but did you look at Michael Perzl's site?

He has UnixODBC: http://www.perzl.org/aix/index.php?n=Main.UnixODBC

Please don't worry that the description says "a complete ODBC solution for the Linux platform."
Michael ported this thing to AIX.
Further, don't worry about the package name containing "aix51". Usually, if there is no newer version, the packages are version-independent - more or less.

I think it might be worth a try, but please bear with me - I never used it.

wmp

Author

Commented:
Hi wmp,

I have installed but I'm dont know how to test this ODBC and be sure if it can be connected to a MSSQL database. I'll try and let you know.

(node1):[root] /usr/local/bin -> rpm -ivh /unixODBC-2.3.2-1.aix5.1.ppc.rpm
unixODBC                    ##################################################
(node1):[root] /usr/local/bin -> rpm -ql unixODBC
/opt/freeware/bin/dltest
/opt/freeware/bin/dltest_64
/opt/freeware/bin/isql
/opt/freeware/bin/isql_64
/opt/freeware/bin/iusql
/opt/freeware/bin/iusql_64
/opt/freeware/bin/odbc_config
/opt/freeware/bin/odbc_config_64
/opt/freeware/bin/odbcinst
/opt/freeware/bin/odbcinst_64
/opt/freeware/bin/slencheck
/opt/freeware/bin/slencheck_64
/opt/freeware/doc/unixODBC-2.3.2
/opt/freeware/doc/unixODBC-2.3.2/AUTHORS
/opt/freeware/doc/unixODBC-2.3.2/COPYING
/opt/freeware/doc/unixODBC-2.3.2/ChangeLog
/opt/freeware/doc/unixODBC-2.3.2/NEWS
/opt/freeware/doc/unixODBC-2.3.2/README
/opt/freeware/doc/unixODBC-2.3.2/doc
/opt/freeware/doc/unixODBC-2.3.2/doc/AdministratorManual
/opt/freeware/doc/unixODBC-2.3.2/doc/AdministratorManual/Makefile
/opt/freeware/doc/unixODBC-2.3.2/doc/AdministratorManual/Makefile.am
/opt/freeware/doc/unixODBC-2.3.2/doc/AdministratorManual/Makefile.in
/opt/freeware/doc/unixODBC-2.3.2/doc/AdministratorManual/index.html
/opt/freeware/doc/unixODBC-2.3.2/doc/AdministratorManual/odbcinst.html
/opt/freeware/doc/unixODBC-2.3.2/doc/AdministratorManual/php3.html
/opt/freeware/doc/unixODBC-2.3.2/doc/AdministratorManual/unixODBC.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/AdministratorManual/unixODBCsetup.html
/opt/freeware/doc/unixODBC-2.3.2/doc/Makefile
/opt/freeware/doc/unixODBC-2.3.2/doc/Makefile.am
/opt/freeware/doc/unixODBC-2.3.2/doc/Makefile.in
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Makefile
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Makefile.am
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Makefile.in
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/Makefile
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/Makefile.am
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/Makefile.in
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/close.html
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/conne.html
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/dsn.html
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/gloss.html
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/index.html
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/intro.html
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/navi.html
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/odbc.css
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/query.html
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/Tutorial/resul.html
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/index.html
/opt/freeware/doc/unixODBC-2.3.2/doc/ProgrammerManual/unixODBC.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual/Figure1.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual/Figure2.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual/Figure3.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual/Figure4.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual/Figure6.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual/Makefile
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual/Makefile.am
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual/Makefile.in
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual/My.sql
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual/StarOfficeDataGrid.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual/index.html
/opt/freeware/doc/unixODBC-2.3.2/doc/UserManual/unixODBC.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/index.html
/opt/freeware/doc/unixODBC-2.3.2/doc/lst
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure.html
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure.vsd
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure2.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure2.html
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure3.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure3.html
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure4.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure4.html
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure5.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure5.html
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure6.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure6.html
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure7.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure7.html
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure8.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure8.html
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure9.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/InternalStructure9.html
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/Makefile
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/Makefile.am
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/Makefile.in
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/back.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/lst/next.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/smallbook.gif
/opt/freeware/doc/unixODBC-2.3.2/doc/unixODBC.gif
/opt/freeware/etc/odbc.ini
/opt/freeware/etc/odbcinst.ini
/opt/freeware/lib/libodbc.a
/opt/freeware/lib/libodbc.so
/opt/freeware/lib/libodbc.so.2
/opt/freeware/lib/libodbc.so.2.0.0
/opt/freeware/lib/libodbccr.a
/opt/freeware/lib/libodbccr.so
/opt/freeware/lib/libodbccr.so.2
/opt/freeware/lib/libodbccr.so.2.0.0
/opt/freeware/lib/libodbcinst.a
/opt/freeware/lib/libodbcinst.so
/opt/freeware/lib/libodbcinst.so.2
/opt/freeware/lib/libodbcinst.so.2.0.0
/opt/freeware/lib64/libodbc.so
/opt/freeware/lib64/libodbc.so.2
/opt/freeware/lib64/libodbc.so.2.0.0
/opt/freeware/lib64/libodbccr.so
/opt/freeware/lib64/libodbccr.so.2
/opt/freeware/lib64/libodbccr.so.2.0.0
/opt/freeware/lib64/libodbcinst.so
/opt/freeware/lib64/libodbcinst.so.2
/opt/freeware/lib64/libodbcinst.so.2.0.0
/usr/bin/dltest
/usr/bin/dltest_64
/usr/bin/isql
/usr/bin/isql_64
/usr/bin/iusql
/usr/bin/iusql_64
/usr/bin/odbc_config
/usr/bin/odbc_config_64
/usr/bin/odbcinst
/usr/bin/odbcinst_64
/usr/bin/slencheck
/usr/bin/slencheck_64
/usr/lib/libodbc.a
/usr/lib/libodbc.so
/usr/lib/libodbc.so.2
/usr/lib/libodbc.so.2.0.0
/usr/lib/libodbccr.a
/usr/lib/libodbccr.so
/usr/lib/libodbccr.so.2
/usr/lib/libodbccr.so.2.0.0
/usr/lib/libodbcinst.a
/usr/lib/libodbcinst.so
/usr/lib/libodbcinst.so.2
/usr/lib/libodbcinst.so.2.0.0
/usr/lib64/libodbc.so
/usr/lib64/libodbc.so.2
/usr/lib64/libodbc.so.2.0.0
/usr/lib64/libodbccr.so
/usr/lib64/libodbccr.so.2
/usr/lib64/libodbccr.so.2.0.0
/usr/lib64/libodbcinst.so
/usr/lib64/libodbcinst.so.2
/usr/lib64/libodbcinst.so.2.0.0

Open in new window


Thanks.

Author

Commented:
Well.. It seems you can use unixODBC with FreeTDS ODBC to acess Microsoft's SQL Databases. See here:

http://www.unixodbc.org/doc/FreeTDS.html

And it's also rpms for freetds are on perzl:  http://www.perzl.org/aix/index.php?n=Main.Freetds

That sounds good ;)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial