Re: Pervasive ODBC connection & clicking test = very slow?

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@xxxxxxxxx ha scritto:

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

.