Jump to content

Sql query using ODBC and BETA version?


Recommended Posts

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

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...