Hi all,

We have client PC running RedHat 9.0, Qt 3.2.3 and server PC running the
same RedHat and ASA 8.0. ASA is running asademo database with sample
Test table. The server command line is:

dbsrv8 -n asademo /opt/sybase/SYBSsa8/asademo.db -x TCPIP{"ServerPort=4000"}

Test table is really nothing special : primary key, a couple of integer
columns, double, and a couple of char(64) columns. Only 10
records. Server logging is off.

dbisql, being running on the client, works well - no any delays, very
fast. So the server is up and running and available from the client.

We have developed some application ("data viewer") displaying data from
sql tables and refreshing the screen once a second. Data viewer uses
Qt's database module to talk to different database engines. Qt's
database module includes wrapppers for MySQL,Postgres,TDS,Oracle,ODBC...
So you can build specific driver using wrapper plus database specific api.

As far as I know, ODBC is native protocol for ASA. Also ASA comes with
odbc libraries. So we build Qt odbc driver using Qt ODBC wrapper,
compiling it against ASA's /opt/sybase/SYBSsa8/lib/dbodbc8_r.so.

In general it works, but very slow. Every time we get timer signal and
read data from test table - we experiece ~2sec delay reading those 10
records.The delay is shorter if I have just 1 record, and longer if I
have more than 10 records. Its not take forever in case of 100.000
records as data viewer reads in only visible portion of data

I have to say that the same data viewer is able to display that test
table with 100.000 records with no any delay in case it's accessing
MySQL.

Looks like i have problem either with ODBC driver or ODBC configuration.
I tried to build driver againsts /opt/sybase/SYBSsa8/lib/dbodbc8.so and
/opt/sybase/SYBSsa8/drivers/libodbc.so. The delay is still here

This is my .odbc.ini:

[asademo]
Driver=/opt/sybase/SYBSsa8/lib/dbodbc8_r.so
UID=dba
PWD=sql
ServerName=asademo
Host=linuxsrv
CommLinks=tcpip{host=linuxsrv;serverport=4000;dobr oadcast=none}
Trace=0

What else I can try? Where can be a problem? Did anybody get it to
work (ASA's odbc driver+Qt ODBC wrapper)?

Any help would be highly appreciated,
Thanks,

Gennadiy Gladchun