ADO compatibility between Excel XP and 2003
 

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

ADO compatibility between Excel XP and 2003
 

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" wrote in message
oups.com...

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

ADO compatibility between Excel XP and 2003
 

On Feb 20, 3:44 pm, "Bob Phillips" 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" wrote in message

oups.com...





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!