|
Home > Archive > IQ Server > December 2005 > Error 1003002 occurs when execute "insert ... location 'ASE_servername.DB_name' ..."
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error 1003002 occurs when execute "insert ... location 'ASE_servername.DB_name' ..."
|
|
| Johnyu 2005-12-10, 7:23 am |
| I have created publishers table in IQ 12.6 database and have
added login account DBA and dba in ASE server. When I
execute the following command on IQ 12.6 database I got the
error 1003002 even though the ASE server name is in
interfaces file
for IQ Open Client.
isql -UDBA -PSQL -Sasiqdemo -Jiso_1
1>insert into publishers (pub_id, pub_name, city, state)
2> location 'PDS.pubs2'
3> packetsize 512
4> {select pub_id, pub_name, city, state from
dbo.publishers}
5> go
Msg 21, Level 14, State 0:
ASA Error -1003002: CtLibrary Error: 44, Severity: 0,
Origin: 1, Layer: 4
Error
Message: ct_connect(): protocol specific layer: external
error: The attempt to
connect to the server failed.
OS Error: 0, OS Message: ---.
-- (hqm_con.cxx 125)
Could you please point out what is wrong and how could I
solve this problem?
Thanks in advance.
John Yu
| |
|
| without knowing more details i would say this...i am doing
'insert locations' also and to get it to wortk i set up the
user id's on Ase and IQ *exactly* the same...meaning both id
and password are the same. i noticed you have DBA and dba
(different case)...try setting up a new user, for example,
"load_iq", on both Ase and IQ with the same password.
> I have created publishers table in IQ 12.6 database and
> have added login account DBA and dba in ASE server. When I
> execute the following command on IQ 12.6 database I got
> the error 1003002 even though the ASE server name is in
> interfaces file
> for IQ Open Client.
>
> isql -UDBA -PSQL -Sasiqdemo -Jiso_1
>
> 1>insert into publishers (pub_id, pub_name, city, state)
> 2> location 'PDS.pubs2'
> 3> packetsize 512
> 4> {select pub_id, pub_name, city, state from
> dbo.publishers}
> 5> go
>
> Msg 21, Level 14, State 0:
> ASA Error -1003002: CtLibrary Error: 44, Severity: 0,
> Origin: 1, Layer: 4
> Error
> Message: ct_connect(): protocol specific layer: external
> error: The attempt to
> connect to the server failed.
> OS Error: 0, OS Message: ---.
> -- (hqm_con.cxx 125)
>
> Could you please point out what is wrong and how could I
> solve this problem?
>
> Thanks in advance.
>
> John Yu
|
|
|
|
|