Access 2010 with AutoIt

[emanemos]

Hi from France,

Friday, I used this code : Access 2010 with AutoIT.

Today, the code doesn't work : no result & no error. The Access BDD doesn't open (NA.ldb)

Have you an idea ?

Thanks

#include <access.au3>
$Db_oConn = objCreate("ADODB.Connection")
$Db_oRS = objCreate("ADODB.RecordSet")
$Db_oConn.Open("Driver={Microsoft Access Driver (*.mdb)};Dbq="& $path  &  "BDD\NA.mdb")
$Db_oRS.Open('exec Disabled', $Db_oConn, 1, 3)

[water]

You need to do some error checking.

Add the following lines to the top of your script:

#include <Debug.au3>
_DebugSetup()
_DebugCOMError()

[emanemos]

Thanks :


@@ DEBUG COM Error encountered in test.au3 (83) :
 Number         = 0x80020009 (-2147352567)
 WinDescription = Une exception s’est produite.
 Description    = Le pilote spécifié n'a pas été chargé en raison de l'erreur système  126: Le module spécifié est introuvable. (Microsoft Access Driver (*.mdb), C:\Windows\system32\odbcjt32.dll).
 Source         = Microsoft OLE DB Provider for ODBC Drivers
 HelpFile       =
 HelpContext    = 0
 LastDllError   = 0
 Retcode        = 0x80004005

Do  U know the driver thtat I should  use ?

[water]

What is the value of $path?

[emanemos]

$path = "c:usersemanemos"

I've downloaded odbcjt32.dll; erreur systeme 193 instead of 126 with debug

Access 2010 and windows 7

Edited July 28, 2014 by emanemos

[water]

Windows is 32 or 64 bit?

193 means "%1 is not a valid Win32 Application".

[emanemos]

It was a problem with SciTE; Ok with with SciTE Lite.

Yesterday,I uninstalled & installed Autoit and SciTE : OK

Thanks for your help