SQL2K Errors

[XMan]

Does SQL2K return the true error number and description to Access when
there's a problem? I've got # 3151 and message of "ODBC--connection to
'DIALog Test' failed.".

However there's a different description from SQL2K manual: "The master
database failed to restore. Use the rebuildm utility to rebuild the master
database. Shutting down SQL Server.".

What's going on? TIA.

 

[Dirk Goldgar]

Does SQL2K return the true error number and description to Access when
there's a problem? I've got # 3151 and message of "ODBC--connection to
'DIALog Test' failed.".

However there's a different description from SQL2K manual: "The master
database failed to restore. Use the rebuildm utility to rebuild the
master database. Shutting down SQL Server.".

What's going on? TIA.

The VBA Error object displays only the highest-level gloss on the error
that occurred on the server. The DBEngine.Errors collection gives the
set of errors that actually occurred, from lowest level to highest. See
the online help for the Errors collection for more details and examples.

I don't know whether the lowest-level error you'll see in this
collection is exactly the same as the one generated by SQL Server, or
whether it will be one generated within the ODBC driver itself. But
inspection of the collection should tell you which is the case.