> 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.
==Carl
Carl J. WarnerVFUG OfficerThe early bird gets the worm, but the second mouse gets the cheese.