1

Topic: How to work with Cache?!

Misters, I ask not to kick with feet for a silly question, I ask to concern with understanding - Cache the first time I see in life.
There is a program "M-drugstore", lines it , using Cache, there it.
From a DB it is necessary to preempt the data some not to collect then manually from program reports.
I was set by the purpose to make this outswapping. The Cache-client installed, I try to be connected to basis. I receive in the answer:
The driver = C:\Program Files\Common Files\InterSystems\Cache\CacheODBC35.dll
The driver version = 2010.2.2.600.0

wrote:

Data source name = CACHECLIENT User
The server (IP the address) = 10.34.20.248
Port = 7200
Area Cache = USER
Authentification method = 0 (Password)
User name = _system
The description = Cache Configuration and Namespace - CACHECLIENT USER
Audit Cache ODBC = Is not present
To use decimal point from system  = Is not present
To forbid  request = 0
Support of static cursors = 0
Unicode SQLTypes = 0
Connection error: Particulars in CacheODBC.log
[Cache ODBC] [State: 08S01] [Native Code 452]
[C:\Windows\system32\odbcad32.exe]
Message sequencing error

Google of the answer did not give that it for. We go some other way: I put to porridge locally, I copy basis of the program in a folder c:\InterSystems\Cache1\mgr\user\, I mount basis. I follow the link SQL in "the System management Portal". I select area USER and I try to view the list of circuits. I do not see anything. In a plotter of requests I do not see any table.
Immemorial question: what do I do not so?! And how to make so that I nevertheless saw the list of tables, pulled out the data and forgot about porridge as about a bad dream?
In advance thanks.

2

Re: How to work with Cache?!

1 - Classes with descriptions of tables can lie in other basis - it is necessary to look an area configuration.
2 , and it to me that in last time changes that, the M-drugstore therefore also M - that there all on M and on , and any tables is not used

3

Re: How to work with Cache?!

It's just one thing after another.
Thanks, they are valid in .
I read that such  and as with them to work...

4

Re: How to work with Cache?!

By the way, what it for the driver - CacheODBC35?
For us with it did not want anything to work, with  without registration number works.
It does not concern to the HARDWARE question.

5

Re: How to work with Cache?!

.. wrote:

By the way, what it for the driver - CacheODBC35?
For us with it did not want anything to work, with  without registration number works.
It does not concern to the HARDWARE question.

the Driver supporting ODBC versions 3.5 ( Wiki ).
CacheODBC.dll supports ODBC versions 2.5: 2009.1 Upgrade Checklist

6

Re: How to work with Cache?!

All the same not clearly. According to  odbc 3.5 since 1997;
According to the documentation all new and  installations should be configured through odbc 3.5
But for us did not begin to work odbc 3.5.

7

Re: How to work with Cache?!

shaden wrote:

... Cache the first time I see in life.
...
From a DB it is necessary to preempt the data some not to collect then manually from program reports.
...Forgot about porridge as about a bad dream?

It seems to me that for you the most optimal variant "will collect from reports in manual" since to write the program on outswapping of the data, you will need to learn a M language, and then to understand M-drugstore source codes, and on it a lot of time leaves. .. In your case, faster and is easier all the same "will collect from reports".

8

Re: How to work with Cache?!

To find the person who knows M- and to ask it to write interfaces, though to the same odbc?

9

Re: How to work with Cache?!

.. wrote:

it is All the same not clear. According to  odbc 3.5 since 1997;
According to the documentation all new and  installations should be configured through odbc 3.5
But for us did not begin to work odbc 3.5.

For me works.