I'm trying to integrate some data into a new system. The existing system is a Firebird database and I can't move away from it.
So, I'm trying to create a linked server to this Firebird database. I created one on my local machine (XP pro, mssql 2008 express) and it works great! Moved to my server (2008 r2 server, mssql 2008 r2, 64 bit) and I can connect, but I get the following error when I try to query:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "firebird" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "MSDASQL" for linked server "firebird". The provider supports the interface, but returns a failure code when it is used.
I had to use the SQLOLEDB driver to connect to the firebird driver available here: I used this procedure : I made sure to grab the 64 bit drivers.
I have tried the "Allow Inprocess" check box with no love...
Any ideas? Why it works on one computer and not the other? How to get rid of the error?
Thanks!
So, I'm trying to create a linked server to this Firebird database. I created one on my local machine (XP pro, mssql 2008 express) and it works great! Moved to my server (2008 r2 server, mssql 2008 r2, 64 bit) and I can connect, but I get the following error when I try to query:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "firebird" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "MSDASQL" for linked server "firebird". The provider supports the interface, but returns a failure code when it is used.
I had to use the SQLOLEDB driver to connect to the firebird driver available here: I used this procedure : I made sure to grab the 64 bit drivers.
I have tried the "Allow Inprocess" check box with no love...
Any ideas? Why it works on one computer and not the other? How to get rid of the error?
Thanks!