Array
(
)

sp_addlinkedserver para FIREBIRD

Pedih
   - 28 jan 2008

Caros,
ha 2 dias to tentando resolver um problema de conexao e select, mas nao vai.

preciso conectar via sqlexpress2005 numa base de dados do FIREBIRD.

---
AE VAI..

declare @LINKED_SERVER_NAME varchar(max);
declare @PRODUCT_NAME varchar(max);
declare @IBPROVIDER varchar(max);
declare @DATA_SOURCE varchar(max);
declare @CN_STR varchar(max);

set @LINKED_SERVER_NAME = N´FB´;
set @PRODUCT_NAME = N´FB´;
set @IBPROVIDER = N´LCPI.IBProvider.2´;
set @DATA_SOURCE = N´localhost:d:\BANCO.FDB;
set @CN_STR = ´truncate_char=false; support_odbc_query=true;
support_square_delim_name=1;dynamic parameters=true; allow inprocess=true;user=sysdba; password=masterkey; ctype=win1252; auto_commit=true´;

/* DROP LINKED SERVER */
IF EXISTS (SELECT srv.name FROM sys.servers srv
WHERE srv.server_id != 0 AND srv.name = @LINKED_SERVER_NAME)
EXEC master.dbo.sp_dropserver @server=@LINKED_SERVER_NAME, @droplogins=´droplogins´

/* CREATE LINKED SERVER */
EXEC master.dbo.sp_addlinkedserver
@server = @LINKED_SERVER_NAME,
@srvproduct = @PRODUCT_NAME,
@provider = @IBPROVIDER,
@datasrc = @DATA_SOURCE,
@provstr = @CN_STR

/* set up Extended properties of the Linked Server */
EXEC master.dbo.sp_serveroption @server=@LINKED_SERVER_NAME,
@optname=´data access´, @optvalue=´true´
EXEC master.dbo.sp_serveroption @server=@LINKED_SERVER_NAME,
@optname=´rpc´, @optvalue=´true´
EXEC master.dbo.sp_serveroption @server=@LINKED_SERVER_NAME,
@optname=´rpc out´, @optvalue=´true´
EXEC master.dbo.sp_serveroption @server=@LINKED_SERVER_NAME,
@optname=´use remote collation´, @optvalue=´true´

ERRO:

Msg 7302, Level 16, State 1, Line 1
Não é possível criar uma instância do provedor do OLE DB ´LCPI.IBProvider.2´ para o servidor vinculado ´FB´.

----

ALGUEM PODE ME AJUDAR ??