Article ID: 10092
PRB: Multi-Step ODBC Error connecting to a Data Source
PROBLEM
Applies To: ITScriptNet V1/V2
You receive a Multi-Step ODBC Error attempting to connect to a Data Source. This most often occurs with a MySQL or FoxPro database when attempting to download collected data.
RESOLUTION

The default ADO Cursor Type that ITScriptNet used in version 2.0a and prior was Server Side. Some database providers do not support Server Side cursors.

In ITScriptNet version 2.0b and higher, the default cursor type has been changed to Client Side. This allows downloading into MySQL and FoxPro databases, as well as Microsoft Access, SQL Server, and others.

This article last updated: 1/1/2009 12:00:00 AM
Please help us improve the Knowledge Base by rating this article.
    © 1997-2026 Z-Space Technologies - a BCA Innovations Company - All rights reserved