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.
Is there any free jdbc driver or something similar for AIX OS?
Thanks.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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
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
Hi,
Thanks for reply.
No, first link is only for Linux..
Second link it's available for an unsuported version of AIX 5.3.
Thanks for reply.
No, first link is only for Linux..
Second link it's available for an unsuported version of AIX 5.3.
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
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
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.
Thanks.
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
Thanks.
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 ;)
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 ;)
Premium Content
You need an Expert Office subscription to comment.Start Free Trial