I had to use the ADO. I was able to connect to the Cache as well as destination database. The length of time in seconds to wait before resetting an idle Pooled connection when the connection reset mechanism is on. Click on the box over to the right and click on the small elipsis spell? Recycles connections in the pool associated with connection object conn.
|Date Added:||7 April 2006|
|File Size:||29.26 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Narrow your search by forum. I am finding the process of extraction being very slow almost taking 2 and half hour to extract 0. You can’t post replies to polls.
Count includes both idle and in-use connections. I can write reports directly against the data source, but I want to put the tables into a “Data Source View”, so I can create and deploy a “Report Server Model” that contains friendly names for the fields etc You can’t delete other events. Any tips on tuning?
I was able to connect to the Cache as well as destination database. You can’t send private messages.
System Properties Comparison InterSystems Caché vs. Microsoft SQL Server vs. Oracle
Default is 0 use system default value alternate name: IsolationLevel value for the connection. You can’t delete your own posts. You can read topics.
Maximum size of connection pool for this specific connection string. My connection is through ODBC.
I guess I need to work on the mapping part of it for the data to be successfully imported. You can’t post new polls.
How to connect to Intersystems ODBC
Thanks for any ideas, Tom The sample programs use “”. Thanks for any ideas, Tom. I would first suggest finding out the indexed column s on the source table. Thanks, I am trying to do the exact same thing. Total number of idle connections in the pool associated with connection object conn.
You can’t post topic replies. The CacheConnection class also includes the following static methods that can be used to control pooling:.
You inhersystems post HTML code.
This section describes the server settings required for a connection, and some troubleshooting tips. The previous example could be rewritten as follows:. The connection object can be opened oeldb closed as necessary.
Net source task to view my source data. Similar – but different: The sample programs use “localhost”. You can’t post events. You can’t post or upload images. I had to use the ADO. You can’t edit other events.