Avatar of CSIA AN
CSIA AN
Flag for Andorra asked on

how to query a remote microsort sql database from AIX?

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.
Unix OSMicrosoft SQL ServerLinux

Avatar of undefined
Last Comment
CSIA AN

8/22/2022 - Mon
Deepak Chauhan

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
CSIA AN

ASKER
Hi,
Thanks for reply.

No, first link is only for Linux..

Second link it's available for an unsuported version of AIX 5.3.
ASKER CERTIFIED SOLUTION
woolmilkporc

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
CSIA AN

ASKER
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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
CSIA AN

ASKER
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 ;)