the MS ODBC for Oracle driver. However, this driver gives me a different problem. If I use pass-through SQL and my select statement performs a sum (as in 'SELECT SUM( HOURS ) TOTALHRS FROM TIMESHEET') the field TOTALHRS is returned as type character!!! The values are correct but the datatype is wrong. The field being summed is defined as NUMBER 15,4. Given that my application is not specific to a particular backend, it's not feasible to use conditional code to convert the field.
>>
>>Anyone have any suggestions/solutions?
>>
>>Thanks,
>>Jamie
>
>Unless Oracle has vastly improved their ODBC drivers, use MS 32-bit ODBC drivers available free from MS site. The Oracle drivers caused errors when used from MS products like VFP and Access. These errors occurred when using more complex queries. For example, multiple joins (2 or more fields make up a key between 2 tables) between 2 or more tables, sub-queries, unions, etc.
>


Thanks Mark, but the problem example I gave above was using the latest Microsoft ODBC for Oracle driver (I downloaded the latest version last week). So I'm getting one problem with the Oracle supplied driver (unable to create parameterised views) and another problem with the MS ODBC for Oracle driver (getting character return value when performing a SUM() on number fields).

I think the next stop is to try the Intersolv drivers.

Regards,
Jamie.