ADO works fine somethimes, but fails sometimes also...

Joseph Lin

Delphi Developer

Thu, 16 Jan 2003 03:00:00 GMT

ADO works fine somethimes, but fails sometimes also...

I user ADO components to connect to SQL Server 7. But sometimes it raises an exception. The exception
message is [DBNMxxx]Access Denied. But it works fine sometimes. Anybody know why does this happen
and how to solve it?

Lauri

Delphi Developer

Sat, 18 Jan 2003 03:00:00 GMT

Re:ADO works fine somethimes, but fails sometimes also...

Could it be a permission issue? If you're going through an ODBC OLEDB
driver, check the type of Authenticity setup in the ODBC DSN configuration
.. NT or SQL Authentication...

Quote

> I user ADO components to connect to SQL Server 7. But sometimes it raises

an exception. The exception

Quote

> message is [DBNMxxx]Access Denied. But it works fine sometimes. Anybody

know why does this happen

Quote

> and how to solve it?

Vassil Nazaro

Delphi Developer

Sat, 18 Jan 2003 03:00:00 GMT

Re:ADO works fine somethimes, but fails sometimes also...

Quote

> message is [DBNMxxx]Access Denied.

This error is raised by the SQL Server client lib. and it means
that you are trying to access an object in the database for which
your current user account has no permission.

HTH
--
V. Nazarov
IT Manager, Sofia Cable

Other Threads

1. Program works fine on my machine, fails on all others

2. Find Declaration sometimes works, sometimes not

3. ISAPI Login action sometimes works, sometimes not...

4. Code fails with BCB, fine with BC++

5. Deleting a record sometimes fails?

6. Resizing Control Dimensions Fails - sometimes

7. Controls sometimes fail to align to CLient

8. [Access97] - Empty Msater-Detail is not working fine

9. my SQL works fine in the BDE but not in my program

10. Works fine in QBE, but SQL does not