ODBC/JDBC

Subscribe to ODBC/JDBC content with RSS Syndicate content or email

Working with external SQL table in cache

Hi, I would like to read a row out of an external SQL table and reference the returned results directly from my cache class. I've set up a  link table and a SQL gateway connection.

views

rating

Connect PRTG to Cache

I am trying to set up a sensor in PRTG to connect to Cache, specifically the ens_util.log, so that I can have a live feed of my error count. I am having trouble getting the sensor to log in to Cache.

views

rating

ODBC refuse to take credentials on the fly from a .NET applikation

Hi!

I'm trying to connect to one of our Ensemble servers Cache database from a C#-windows form . I'm running the client from my local computer with OS win7.  Using .NET FW ver 4.5.2 in the client.

views

rating

How to declare TSQL variable over JDBC connection?

I'm trying to use the standard TSQL DECLARE syntax but I get the following error:

[%msg: < IDENTIFIER expected, @ found^  DECLARE @>]

How do I declare a variable?  For instance:

views

rating

Server closed communication device?

I get this on some queries in some namespaces.  For instance, this query:

views

rating

Mastering the JDBC SQL Gateway

As we all know, Caché is a great database that accomplishes lots of tasks within itself. However, what do you do when you need to access an external database? One way is to use the Caché SQL Gateway via JDBC.

views

rating

Sample of IHE Performance monitoring dashboard

I've asked a lot of questions leading up to this, so I wanted to share some of my progress.

views

rating

Data extraction using SQL Via ODBC

Hi All,

            I have a general query in regards to developers experience on extracting data from cache databases and the most efficient way to do so. I work with a number of clients who have applications with cache databases and require the data off the host system and onto data warehouse platforms for research and analysis. Often they require the data in source state which means the extracts are often simply a table scan of the entire database table without any aggregation or manipulation.

views

rating

A fetch_all() method for the Python client class

It would be convenient to be able to fetch the whole query result in one operation instead of looping through every row. A fetch_all() method or something similar would provide this functionality I guess.

views

rating

How do I get display value of a property via ODBC

I have a class with a string property with DISPLAYLIST and VALUELIST parameters specified.

When I query this class via ODBC I receive logical value as it is and not a display value.

views

rating

Authenticate User from Java application using JDBC

Hello everyone,

I'm trying to authenticate a user(Health Share clinician) from a Java Application. 

I 'm already connected to Caché and able to run SQL commands.

views

rating

How to Connect to External Non-Caché DB With COS and Without DSN?

We are creating a package (written in Caché Object Script) that will provide access to an external DB (MySQL).

views

rating

Connecting to Caché with SQuirreL SQL, an external SQL client

The Caché System Management Portal includes a robust web-based SQL query tool, but for some applications it’s more convenient to use a dedicated SQL client installed on a user’s PC.

views

rating

How to keep Cache table synchronized with an external table?

I have a MySQL server with "posts" table.

I also have a Caché server with "downloadedposts" table. 

They are connected from Caché to MySQL via SQL Gateway

I want to keep Caché table synced with MySQL one  (MySQL "posts" table is a master copy), so periodically Caché queries MySQL server and downloads data. So far so good, and if a record appears or changes in MySQL table, Caché downloads the changes.

The problem I'm encountering is that sometimes rows would be deleted from  MySQL "posts" table.

How do I synchronize deletions?

views

rating