Sign in to follow this  
Followers 0
polps

Issue with Access DB [Solved]

4 posts in this topic

#1 ·  Posted (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 by polps

Share this post


Link to post
Share on other sites



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.

Share this post


Link to post
Share on other sites

 

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.

Share this post


Link to post
Share on other sites

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0