Jump to content

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

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

  • Recently Browsing   0 members

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