Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: DSNless vs DSNfull connection to Access: SQL syntax differs?


Message #1 by Steve Carter <Steve.Carter@t...> on Thu, 30 Aug 2001 15:54:49 +0100
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.


  Return to Index