>> I currently working with a SQL server with had a tables contain 1000 of
>> records. My problem is when I create the remote view and logon to the
>> server is ok, but when I try to save the view it gives me connectivity
>> error. Is weird that when I use MS Access everthing works.
>> The SQL server is use as LAN and required ODBC driver which I had
>installed
>> in my pc.
>> The thing is that if there's a ODBC error it shouldn't allows me to logon
>
>> and selected the table, right!!!
>>
>> Does anyone knows what that error means!! (connectivity
>error[Oracle][ODBC
>> Oracle driver]operation cancelled)
>>
>
>I can't give you an answer at this time. However, it would be much easier
>to
>help you get an answer if you could tell us which versions of the software
>you're using.
>
>At a glance, it looks as though your ODBC Administrator setup is incorrect
>since SQL Server databases are different than Oracle databases. But,
>again I can't be sure which products and versions you're using.

Hi Carl,

I'm using VFP 3.0 and the Oracle 7.3 ver. 1.16.0301