SQL database accessing methods
Posted on 2008-10-06
I'm new to SQL database access and I have a question or two about access through ASP scripts. Currently, I connect to my database with the following code:
DBname = Server.mappath("/data/ABC.mdb")
set rs = Server.CreateObject("ADODB.recordset")
Databases are located in a folder in my web page space. My understanding is that I am addressing an MS Access backend through ASP, although my host claims to be running SQL Server 2005. MS Access database manipulation syntax works successfully, while SQL Server syntax does not.
1) My host says I should enter my databases into their SQL server and access them that way, which I assume would then be subject to SQL Server syntax. Why should I bother, if this method works?
2) Is MS Access then an intrinsic subset of Classic ASP?