3043880 - " The LOCATION string passed to the attached database insert is invalid."

• Created a server in IQ to link to ASE, the select @@version works, but insert does not:

create server my_ase class 'ASEODBC' using 'DRIVER=/work/IQ16.1sp4pl4/IQ-16_1/lib64/libsybdrvodb.so;Server=myserver.xxx.corp;port=5000;Database=mydb'

forward to my_ase {select @@version}

expr_1
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/16.0 SP04 GA/EBF 29650 SMP/P/x86_64/SLES 12.4/asecorona/3202/64-bit/FBO/Wed Nov 18 09:12:58 2020

• However, receive the following error when trying to insert data:

insert into DBA.mytable location 'my_ase.mydb' {select * from mytable}

isql:
Msg 21, Level 14, State 0:
SQL Anywhere Error -1003002: CtLibrary Error: 3, Severity: 0, Origin: 8, Layer: 6
Error Message: ct_connect(): directory service layer: internal directory
control layer error: Requested server name not found.
OS Error: 0, OS Message: .

or
dbisql:

Could not execute statement.
The LOCATION string passed to the attached database insert is invalid.
-- (optlib/opt_Insert.cxx 524)
SQLCODE=-1000226, ODBC 3 State="HY000"
Line 1, column 1
insert mytable location 'my_ase' 'SELECT * FROM mytable'
Press ENTER to continue...

SAP IQ

KBA , BC-SYB-IQ , Sybase IQ , How To