asp and acess
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16096
Printed Date: 29 March 2026 at 6:28pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: asp and acess
Posted By: pilot99
Subject: asp and acess
Date Posted: 04 August 2005 at 11:20pm
| ive been looking around at alot of cool asp projects including webwiz and ive been wondering why they all run of off acces if mysql is supposidly better is it just the popular thing to do or do the 2 go togethter? |
Replies:
Posted By: theSCIENTIST
Date Posted: 05 August 2005 at 1:44am
|
Well, Access has a long tradition with ASP programmers, and all queries are basically the same when the application upscales to MSSQL, also since ASP is Windows server specific, and not all Windows hosts have MySQL, you get lots os ASP > Access/MSSQL applications, so that's why realy. ------------- :: http://www.mylittlehost.com/ - www.mylittlehost.com |
Posted By: pilot99
Date Posted: 05 August 2005 at 11:46am
| so i dont really have to change any qqueries for it to work on mysql i just have to change the route to the db |
Posted By: dpyers
Date Posted: 05 August 2005 at 12:28pm
|
That's pretty much it. You can do more things with mssql - like convert
your queries to stored procedures so they get better performance, but
the basic sql is the same. Just about every windows host used to have access as part of the base plan but charged extra for mssql. Over the past couple of years though, a lot of hosts have been including mssql as part of the base - e.g. web wiz. I figure if the monthly cost difference is less than the cost of a big mack, coke and fries, it's worth skipping lunch one day a month to get mssql.  ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: theSCIENTIST
Date Posted: 05 August 2005 at 6:14pm
Oh yes you do, there's no difference on the SQL of Access and MSSQL, but there's differences when you go to MySQL, since it don't support ADO, but there's ways around it, MySQL provives alternate ways to do whatever you want, it may not be worth however to migrate a large applaication from Access/MSSQL to MySQL because of the differences in the queries, but a smaller application is esialy converted. By the way, you mentioned the root to the DB? In MySQL there's no root to the DB, the DB is declared on the connection string, paths to DBs is another Access specific because it was a file, on MSSQL and MySQL you don't have paths, in fact you don't even need to know where the DB is, the server manages that, you just connect/authorize and query it.
Lol, yes, still some charge the earth and heaven for it. ------------- :: http://www.mylittlehost.com/ - www.mylittlehost.com |
pilot99 wrote:Posted By: dpyers
Date Posted: 05 August 2005 at 6:24pm
Read that as mssql - not mysql man... I've been out of focus the last couple of days. Time to go hiking. -------------
Lead me not into temptation... I know the short cut, follow me. |