Advantage Developer Zone

 
 
 

Advantage Knowledgebase Item




Ref No:
031028-1580
Last Modified:
Wednesday, October 29, 2003
Product:
Advantage OLE DB Provider
Category:
Integration
Title:
Linked Server Errors With Microsoft SQL Server
Problem Description:
An "OLE DB provider Advantage.OLEDB.1 could not map ordinals for one or more columns of object DBSCHEMA_TABLES" error is received when executing an SQL statement against a linked server in Microsoft SQL Server.
Solution:
Use the OPENQUERY syntax. For example: SELECT * FROM OPENQUERY(linkname, 'SELECT * FROM offices'). Due to some differences in how the schema rowsets are returned between SQL Server and the Advantage OLE DB Provider, the "SELECT * FROM [linked server]...[tablename]" syntax is not supported.
Was This Item Helpful?