Hi,

I see that my drivers are even older that your old ones. Do you want to try the old 2.10.13.00 drivers? I have a zip file I could pass on to you.

I'm having a look at the info at the address you have me and will try that driver on my nt machine.

Paul


>Paul,
>
>Glad to find you!
>
>The older NT drivers are 2.10.17.0.0 and give an error that the "memory cannot be read" when I try to install them. That's how I ended up going to Oracle's website just about the same time they released the new drivers (3.00.01.01, from http://technet.oracle.com/products/rdbodbc/). They are made to install alongside the older drivers so you can use both.
>
>I keep wondering if there's some bit I can set in the connect string which will read the column names and return the correct data types.
>
>
>>Hi,
>>
>>I'm using the Oracle ODBC driver for RDB version 2.10.13.00. I'm connecting to a couple of servers that run Oracle RDB using both sqlexec and remote views. I find them a bit slow, but everything works. The client machines are nt workstations with a vfp6 application.
>>
>>What was the version of the older odbc driver you were using? Where did you get the new set of drivers? From Oracle? If we are using the same driver we could compare settings.
>>
>>Paul
>>
>>
>>
>>>I'm having a problem with Oracle Rdb ODBC and VFP6/7. I thought I'd bounce it off a few people before I call MS for support.
>>>
>>>Please understand that this is NOT "regular" Oracle, but a "stepchild" they bought from Digital Equipment that doesn't get a lot of support. The database is a large decision support database of management data I query often, but never write to.
>>>
>>>I am able to successfully access this database with an older set of ODBC drivers under W98. When I rebuilt my home machine to W2000 I got a new set of drivers and began having problems retrieving data.
>>>
>>>MS Access and MS Query (through Excel) work properly, but when I retrieve data through VFP I do not get any field names, only Exp, Exp1, etc. and the data types are wrong, with dates and SUM() fields coming through as text. The data, as far as I can tell, are correct.
>>>
>>>My guess is that VFP cannot properly communicate with this ODBC driver. Anyone seen anything like this before?