Kbase P145027: SQL Server cannot connect to Progress after upgrading from 9.1E to 10.1C using linked server.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/04/2009 |
|
Status: Unverified
SYMPTOM(s):
SQL Server cannot connect to Progress after upgrading from 9.1E to 10.1C using linked server.
Getting error using SQL statement 'Select * from (linked server name) ..pub.events' that indicates: Error invalid schema.
Error invalid schema
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1E
OpenEdge 10.1C
MS SQL Server 2005
CHANGE:
Upgraded from 9.1E to 10.1C
CHANGE:
Previously using SQL89 ODBC connection.
CHANGE:
Presently using SQL92 ODBC connection.
CAUSE:
Prior connection to the version 9 Progress database was made through SQL89.
Connection to version 10 Progress / OpenEdge database is through SQL92.
The method to work through a linked server connection from SQL92 requires a different syntax.
FIX:
An example of the newer form of query from SQL Server to a linked server connection to Progress using SQL92 is:
SELECT * FROM OpenQuery([sqlsport2k], 'SELECT * FROM PUB.state WHERE
state = ''MA''')
In this example sqlsport2k is the name of the linked server reference.