sp_addlinkedserver para FIREBIRD
28/01/2008
0
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 ??
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 ??
Pedih
Curtir tópico
+ 0
Responder
Clique aqui para fazer login e interagir na Comunidade :)