>> pmuk2 onsoctcp dbpmuk2.uk1.bibliotech.net sqlexec k=1
>
>Seems all right. Can you post the relevant entry from /etc/services?
$ tail -4 /etc/services
# Local services
sqlexec 1526/tcp informix
sqlispy 1527/tcp informix
sqlispy1 1528/tcp informix
>
>> CONNECT TO 'stores' with user info
>>
>> 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 compile and run esqlbasic?
yes, but i get the same output as before
[EMAIL PROTECTED] DBD-Informix-2005.02]# esql -o ./esqlbasic esqlbasic.ec &&
./esqlb asic
esqlc: "esqlbasic.ec", line 93: Warning -33036: This line does not conform to
AN SI X3.135-1989.
esqlc: "esqlbasic.ec", line 103: Warning -33036: This line does not conform to
A NSI X3.135-1989.
esqlc: "esqlbasic.ec", line 158: Warning -33036: This line does not conform to
A NSI X3.135-1989.
3 warning(s)
$DBI_DBNAME set to 'stores'.
$DBD_INFORMIX_DATABASE set to 'stores'.
Testing connection to stores
SQL: -908: Attempt to connect to database server (pmuk2) failed.
ISAM: 107: ISAM error: record is locked.
You cannot use stores as a test database.
You do not have sufficient privileges.
SQL: -908: Attempt to connect to database server (pmuk2) failed.
ISAM: 107: ISAM error: record is locked.
You cannot use stores as a test database.
You do not have sufficient privileges.
SQL: -908: Attempt to connect to database server (pmuk2) failed.
ISAM: 107: ISAM error: record is locked.
*** Your Informix environment is not usable
*** You must fix it before building or testing DBD::Informix
[EMAIL PROTECTED] DBD-Informix-2005.02]#
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;
>
>--tielman
--
Oliver Howe
Senior Systems Administrator
Tel: +44 (0) 79 7420 6484
Fax: +44 (0) 20 7664 7878
Spider Networks - the power behind interactive web communications -
www.spider-networks.net
--
Confidentiality Notice: This email is confidential and may also be privileged.
If you are not the intended recipient, please notify the sender IMMEDIATELY;
you should not copy the email or use it for any purpose or disclose its
contents to any other person. General Statement: Any statements made, or
intentions expressed in this communication, may not necessarily reflect the
view of Spider Networks, that no content herein may be held binding upon Spider
Networks or any associate or any associated company unless confirmed by the
issuance of a formal contractual document or purchase order.
