Kbase P123490: Using Micrsoft's Data Transformation Services functionality in Visual Studio 2005 (SSIS) causes Visu
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/02/2009 |
|
Status: Verified
SYMPTOM(s):
Using Microsoft's Data Transformation Services functionality in Visual Studio 2005 (SSIS)
Visual Studio hangs
ODBC trace log shows a lock table overflow
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Lock table is full. (7870) (-210016)
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Insufficient information to connect to the data source.
FACT(s) (Environment):
Windows
OpenEdge 10.x
CAUSE:
Customer was connecting to Progress by using the OLE DB data provider for OpenLink. The OpenLink ODBC driver was for Progress 9.x. Customer originally attempted to use the ADO.NET/ODBC.NET data provider but was not successful in getting connected.
FIX:
When specifying a data source in Visual Studio, use the ADO.NET data source and then specify ODBC Data Provider as the data provider (ensure that you specify the password for the database connection even though it may not have been needed during a test connection).