August 18, 2017 at 7:25 am
Hello All,
With a ODBC link we are trying to Obtain data from a Cache database.
We are running into a few problems.
Problem 1;
The system 'hangs' some times. This is probably not caused by specific queries, but is probably depending on something else.
After the system does not respond, we do not know how to reset the system. How can we 'abort' these processes connecting to the ODBC dataset.
Problem 2;
This might be a problem from the other side, but we are looking for a solution, we get the following:
OLE DB provider "MSDASQL" for linked server "C4INFOMODULE" returned message "Row handles must all be released before new ones can be obtained.".
This happens consistently. A simple query with a top 8000 does not give this problem, change 8000 to 10000 and the problem occures. Or leaving the top out, then this does also occure. This is repeatable.
So we need some help with this.
For problem 1 I can only find 'old' (not nice) anwsers on the web.
For problem 2 I can only find anwsers which do adres different situations than ours.
Thanks for your time and attention,
Ben
August 21, 2017 at 11:06 am
I vaguely recall dealing with a "Cache" database via ODBC once, but don't recall a lot of detail. You may find that any sizable record count is problematic. Also, you may want to see if you can get your hands on Cache documentation for it's SQL language syntax. You may need to adjust some of the linked server parameters for ODBC purposes. Wish I could remember more, but that's as much as I recall.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply