HighlanderSword

ODBC 64 bit Connection

3 posts in this topic

#1 ·  Posted

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 ?

Share this post


Link to post
Share on other sites



#2 ·  Posted

Are you using the ADO.UDF to connect?

What is your connection string?

 


Skysnake

Why is the snake in the sky?

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

 

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 by HighlanderSword

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