• Become a Power user Intro to AutoHotkey Intermediate AutoHotkey Intermediate Objects GUIs are Easy w/AutoHotkey Painlessly switch from V1 to V2

ADOSQL for AHK v1

ADOSQL v5.04L – By [VxE]

Wraps the utility of ADODB to connect to a database, submit a query, and read the resulting recordset.
Returns the result as a new object (or array of objects, if the query has multiple statements).
To instead have this function return a string, include a delimiter option in the connection string.

For AHK-L (v1.1 or later).
Freely available @ http://auto-hotkey.com/boards/viewtopic.php?p=365

How to run SQL queries on local text files

How to run SQL queries on local text files

IMPORTANT! Before you can use this library, you must have access to a database AND know the connection
string to connect to your database.

Varieties of databases will have different connection string formats, and different drivers (providers).
Use the mighty internet to discover the connection string format and driver for your type of database.

Example connection string for SQLServer (2005) listening on port 3456 and with a static IP:
DRIVER={SQL SERVER};SERVER=192.168.0.12,3456;DATABASE=mydb;UID=admin;PWD=12345;APP=AHK

Comments are closed.