ASP - switching from Access to SQL |
| Jim Tanner posted at 22-Mar-05 04:41 |
 | hey
i have an ASP app that has been functional for about 2 years now...... due to overwhelming traffic to the site (50,000 hits / day), we've noticed that our DB connection has been flaking out sometimes... (errors about file in use / unspecified errors when trying to cnonect)
so, we thought maybe switching the DB from Access to SQL Server may clear up this problem.
is SQL Server more tolerant of multiple concurrant connections? obviously, about 95% of the SQL syntax will be the same...... do you forsee any problems switchin from access to sql? |