Four-part naming for Interbase linked server query
Posted on 2004-11-19
I've set up a linked server to an external InterBase 7 server in Enterprise Manager. I can see all of the tables and can query them using OPENQUERY(), however I can't seem to get four-part naming to work on this database.
Does anyone have any experience connecting to InterBase through MS SQL Server that might know what info I need for catalog and schema in the four-part naming convention or if it is even possible to query InterBase that way?
I executed the following from query analyzer:
DBCC TRACEON(7300, 3604)
And it showed NULL for TABLE_CAT and had nothing in the column for TABLE_SCHEM.
The server is linked using OLE DB for ODBC through an Easysoft ODBC driver, if that makes a difference.
Since this seems like a pretty specialized answer, I'm offering max points. Thanks in advance!