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)

Thanx in advance!!!