emanemos Posted July 28, 2014 Share Posted July 28, 2014 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) Link to comment Share on other sites More sharing options...
water Posted July 28, 2014 Share Posted July 28, 2014 You need to do some error checking. Add the following lines to the top of your script: #include <Debug.au3> _DebugSetup() _DebugCOMError() My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
emanemos Posted July 28, 2014 Author Share Posted July 28, 2014 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 ? Link to comment Share on other sites More sharing options...
water Posted July 28, 2014 Share Posted July 28, 2014 What is the value of $path? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
emanemos Posted July 28, 2014 Author Share Posted July 28, 2014 (edited) $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 Link to comment Share on other sites More sharing options...
water Posted July 28, 2014 Share Posted July 28, 2014 Windows is 32 or 64 bit? 193 means "%1 is not a valid Win32 Application". My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
emanemos Posted July 30, 2014 Author Share Posted July 30, 2014 It was a problem with SciTE; Ok with with SciTE Lite. Yesterday,I uninstalled & installed Autoit and SciTE : OK Thanks for your help Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now