AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.


#Power
#Power
 View Only

  • 1.  about freetds

    Posted Tue April 10, 2012 09:15 PM

    Originally posted by: kykwon


    Dear freetds master

    I have a aix6.1(64Bit) and i've got packages as belows :
    1.unixODBC-2.3.0
    2.freetds-0.91
    3.gcc-4.2.0-3
    4.libgcc-libgcc
    5.sql-server : mssql2005 installed to 10.x.x.x.

    my problems is step9
    i tried to install thoses :

    export CC="gcc -maix64"
    export OBJECT_MODE=64

    step1 : installed gcc and libgcc
    step2 : cd unixODBC-2.3.0 && ./configure --prefix=/usr/local/ --enable-drivers=yes --enable-gui=no
    make
    make install
    step3 : cd freetds-0.91 && ./configure --with-tdsver=8.0 --with-unixodbc=/usr/local
    make
    make install
    step4 : cd /usr/local/lib
    ar -x -X 64 libtdsodbc.so
    step5 : vi /usr/local/etc/freetds.conf
    KMS
    host = 10.x.x.x
    port = 1433
    tds version = 7.0
    step6 : vi /usr/local/etc/odbcinst.ini
    TDS
    Description = FreeTDS driver
    Driver = /usr/local/lib/libtdsodbc.so.0
    Setup = /usr/local/lib/libtdsodbc.so.0
    Trace = Yes
    TraceFile = /tmp/freetds.log
    FileUsage = 1
    step7 : vi /usr/local/etc/odbc.ini
    KMS
    Driver = TDS
    Description = MS SQL Test
    Trace = Yes
    TraceFile = /tmp/mstest.log
    Servername = 10.x.x.x
    Database = AAAA
    Port = 1433
    step8 : /usr/local/bin/tsql -H 10.x.x.x -p 1433 -U aa -P pp
    1>use AAAA
    2>go
    1>select * from some_table;
    2>go
    ~~~~
    ~~~~ displayied data from ms-sql

    step9 : /usr/local/bin/isql -v KMS aa pp
    IM002unixODBCDriver ManagerData source name not found, and no default driver specified
    ISQLERROR: Could not SQLConnect
    What is my mistake? Please let me know.....plz plz..
    #AIX-Forum


Related Content