ODBC Failing under W2K

ODBC Failing under W2K

Post by Ric Shumac » Wed, 10 Sep 2003 08:40:19


We have a large application written in Access97 which uses
a SQL Server 7 database. Recently, some of the clients
using this system had their PC's upgraded to W2K.

We had succesfully been using the RPC call syntax from
within Access, however on the W2K machines it no longer
works, and we have had to revert to the "Exec" style of
StoreProc call only.

We have tried various versions of ODBC drivers - and the
DBA's here have run ComCheck without any useful results.

Is this an ODBC driver version issue, or a known problem
with Access 97? Any help would be appreciated.