Connection between SQL Server 2000 SP3a and ODBC Driver -- sql server connect

desimaj
3/12/2005 3:43:02 PM

Database: SQL Server 2000 Developer Edition SP3a
Frontend: MS Access 2000 and Access 2003
A Custm-built Medical Records Database

I am having a problem connecting to my SQL server with certain ODBC drivers
(sqlsrv32.dll). But it only acts up on certain "forms" in the Database, in
particular ones which retrieve from lots of columns. On these forms there is
a long delay, and a little of the data is retrieved, but the rest of fields
arent. And there are no error messages.

I am trying to connect to a MS-SQL Server 2000 SP3a database through Access
2003 (frontend of database) on our only XP machine. All my NT machines
connect
easily, with no problems. A handful of Windows 2000 machines give me
problems with the newer ODBC drivers, but if i would replace the
SQLSRV32.DLL with a copy from the NT machines it would work ok.

I thought upgrading the Service Pack from SP2 to SP3a would help but that
didnt work. I cant figure out what the problem is, but it sounds (to me)
similar to what is described in (FIX 814410 -
http://support.microsoft.com/kb/814410 ) as a "memory leak"...could this be
it? but the SP upgrade didnt fix/help....

Please advise how I can fix it, or where i can look to figure out what the
problem is.

Thank you.

John Bell
3/20/2005 4:18:51 PM

Hi

SQL Profiler will indicate what queries are running slow. Try running it
from Query Analyser and check out their query plan. You may also want to
look at the statistics and how often they are updated. You may also want to
check the

Also you may want to check the version of MDAC you are running on each
machine using the MDAC component checker
http://msdn.microsoft.com/data/mdac/default.aspx

John

[quoted text, click to view]

sql server connect : Connection between SQL Server 2000 SP3a and ODBC Driver