[RBASE-L] - RE: Sql Server table

[Roberto Zanotti]

I'm using R:Base 2000 v6.5++  (1.866xRT03) , my SQL ODBC Driver is v. 2000.81.9030.04 dtd 08/06/2002 and my ODBC is set up as System DSN, but i get anyway the error.   Any other ideas ?   Roberto Zanotti    BMB Informatica Italy     ----- Original Message ----- From: Walker, Buddy To: RBASE-L Mailing List Sent: Thursday, June 26, 2003 4:34 PM Subject: [RBASE-L] - RE: Sql Server table Roberto    One other thing is that I have the ODBC set up as System DSN   Buddy     -----Original Message----- From: Troy Sosamon [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 10:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Sql Server table Roberto,   I am also getting errors on my sql server db, but I have not updated my sql server software for a while.  I know it is old.   Buddy seems to have it working.  I would suspect you need to check the version of the MS ODBC sql server drivers you are using and the version of R:base you are using. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Roberto Zanotti Sent: Thursday, June 26, 2003 7:47 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Sql Server table Dear Troy   I 've tried  SELECT IOSONO FROM VALORI ORDER BY IOSONO with no other clause but i've got the same error (VALORI is my table name and IOSONO is my column name)     Roberto Zanotti BMb Informatica Italy   ---- Original Message ----- From: Troy Sosamon To: RBASE-L Mailing List Sent: Thursday, June 26, 2003 3:37 PM Subject: [RBASE-L] - RE: Sql Server table Make sure you have your select clause formed properly.  R:base will let you flip flop the where and the order by, but sql will not. I think  the order by needs to come before the where clause.   Troy   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Roberto Zanotti Sent: Thursday, June 26, 2003 7:16 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Sql Server table I have this problem   I've attached an SQL Server 2000 table to my r:base database with the sattach command. Now i'm able to do a select command and to get the records.  The problem is that if i make a select with the 'order by' clause then the Microsoft ODBC Sql Server Driver send the error message 'Cursor Type Modified' Someone knows how to resolve this problem?   Thanks   Roberto Zanotti BMB Informatica Italy