ODBC Driver Data Types (OpenInsight 32-bit Specific)
At 29 MAY 2003 02:53:54PM Ira Krakow wrote:
I've been looking at the ODBC driver, to include the ODBC Driver Practical Tips in the documentation. I was curious which data types caused ODBC to cough. Using Access 2002, I found the following when attempting to import an OI table:
1) The DATETIME data type caused Access to produce the message "SQLGETDATA Internal Error 29". I'm not sure if it can handle the (DT) conversion. The import was aborted.
2) The DOLLARS data type caused the message "Scaling resulted in decimal truncation", no matter what I tried with the data (adding a decimal point, adding the dollar sign, etc.), and aborted the import.
3) The FLOAT data type caused the message "Error in Assignment SQLGetData Error" and aborted the import.
Also, curiously, the Access 2002 Table Editor displayed the "pencil" icon and allowed the user to edit records. To the user, the changes appear to have been saved. However, they really were not saved in OI. This may just be a peculiarity of Access 2002; it's definitely confusing.
This seems like useful information in attempting to figure out why the ODBC driver is failing. I was wondering if anyone experienced similar behaviors.
Ira
At 29 MAY 2003 04:50PM Jim Vaughan wrote:
I have seen problems with DateTime.