MS SQL to MS Access ASP problem

[Jaunty Edward]

Hi,
I need to get this ASP program to work with ms access instead of ms
SQL... I have converted the DB now I just wanted to know should I just
change the DB
connection settings or there is more to be seen and taken care of.
will I have to change the intire sql commands or its just the database
connection setting.

Warm Regards
Jaunty Edward

 

[Manohar Kamath [MVP]]

Depends on the SQL statements you used in your program. E.g. Access does not
support the sub-queries that T-SQL supports. Second, the date representation
within the queries is different. My suggestion is to regression-test your
application to catch any errors.

 

[Bob Barrows [MVP]]

Hi,
I need to get this ASP program to work with ms access instead of ms
SQL... I have converted the DB now I just wanted to know should I just
change the DB
connection settings or there is more to be seen and taken care of.

Look up the correct OLEDB connection string for your database at
www.connectionstrings.com or www.able-consulting.com/ado_conn.htm. I
recommend avoiding the ODBC examples since the OLEDB Provider for ODBC
(MSDASQL) has been deprecated. This means that if you are currently using a
DSN, you should switch to a DSNless connection string using the OLEDB
Provider for Microsoft Jet.

will I have to change the intire sql commands or its just the database
connection setting.

Start here:
http://www.aspfaq.com/show.asp?id=2214

Your best recourse is to use the Access Query Builder to test your queries.
For one thing, if your queries involve joins of 3 or more tables, you will
find that Jet insists upon the use of parentheses to group those joins. It's
very maddening and the Query Builder allows you to avoid errors.

Bob Barrows