Hi all,

i have problem with performance of opening connection over ODBC
connection. When I create ODBC connection, put server address and click
on button Get DSN list (get names of databases on Pervasive server) it
shows me immediately databases; then i click on button Test, then it
takes long time to confirm that connection is OK. It takes about 6-8
seconds.

The same problem happens:
- if I connect over PCC; the names of databases are show immediately,
but the tables takes longer (if in database is 5 tables or 40 tables,
it takes the "same" time)
- if I try to connect with WinSQL over this ODBC it takes also 6-8
seconds
- in code, opening connection also takes a long time; here is sample
code:
SQLEXEC( SQLCONNECT('pl_sys'),"select * from memopolje","test1")
pl_sys is the name of ODBC
- if i try open connection with ADO, OPEN connection takes also 6-8
seconds

When the connection is open, then selects, updates... runs normaly.

I am using Pervasive 2000i on Novell Netware and WinXP client (client
2000i with SP4); ODBC drivers are marked with version 7.90.230.36 (date
21.3.2001); we use SPX protocol.

Is there any solution to "remove" that lateness?

Thanks for some solution, idea...

Toni

Hi, Toni,

You probably also have TCP/IP selected as an available Communication
Protocol in your client configuration settings in the PCC.

Wayne Freeman
Analytica Business Systems
www.analyticabiz.com

cugmas (AT) gmail (DOT) com ha scritto:

For Pervasive.SQL 2000i the SQL engine only used one protocol. The
setting was listed as "MGR Use Transport" or the like. It could be
set to SPX or TCP. If it is currently SPX and SPX is slow to connect
you may have better luck using TCP.

Switch it over to TCP and make sure that TCP DNS name resolution is
working. A hosts file entry is adequate.

Leonard

On 13 Sep 2006 12:39:41 -0700, "Wayne" <sales (AT) analyticabiz (DOT) com> wrote: