I need to change the Access Database connection to SQL Database server connection in Online Form created in Expression Web. The files are .asp not .aspx. Can that be done in EW? Following is the driver need to be replaced.
strConn="Driver={Microsoft Access Driver (.mdb, .accdb)};Dbq=d:\websurveys\xyz.accdb;Uid=;Pwd=;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open strConn
ANY HELP IS HIGHLY AI need to change the Access Database connection to SQL Database server connection in Online Form created in Expression Web. The files are .asp not .aspx. Can that be done in EW? Following is the driver need to be replaced.
strConn="Driver={Microsoft Access Driver (.mdb, .accdb)};Dbq=d:\websurveys\xyz.accdb;Uid=;Pwd=;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open strConn
Do I need to rebuild the forms in Visual Studio? Any help is highly appreciated.