SAP Knowledge Base Article - Preview

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

Symptom

  • 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...


Read more...

Environment

SAP IQ

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.