Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 compatibility issue | Excel Discussion (Misc queries) | |||
Excel 2007 -- 2003 Compatibility | Excel Discussion (Misc queries) | |||
Advice - Excel 2003 Compatibility | Excel Discussion (Misc queries) | |||
Excel 2003 compatibility | Excel Discussion (Misc queries) | |||
Problem with VBA compatibility - Excel 2003 | Excel Programming |