On 29/01/07, Oliver Howe <[EMAIL PROTECTED]> wrote:
>> SQL: -908: Attempt to connect to database server (pmuk2) failed.
>> ISAM: 107: ISAM error: record is locked.
>>
>
>Seems to suggest you are connecting to the database. Can you trace any
>TCP traffic on the server side?
no i dont see anything from that server when running the esqltest. but on the
client i can telnet to the server on port 1526 as the user informix. i have
stopped iptables and ip6tables on the client
can you snoop on the server to see if any packets reach the interface
at all when running esqltest?
>Can you compile and run esqlbasic?
yes, but i get the same output as before
these are the lines it is complaining about
[EMAIL PROTECTED] DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 93
93 EXEC SQL CREATE TABLE dbd_ix_esqltest (Col01 INTEGER NOT NULL);
[EMAIL PROTECTED] DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 103
103 EXEC SQL DROP TABLE dbd_ix_esqltest;
[EMAIL PROTECTED] DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 158
158 EXEC SQL DATABASE :dbase1;
Can you do "CREATE TABLE dbd_ix_esqltest (Col01 INTEGER NOT NULL);"
from dbaccess on the server in the stores database as the appropriate
user?
Thanks,
--tielman
