I don't want to get off on a rant here, but I've got a major problem with ADO (or probably ODBC). I am using a SQL statement to return the names of the tables in a SYBASE database (SYBASE is 99.99% identical to MS SQL Server). When I run it in a non-ODBC tool, such as RapidSQL or DBArtisan, it runs fine. But when I run it with ADO, I get the following error:
[INTERSOLV][ODBC SQL Server driver][SQL Server]Incorrect syntax near the keyword 'SELECT'.
This is the SQL statement:
Code:
[COLOR=royal blue]SELECT[/COLOR] name [COLOR=royal blue]From[/color] sysobjects [COLOR=royal blue]WHERE[/color] type = 'U' [COLOR=royal blue]ORDER BY[/color] name