kiffab Posted February 8, 2013 Posted February 8, 2013 HiIs it possible to connect to a Caché database using AutoIt?Using SQL, for instance, I could do this:$conn = ObjCreate( "ADODB.Connection" ) $DSN = "DRIVER={SQL Server};SERVER=mydbserver;DATABASE=mysqldb;UID=user;PWD=password;" $conn.Open($DSN)Cheers
spudw2k Posted February 8, 2013 Posted February 8, 2013 (edited) It appears that an ODBC driver is available (http://www.intersystems.com/support/odbc.html). You should be able to install it and use ADODB for transactions. Something like (untested) $DNS = "DRIVER={CacheODBC};SERVER=..... Edited February 8, 2013 by spudw2k Spoiler Things I've Made: Always On Top Tool ◊ AU History ◊ Deck of Cards ◊ HideIt ◊ ICU ◊ Icon Freezer ◊ Ipod Ejector ◊ Junos Configuration Explorer ◊ Link Downloader ◊ MD5 Folder Enumerator ◊ PassGen ◊ Ping Tool ◊ Quick NIC ◊ Read OCR ◊ RemoteIT ◊ SchTasksGui ◊ SpyCam ◊ System Scan Report Tool ◊ System UpTime ◊ Transparency Machine ◊ VMWare ESX Builder Misc Code Snippets: ADODB Example ◊ CheckHover ◊ Detect SafeMode ◊ DynEnumArray ◊ GetNetStatData ◊ HashArray ◊ IsBetweenDates ◊ Local Admins ◊ Make Choice ◊ Recursive File List ◊ Remove Sizebox Style ◊ Retrieve PNPDeviceID ◊ Retrieve SysListView32 Contents ◊ Set IE Homepage ◊ Tickle Expired Password ◊ Transpose Array Projects: Drive Space Usage GUI ◊ LEDkIT ◊ Plasma_kIt ◊ Scan Engine Builder ◊ SpeeDBurner ◊ SubnetCalc Cool Stuff: AutoItObject UDF ◊ Extract Icon From Proc ◊ GuiCtrlFontRotate ◊ Hex Edit Funcs ◊ Run binary ◊ Service_UDF
kiffab Posted February 11, 2013 Author Posted February 11, 2013 Thanks. Installed the drivers but unsure how to connect as you have an instance and a namespace within cache. No luck with this: $DSN = "DRIVER={CacheODBC};SERVER=IP:Port/Namespace;UID=Username;PWD=Password;"
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