|
|
Hi,
You say you are writing raw SQL into the datasource node query window.
Correct?
- So what happens when you run the this same raw SQL directly in Oracle?
If this works correctly, but it fails in Clementine, then you are probably
correct and it is a problem with the ODBC driver. The ODBC driver
supplies the information to Clementine about the column formats. A fault
with the ODBC driver could lead to the columns being passed to Clementine
as string rather than integer, float or some Decimal format. Also check
what the format the Oracle columns are. The Oracle columns might be some
uncommon non-standard number format.
Try to use the supplied Oracle ODBC driver.
Hope this helps, cheers
Tim
Data Analyst
------------
Hi all,
I got a problem when I connect Clementine and Oracle 9i database.
The problem is that all the number fields have been changed to string when
doing SQL query of merging two tables in datasource node. I used the SPSS
OEM ODBC driver 5.2. Any comments will be much appreciated.
Jack
|
Locked
