SQL vs Access

This topic is locked

SQL vs Access	9/28/2006 10:43:48 PM
ASPRunnerPro General questions
P pharaon_98 author Hi Our ISP is offering us to move our databases from Access to SQL. It seems appealing. But, we do not have SQL in our office. Since the database structure is going to be the same, can I build my ASP page in my office using the connection string of our old Access database and modify the dbconnection.asp page with the connection string of the SQL server before publishing our pages ?


J	Jane 9/29/2006
	Hi, I recommend you to connect to the remote SQL server. http://www.xlinesoft.com/asprunner/docs/co...er_database.htm Then you can only change host name in the connection string before publishing pages.