Skip to Content
0
Aug 09, 2016 at 07:41 AM

Error in configuring CIS on ASIQ

104 Views

Dear All,


I'm just trying to configure the IQ connect to another IQ via ODBC. So here are the steps --

1. I create a file name .odbc.ini in $SYBASE

asiq160@bigDataIQ:~> set|grep SYBASE

SYBASE=/asiq160

SYBASE_JRE7=/asiq160/shared/JRE-7_0_7_64BIT

SYBASE_JRE7_32=/asiq160/shared/JRE-7_0_7_32BIT

SYBASE_JRE7_64=/asiq160/shared/JRE-7_0_7_64BIT

SYBASE_OCS=OCS-15_0

asiq160@bigDataIQ:~> cat .odbc.ini

[IQ_r1]

Description=SAP IQ 16 mpxtest_r1

Driver=/asiq160/IQ-16_0/lib64/libodbc.so

EngineName=mpxtest_r1

Database=mpxtest

Commlinks=tcpip(host=10.128.244.161;port=2642)


2. Then login the IQ server to add a remote server --

create server r1 class 'SAODBC' using 'IQ_r1';

create externlogin dba to r1 remote login dba identified by sql;


3. Then the test fails --

(DBA)> forward to r1 {select @@servername};

Could not execute statement.

Unable to connect to server 'r1': [Sybase][ODBC Driver][SQL

Anywhere]Connection error: TCPIP requires a server name

SQLCODE=-656, ODBC 3 State="HY000"

Line 1, column 1

forward to r1 {select @@servername}

Press ENTER to continue...


I think I've already put the servername to the dsn file and it can work fine with dbisql --

asiq160@bigDataIQ:~> dbisql -c "dsn=IQ_r1;uid=dba;pwd=sql" -nogui

(DBA)> select @@servername;

@@servername

--------------------------------------------------------------------------------------------------------------------------------

mpxtest_r1

(1 rows)

Execution time: 0.033 seconds

So I don't know what's the error in that remote server configuration. Would anyone help on this? Thanks in advance for any idea.


Regards

Eisen