> 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.