ODBC 64 bit Connection

[HighlanderSword]

Hello all,

 

I have an odbc entry defined in odbc64 bit called testme as a user dsn , I have had no luck in connecting to it from Autoit.

 

I have tried several of the scripts in the help forum and have had no luck getting them to work.

 

Its an Accdb file that I want to be able to update , delete records etc...

 

Any Ideas ?

[Skysnake]

Are you using the ADO.UDF to connect?

What is your connection string?

 

[HighlanderSword]

 

Yes i'm using ado.udf

local $cn = _ADO_Connection_Create()
local $rfesults = _ADO_Connection_OpenConString($cn, 'Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\test1.accdb;')

 

Get error

: ==> The requested action with this object has failed.:
$oConnection.Open($sConnectionString)
$oConnection^ ERROR

Edited April 3, 2017 by HighlanderSword