asp_databases thread: DSNless vs DSNfull connection to Access: SQL syntax differs?
Subject line says it all really. Developed an ASP page connecting to Access 2k thru a DSN. Everything works hunky-dory. Changed the connect string from "mydsn" to "PROVIDER = ...." to connect thru OLEDB and Jet, and SQL Queries fail with Syntax Error in FROM clause. The queries used single-quotes to quote strings, and one of the columns was called "user". Anyone shed any light on this? Thanks, Steve.
|





