kiffab Posted February 8, 2013 Share 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 Link to comment Share on other sites More sharing options...
spudw2k Posted February 8, 2013 Share 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 BuilderMisc Code Snippets: ADODB Example ◊ CheckHover ◊ Detect SafeMode ◊ DynEnumArray ◊ GetNetStatData ◊ HashArray ◊ IsBetweenDates ◊ Local Admins ◊ Make Choice ◊ Recursive File List ◊ Remove Sizebox Style ◊ Retrieve PNPDeviceID ◊ Retreive SysListView32 Contents ◊ Set IE Homepage ◊ Tickle Expired Password ◊ Transpose ArrayProjects: Drive Space Usage GUI ◊ LEDkIT ◊ Plasma_kIt ◊ Scan Engine Builder ◊ SpeeDBurner ◊ SubnetCalcCool Stuff: AutoItObject UDF ◊ Extract Icon From Proc ◊ GuiCtrlFontRotate ◊ Hex Edit Funcs ◊ Run binary ◊ Service_UDF Link to comment Share on other sites More sharing options...
kiffab Posted February 11, 2013 Author Share 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;" Link to comment Share on other sites More sharing options...
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