Sign in to follow this  
Followers 0
kiffab

Caché database connectivity

3 posts in this topic

Hi

Is 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

Share this post


Link to post
Share on other sites



#2 ·  Posted (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 by spudw2k

Share this post


Link to post
Share on other sites

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;"

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  
Followers 0