Jump to content
Sign in to follow this  

Connect to online SQL database

Recommended Posts


I'm sure that AutoIt is very capable of a lot of things, but im not sure that it capable of doing what I need it to do, from surfing the forum's and looking at SQL Lite which is a severless database.

The reason why I don't know if AutoIt is capable for what I'm doing is because I need it to connect to an online MySQL database(on my domain) and view a table. But AutoIt only has syntax for SQL Lite which doesn't have the power to connect online, as it is a severless database.

Also I need the program to either use it as an array or convert it too one!

The above seems a bit short, but I couldn't think of what else to put, so if you need any more details just ask!

I just want to know if this is possible and how please? Thanks

Share this post

Link to post
Share on other sites

looks good, I'll keep studying that!

But how the hell do I tell it to connect to a remote database? (Whats the syntax)Because MySQL_Real_Connect does say anything about a url or anything?

Share this post

Link to post
Share on other sites

Theres info in the udf

; Function Name:   _MySQL_Real_Connect
; Description::    attempts to establish a connection to a MySQL database engine running on $Host.
;                    mysql_real_connect() must complete successfully before you can execute any
;                    other API functions that require a valid MYSQL connection handle structure.
; Parameter(s):    $MySQL_ptr   - Pointer to the MySQL struct
;                  $Host        - hostname or an IP address
;                  $User        - MySQL login ID
;                  $Pass        - password for user (no password: "" (empty string))
;                  $Database    - default database (no default db: "" (empty string))
;                  $Port        - If port is not 0, the value is used as the port number for the TCP/IP connection.
;                  $unix_socket - specifies the socket or named pipe that should be used. (no pipe: "" (empty string))
;                  $Client_Flag - flags to enable features
; Requirement(s):  libmysql.dll
; Return Value(s): A MYSQL* connection handle if the connection was successful, NULL if the connection
;                    was unsuccessful. For a successful connection, the return value is the same as the
;                    value of the first parameter.
; Author(s):       Prog@ndy
; Further Information: http://dev.mysql.com/doc/refman/5.1/en/mysql-real-connect.html

Further Information: http://dev.mysql.com/doc/refman/5.1/en/mysql-real-connect.html

GDIPlusDispose - A modified version of GDIPlus that auto disposes of its own objects before shutdown of the Dll using the same function Syntax as the original.EzMySql UDF - Use MySql Databases with autoit with syntax similar to SQLite UDF.

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...