Jump to content
Sign in to follow this  
mabriseb

Sql query using ODBC and BETA version?

Recommended Posts

I read some topics about SQL connection and I would like to do some queries in a ODBC database. How can I do that? Do I need Beta version? And if yes! where can I find the Beta version of AUTOIT V3?


MatMontreal, Canada

Share this post


Link to post
Share on other sites

This is the code I fond on the FORUM

#include <GUIConstants.au3>

;

; Open your data source here....

$conn = CreateObj("ADODB.Connection")

$conn.CursorLocation = $adUseClient ;SERVER-SIDE NOT RECCOMENDED

$conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _

& "SERVER=127.0.0.1;" _

& "DATABASE= NAME;" _

& "UID=user;" _

& "PWD=pass;"

$conn.Open

; Create a recordset

$rs = CreateObj("ADODB.Recordset")

$rs.Open("SELECT * FROM report", $conn, $adOpenStatic, $adLockReadOnly)

;#comments-end

I place my database connection in and I have this error:

Unknow fonction name:

$conn = CreateObj("ADODB.Connection")

$conn = ^ERROR


MatMontreal, Canada

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  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...