ODBC - call failed

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

We have converted an Access Database to SQL2000 database. When we go into Access and try to open the table, we get the following error: ODBC SQL Server Driver Select permission denied on oject 'database name'. database ICTEC over 'dbo'.(#229)

We have setup the ODBC driver correctly, and have given it the proper permissions.

We can go into the SQL database and access the table with no problem.

Thank you for your help.

Thom Horton

-- Anonymous, December 02, 2004

Answers

Thom,

Sorry for the delay. My computer was in the shop getting an upgrade.

All wisdom I can find on this indicates that it is all about permissions.

One other possible thing to check is whether NT authentication is being used, and if so, is it correct?

Good Luck,

Eric

-- Anonymous, December 15, 2004


Moderation questions? read the FAQ