polps Posted September 7, 2016 Share Posted September 7, 2016 (edited) Hi all. $oAdoRs = ObjCreate("ADODB.Recordset") $oAdoRs.CursorType = 2 $oAdoRs.LockType = 3 $oAdoRs.Open ("SELECT Col1 FROM Table1 WHERE Col1 = 'text' ", $oAdoCon) With $oAdoRs $aRsData = .GetRows(-1) EndWith $oAdoRs.Close I'm playing with a MsAccess db; I have Windows7 and Access 2010 and AutoIT 3.3.14.2. When I launch the script clicking on the file and by "Run Script (x86)" it runs correctly When I run the code by Scite (tools - go) or with "Run script (x64)" it fails. I already red some post in the forum related to this issue but I really didn't undestood. Can someone help me to understand why this issue? How can I rewrite my code in order to bypass the problem? Thanks in advance. Edited September 7, 2016 by polps Link to comment Share on other sites More sharing options...
spudw2k Posted September 7, 2016 Share Posted September 7, 2016 I ran into the same issue with my ADODB UDF. I address this issue by adding this AutoItWrapper parameter near the top of my script: #AutoIt3Wrapper_UseX64=N You may need the "Full" SciTE editor to support the param. Spoiler Things I've Made: Always On Top Tool ◊ AU History ◊ Deck of Cards ◊ HideIt ◊ ICU ◊ Icon Freezer ◊ Ipod Ejector ◊ Junos Configuration Explorer ◊ Link Downloader ◊ MD5 Folder Enumerator ◊ PassGen ◊ Ping Tool ◊ Quick NIC ◊ Read OCR ◊ RemoteIT ◊ SchTasksGui ◊ SpyCam ◊ System Scan Report Tool ◊ System UpTime ◊ Transparency Machine ◊ VMWare ESX BuilderMisc Code Snippets: ADODB Example ◊ CheckHover ◊ Detect SafeMode ◊ DynEnumArray ◊ GetNetStatData ◊ HashArray ◊ IsBetweenDates ◊ Local Admins ◊ Make Choice ◊ Recursive File List ◊ Remove Sizebox Style ◊ Retrieve PNPDeviceID ◊ Retreive SysListView32 Contents ◊ Set IE Homepage ◊ Tickle Expired Password ◊ Transpose ArrayProjects: Drive Space Usage GUI ◊ LEDkIT ◊ Plasma_kIt ◊ Scan Engine Builder ◊ SpeeDBurner ◊ SubnetCalcCool Stuff: AutoItObject UDF ◊ Extract Icon From Proc ◊ GuiCtrlFontRotate ◊ Hex Edit Funcs ◊ Run binary ◊ Service_UDF Link to comment Share on other sites More sharing options...
polps Posted September 7, 2016 Author Share Posted September 7, 2016 Yes, now the script is running correctly also by Scite menu and even when compiled. Thanks spudw2k. I suppose that AdoDB is no longer supported on system with 64bit. Just for curiosity, should be good to understand why. Link to comment Share on other sites More sharing options...
spudw2k Posted September 7, 2016 Share Posted September 7, 2016 Well, let's not say it's no longer supported...but a 64-bit version is not provided. A quick google search turned up this article: https://support.microsoft.com/en-us/kb/971987 Spoiler Things I've Made: Always On Top Tool ◊ AU History ◊ Deck of Cards ◊ HideIt ◊ ICU ◊ Icon Freezer ◊ Ipod Ejector ◊ Junos Configuration Explorer ◊ Link Downloader ◊ MD5 Folder Enumerator ◊ PassGen ◊ Ping Tool ◊ Quick NIC ◊ Read OCR ◊ RemoteIT ◊ SchTasksGui ◊ SpyCam ◊ System Scan Report Tool ◊ System UpTime ◊ Transparency Machine ◊ VMWare ESX BuilderMisc Code Snippets: ADODB Example ◊ CheckHover ◊ Detect SafeMode ◊ DynEnumArray ◊ GetNetStatData ◊ HashArray ◊ IsBetweenDates ◊ Local Admins ◊ Make Choice ◊ Recursive File List ◊ Remove Sizebox Style ◊ Retrieve PNPDeviceID ◊ Retreive SysListView32 Contents ◊ Set IE Homepage ◊ Tickle Expired Password ◊ Transpose ArrayProjects: Drive Space Usage GUI ◊ LEDkIT ◊ Plasma_kIt ◊ Scan Engine Builder ◊ SpeeDBurner ◊ SubnetCalcCool Stuff: AutoItObject UDF ◊ Extract Icon From Proc ◊ GuiCtrlFontRotate ◊ Hex Edit Funcs ◊ Run binary ◊ Service_UDF 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