Subject Firebird and SSIS Connection
Author
Post date 2014-01-30T05:00:24Z





I am having issues connecting to Firebird from MS SSIS 2008 R2. � �I am getting the below error message when attempting to create linked server.

When I create the connection directly in SSIS, I am unable to connect.


OLE DB provider "MSDASQL" for linked server "ccc" returned message "[ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 27
.".
Msg 7306, Level 16, State 2, Line 4
Cannot open the table ""xxx"."xxx"" from OLE DB provider "MSDASQL" for linked server "xxx".�


Thanks in advance!
Pete