Slow ODBC connection after updateing to SQL server

[Sam]

We have installed SQL 7.0 Client to connect to the SQL server 7.0. After installing the client (which updated all ODBC drivers) the database connections, even ODBC calls using MS access drivers become extremely slow. Any hints where to look?

[N V K]

Just a thought. Check if you have ODBC tracing enabled. If so, disable it.


------------
Sam at 4/1/99 10:09:26 PM

We have installed SQL 7.0 Client to connect to the SQL server 7.0. After installing the client (which updated all ODBC drivers) the database connections, even ODBC calls using MS access drivers become extremely slow. Any hints where to look?

[st]

I think it can also because of your network protocol. If you are using TCP/IP to connect to your Server put the name and IP of your Server to your HOSTS and LMHOSTS files in your windows directory. You will see a speedup


------------
N V K at 4/5/99 1:24:32 AM

Just a thought. Check if you have ODBC tracing enabled. If so, disable it.


------------
Sam at 4/1/99 10:09:26 PM

We have installed SQL 7.0 Client to connect to the SQL server 7.0. After installing the client (which updated all ODBC drivers) the database connections, even ODBC calls using MS access drivers become extremely slow. Any hints where to look?

[N V K]

Control Panel -> ODBC Admin -> ODBC Tracing tab....
There disable tracing, if it is enabled


------------
Sam at 4/1/99 10:09:26 PM

We have installed SQL 7.0 Client to connect to the SQL server 7.0. After installing the client (which updated all ODBC drivers) the database connections, even ODBC calls using MS access drivers become extremely slow. Any hints where to look?