Re: ADO compatibility between Excel XP and 2003

On Feb 20, 3:44 pm, "Bob Phillips" <bob....@xxxxxxxxxxxxx> wrote:
Did they set a reference to the ActiveX Data Objects library in the VBIDE?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"acrobat74" <alex.hatzisa...@xxxxxxxxx> wrote in message

news:1171985172.138210.276330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx





Dear all,

I've built an XL application that resides on the intranet.

In this XL file, I use ADO to manipulate recordsets.

When I execute the application from my PC (XL 2002), everything works
fine.

Another user, however, who was running XL 2003 got the following error
message:

Error code: -2147220999
Error description: Method 'Open' of object '_Connection' failed.

The error occurs when the line of code that is ***HIGHLIGHTED*** tries
to execute:

Dim strCon As String
Dim con As ADODB.Connection
Dim rst As ADODB.Recordset

Set con = New ADODB.Connection

strCon = "Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source=" & strAppAccFullName & ";"

******* con.Open ConnectionString:=strCon ****** ' ERROR HERE

Is this a compatilibilty issue?
As I said, this executes fine with XL 2002.
Also, the connection string of the ADO connection is defined alright
at this stage.

Many thanks,
Alex- Hide quoted text -

- Show quoted text -

Grrr...damn it :-)
This guy had his PC reset, so I guess the ADO references were lost.
Thanks for reminding me!

.

Relevant Pages

  • Re: XML ODBC Driver?
    ... Configure the ADO connection for a client-side cursor, execute the SQL ...
    (borland.public.delphi.non-technical)
  • Still getting an error trying to connect to Access DB on web
    ... connection string out of the global.asa file and pasted it into my ASP code ... dim sCon 'ado connection string ... dim adoConn 'ado connection ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.frontpage.programming)
  • Error when trying to open Access DB on web
    ... connection string out of the global.asa file and pasted it into my ASP code ... dim sCon 'ado connection string ... dim adoConn 'ado connection ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.frontpage.programming)
  • Re: DB_SEC_E_AUTH_FAILED: Cannot insert data into table
    ... Unfortunally everytime i try to execute the INSERT INTO command i ... database Database for Systems','application'), Error: No error information available: ... Compatibility int ... connection string. ...
    (microsoft.public.data.ado)
  • Re: Connection with SQL Server generate "Timeout expired"
    ... I have never attempted to use "Command Timeout" in the connection string itself. ... joaovtt wrote: ... Dim con As Object ...
    (microsoft.public.excel.programming)