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