Re: installing DBD-Informix on fedora 6


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

[root@hmmail2 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

[root@hmmail2 DBD-Informix-2005.02]#



these are the lines it is complaining about

[root@hmmail2 DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 93
93 EXEC SQL CREATE TABLE dbd_ix_esqltest (Col01 INTEGER NOT NULL);
[root@hmmail2 DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 103
103 EXEC SQL DROP TABLE dbd_ix_esqltest;
[root@hmmail2 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.
.

Relevant Pages

  • Re: SQL Server 2000 Hardware Recommendations?
    ... Hardware Performance CheckList ... Andrew J. Kelly SQL MVP ... >> trace and see what is taking up all the resources especially cpu. ... Currently the database server houses all data pertinent to ...
    (microsoft.public.sqlserver.server)
  • Re: commit work not working?
    ... Because he is using straight sql, ... The transaction is made up of the statements that occur ... locks the stock table, updates rows in the stock table ... The database server must perform this sequence of operations either ...
    (comp.databases.informix)
  • Re: SQL Server 2000 Hardware Recommendations?
    ... but the compilations/sec is very low, and the cache hit ratio is ... how our SQL queries are structured. ... Currently the database server houses all data pertinent to ... >> whether we simply need new hardware, or if there are things we can do ...
    (microsoft.public.sqlserver.server)
  • RE: Sync DB SQL Server CE and remote MySQL on internet
    ... Safe to say there is no chance of native replication from SQL CE ... from the Pocket PC client to the database server is your best bet for ... across multiple devices, but in most cases this is not too hard to figure out ... i have a local db in the PPC device and MySQL DB on the ...
    (microsoft.public.pocketpc.developer)
  • Re: How do I query a dataset?
    ... There is no real SQL support there. ... > I get how to populate a dataset by querying a database server... ... > In some cases I'd say this is preferable to hitting the database server ... > As an example if I have a populated table of employee data in a dataset ...
    (microsoft.public.dotnet.framework.adonet)