I get an ODBC error.

A. If you get the error "The ODBC catalog stored proceduresinstalled on server xxx are version x.xx.xxx, version yy.yyy.yyyy or later isrequired to ensure proper operation." then this is caused when the ODBCclient code is upgraded and the server stored procedures are not. You canusually find a file called "INSTCAT.SQL" in your system32directory. Or you can download the latest drivers including this file fromwww.microsoft.com/data - they are part of the MDAC "product" whichincludes all odbc/rdo/ado/ole-db etc. database access drivers.

Run the INSTCAT.SQL file against the relevant SQL Server(s) using ISQL/ISQLWor any other query tool.