Error opening ADO mdb

[TheBreeder]

Hi,

i get an error when running a script to read a table in mdb on one computer and not on other computers. What is missin on that computer .

the rror messag is

E:\Vogel Administratie\Vogel_Administratie.au3 (38) : ==> The requested action with this object has failed.:

$oAdo.Open (@WorkingDir & '\vogel2009.mdb')

$oAdo.Open (@WorkingDir & '\vogel2009.mdb')^ ERROR

->21:26:47 AutoIT3.exe ended.rc:1

The file vogel2009.mdb exists on that drive and directory.

[PsaltyDS]

Hi,

i get an error when running a script to read a table in mdb on one computer and not on other computers. What is missin on that computer .

the rror messag is

E:\Vogel Administratie\Vogel_Administratie.au3 (38) : ==> The requested action with this object has failed.:

$oAdo.Open (@WorkingDir & '\vogel2009.mdb')

$oAdo.Open (@WorkingDir & '\vogel2009.mdb')^ ERROR

->21:26:47 AutoIT3.exe ended.rc:1

The file vogel2009.mdb exists on that drive and directory.

Add a COM error handler to get the details. It might be "Access denied" vice "File not found".

[TheBreeder]

I got the error 80020009

can you give me a hint to solve the problem ?

[PsaltyDS]

I got the error 80020009

can you give me a hint to solve the problem ?

So you got the error number, what was the windescription ($oMyError.windescription)?

[TheBreeder]

So you got the error number, what was the windescription ($oMyError.windescription)?

Class not registerd. How can i find the class that isn't registered ?

Thanks in advance.

[PsaltyDS]

Class not registerd. How can i find the class that isn't registered ?

Thanks in advance.

Did you check IsObj($oAdo) after creating your ADODB.Connection? Maybe ADO is broke on that box.

[Authenticity]

He's probably trying to open DSN which might not happen to be exist or he's not using the correct way to open a connection:

If not registered, it should be:

$oConnection = ObjCreate("ADODB.Connection")


$oConnection.Provider = "Microsoft.Jet.OLEDB.4.0"
$oConnection.ConnectionString = "Data Source = C:\UserData.mdb"
$oConnection.OpenoÝ÷ Øëz¬µêÞv+l¥u·ºÚ"µÍÌÍÛÐÛÛXÝ[ÛHØÜX]J ][ÝÐQÑÛÛXÝ[Û][ÝÊBÌÍÛÐÛÛXÝ[ÛÜ[ ][ÝÑÓ[YI][Ý

Most probably I'm wrong... ;]

Edit: ...or she ;]

Edited April 20, 2009 by Authenticity

[PsaltyDS]

He's probably trying to open DSN which might not happen to be exist or he's not using the correct way to open a connection:

Good point. Once again, lack of code in the OP restricts the understanding of the issue.

[TheBreeder]

Good point. Once again, lack of code in the OP restricts the understanding of the issue.

The coding is working on one computer and not on another computer. I allways start from the same au3 file. The data is on a usb stick that travvels from one computer to the other computer. I think there is a problem with the installation of a dll or something.

I checked the result of the comnnection and the result is not "".

I tried also the two proposition done with the connectionstring, but it does not help.

this is the exact code I use

#include <Access.au3>

Global $oAdo, $oRec, $Fc ; DB variables

$oAdo = 'ADODB.Connection'

$oAdo= ObjCreate("ADODB.Connection")

if $oADO="" then msgbox(0,"","ado not correctly opened")

$oAdo.Provider = $adoProvider

$oAdo.open(@WorkingDir & "\vogel2009.mdb"

[Authenticity]

And vogel2009.mdb is located on the stick or at the current working directory?

[TheBreeder]

And vogel2009.mdb is located on the stick or at the current working directory?

Yes

It seams i have a dll or ... wrongly installed.

[TheBreeder]

Yes

It seams i have a dll or ... wrongly installed.

I'm unistalling the Microsoft Office XP now and will reinstall afterwards to see if I still get the error.

Thanks for the help

[Authenticity]

You can try to register the .mdb file using the Data Sources dialog and open it without any farther specifications like provider, etc...

Just run odbcad32.exe, switch to System DSN tab and add it. You'll then use this DSN name to open it without any specifications and see if it works. If it works, it's not something with the dll.

[GEOSoft]

If you downloaded the access.au3 file some time ago, and the machine that it doesn't work on has Access 2007 installed then it is more than likely related to the Provider string. The download was updated a week or so ago and you have to make sure that you use the new costants file that's in the zip.

[TheBreeder]

If you downloaded the access.au3 file some time ago, and the machine that it doesn't work on has Access 2007 installed then it is more than likely related to the Provider string. The download was updated a week or so ago and you have to make sure that you use the new costants file that's in the zip.

I reinstalled my PC completely and it works.

Thanks all for your cooperation

Richard