Re: ADO exceptions

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 05/07/04 

Date: Thu, 06 May 2004 21:16:25 -0500

>I'm using a MS SQL Server 2000 with ADO components as front-end.
>When the server send an error, only a generic message error 'OLE error 80040e2f' I obtain.
>Items in adoconnection.errors[] are empty.
>
>However it works fine in other machine.
>How can I to secure a uniform behavior?

I believe there was a problem with ADO 2.6 behaving like this when the local
identifier in SQL was different from what was set in Windows. This was fixed in
a subsequent update to ADO. If you are using ADO 2.6 I suggest you get the most
recent update. 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.conversion)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access and processor usage
    ... "increased bandwidth" using ADO. ... bottleneck - need to step up to Sql Server. ... If the data fits into a 2 GB database file, ...
    (comp.databases.ms-access)