I'm sconnecting to a SQL 6.0 DB (MP2 - Maintenance Management Application). I can attach to all of the tables but with some of the tables when I attempt to retrieve data from them I get this error message.
[Microsoft] [ODBC SQL Server Driver] Cursor Type Changed! Any Ideas what is doing this or what I need to do access those tables! Also in the same SQL database that I'm attaching to there is a table EMP (EMPLOYEE INFORMATION) that has a column named ZIP. I get a dialog box that asks me to give that column an alias. I'm using this below. Sattach EMP as EMPINFO using EMPCODE,FIRSTNAME,LASTNAME,ZIP alais USERID,FNAME,LNAME,ZIPCODE Is there any way to stop this dialog box request? Also when I attach to any of the tables using only a few of the columns Sattach command for the table I get all of the columns any way! Is this correct? I'm using Patch four! I'll be gone today and I'll check any responses in the morning! Best regards, Oma Cox
