Fail open http://127.0.0.1/odbc_exmp.asp, invalid SQL, pls HELP

Author	Thread
Fail open http://127.0.0.1/odbc_exmp.asp, invalid SQL, pls HELP
Posted in tutorial: Accessing database from an ASP page
· samsetza Joined: 14 Jan 2005 Total Posts: 1	Fail open http://127.0.0.1/odbc_exmp.asp, invalid SQL, pls HELP Posted: 14 Jan 2005 I am new to this stuff and I have followed step by step this tutorial very carefully, but when come to the final step to open: http://127.0.0.1/odbc_exmp.asp It come with the following error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. /odbc_exmp.asp, line 13 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Page: GET /odbc_exmp.asp Time: Friday, January 14, 2005, 5:53:22 PM I have checked IIS, it's working well, i have been through all the previous advices of this topic but it doesn't work. I have tried for days So please help me to solve this problem, thank you very much in advance Thank for all your helps and this useful website
· myasp Joined: 28 Mar 2005 Total Posts: 2	Fail open http://127.0.0.1/odbc_exmp.asp, invalid SQL, pls HELP Posted: 28 Mar 2005 I am new to this stuff and I have followed step by step this tutorial very carefully, but when come to the final step to open: http://127.0.0.1/odbc_exmp.asp It come with the following error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. /odbc_exmp.asp, line 13 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Page: GET /odbc_exmp.asp Time: Friday, January 14, 2005, 5:53:22 PM I have checked IIS, it's working well, i have been through all the previous advices of this topic but it doesn't work. I have tried for days So please help me to solve this problem, thank you very much in advance ksh
· maximux100 Joined: 19 May 2006 Total Posts: 1	You can do it Solve Posted: 19 May 2006 Add: rs.Open "select * from names", "DSN=odbc_exmp",,, &H0200 thanks