Re: installing DBD-Informix on fedora 6

On 29/01/07, Oliver Howe <oliverj@xxxxxxxxxxxxxxxxxxx> 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

[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;


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
.

Relevant Pages

  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Remobjects v KBM
    ... >> client query components) follow from that. ... Then, connections can be created to say SQL Server, Oracle, Interbase and ... can then be created from the abstract dataset definition in 'customers' to ... implicitly - this makes your code not be database connection specific). ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Help with first VB application - Data Entry form
    ... stamp from the database machine - control machine ... ... unnecessary data to the client ... ... and when building a database independent UI / Client - Server application, ... JavaScript, for example) and thus, will get the time from the web server, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Opinions needed about the best "Middleware suite" kbmMW vs. RODA
    ... kbmMW supports cross db in such way that all you need to do in your application is to set one property to switch to ... What one have to concentrate about is minimizing the amount of data moved from the app server to the client. ... C/S setup's usually have a quite active chatter going on between the client and the database, ...
    (borland.public.delphi.thirdpartytools.general)