Oracle and SQLServer uppercase fields error

[#1]

Hi,

I have a QlikView project that hava to connect Oracle or SQLServer, the sql sintax is the same in both cases.

When I connect to Oracle, the first SQL sentence is

SQL select apellido1, apellido2, nombre from personal;

In oracle i receive the fields like:

APELLIDO1

APELLIDO2

NOMBRE

And in SQLServer

apellido1

apellido2

nombre

So there is a case difference, and all the object giving me errors cause that. The fields in database are in lower case, why in oracle give me in uppercase and in SQLServer in lowercase¿? there is a way to receive the field in the same "format" ¿?¿?¿?¿

Thanks...

[hic]

QlikView does nothing to change what it gets from ODBC or OLE DB. I do not know the Oracle driver well, but you need to check your settings on the Oracle ODBC data source (or OLE DB data provider). Maybe there is a setting there?

HIC

[#3]

Waht you can do is rename the fields

APELLIDO1  as apellido1

APELLIDO2  as apellido2

NOMBRE as nombre

Luciano.-