mabriseb Posted July 15, 2005 Posted July 15, 2005 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
GaryFrost Posted July 15, 2005 Posted July 15, 2005 yes#71524 SciTE for AutoItDirections for Submitting Standard UDFs Don't argue with an idiot; people watching may not be able to tell the difference.
mabriseb Posted July 15, 2005 Author Posted July 15, 2005 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now