K
KTM
I have a database with linked tables to an SQL 2000 database via an ODBC DSN.
On some computers, the queries return results almost immediately while on
others they take 10 times as long to get results. After performing a number
of traces, I've found that the users with a fast response are performing all
of the queries using SQLExecDirect calls whereas the slow machines are
performing SQLPrepare/SQLExecute calls.
I've compared MDAC settings and drivers and everything is the same (as near
as I can tell). We're using Access 97 SR-2 on Windows XP Pro. All machines
are patched with the latest Jet service packs and SQL drivers. The same
issue occurs with both SQL Server and SQL Native drivers.
Given that both sets of computers are using the same Access 97 database
application, datasources, and identical transactions, does anyone have any
suggestions why I'm seeing a difference?
KTM
On some computers, the queries return results almost immediately while on
others they take 10 times as long to get results. After performing a number
of traces, I've found that the users with a fast response are performing all
of the queries using SQLExecDirect calls whereas the slow machines are
performing SQLPrepare/SQLExecute calls.
I've compared MDAC settings and drivers and everything is the same (as near
as I can tell). We're using Access 97 SR-2 on Windows XP Pro. All machines
are patched with the latest Jet service packs and SQL drivers. The same
issue occurs with both SQL Server and SQL Native drivers.
Given that both sets of computers are using the same Access 97 database
application, datasources, and identical transactions, does anyone have any
suggestions why I'm seeing a difference?
KTM