Cross Queries with a field that contains a special character on it (for example "Teléfono") return the error "the column Teléfono in EU6203\SQLEXPRESS (PROD\pepe)`.yourDatabase.dbo.EmpServer EmpServer" is not supported"
Steps to reproduce the problem:
create the following tables :
In SQL Server
USE [yourDatabase];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE TABLE [dbo].[EmpServer] (
[id] int NULL,
[Teléfono] char(10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL)
ON [PRIMARY]
WITH (DATA_COMPRESSION = NONE);
GO
ALTER TABLE [dbo].[EmpServer] SET (LOCK_ESCALATION = TABLE);
GO
In Oracle
CREATE TABLE SCOTT.EmpOrade
(
pk NUMBER,
Name VARCHAR2(30))
then run the cross query below
SELECT EmpServer.id
, EmpServer.`Teléfono`
, EMPORACLE.OK
, EMPORACLE.`NAME`
FROM
`EU6203\SQLEXPRESS (PROD\pepe)`.yourDatabase.dbo.EmpServer EmpServer
INNER JOIN
`ORCL2 (SCOTT), SCOTT`.SCOTT.EMPORACLE EMPORACLE
ON (EmpServer.id = EMPORACLE.OK)
The error "the column Teléfono in EU6203\SQLEXPRESS (PROD\pepe)`.yourDatabase.dbo.EmpServer EmpServer" is not supported" is received.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center