I'm triying to make an sql query to a linked server and i have this error:
El proveedor OLE DB "PGNP" del servidor vinculado "ILION_OLEDB" devolvió el mensaje "Command is not prepared".
El proveedor OLE DB "PGNP" del servidor vinculado "ILION_OLEDB" devolvió el mensaje "ERROR: secuencia de bytes no válida para codificación «UTF8»: 0xf36e202d
HINT: Este error también puede ocurrir si la secuencia de bytes no coinciden con la codificación esperada por el servidor, lo cual es controlado por el parámetro «client_encoding».
In english
OLE DB provider "PGNP" for linked server "ILION_OLEDB" returned message "Command is not prepared".
OLE DB provider "PGNP" for linked server "ILION_OLEDB" returned message "ERROR: invalid byte sequence for encoding" UTF8 ": 0xf36e202d
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by the parameter "CLIENT_ENCODING".
In my query I have som spanish charcters like "ñ" or "ó" in columns alias.
If i remove this characters and query executes correctly, but I need to have them.
My linked server script is:
/****** Object: LinkedServer [ILION_OLEDB] Script Date: 05/23/2013 11:49:40 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'ILION_OLEDB', @srvproduct=N'PGPN', @provider=N'PGNP', @datasrc=N'172.18.254.10', @provstr=N'Extended Properties="FORCEUTF8=ON"', @catalog=N'ilionhq'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ILION_OLEDB',@useself=N'False',@locallogin=NULL,@rmtuser=N'postgres',@rmtpassword='########'
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'use remote collation', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'remote proc transaction promotion', @optvalue=N'true'
GO
Is there any solution?
Thanks
