Classic Asp

ASP 3.0 (Classic) – Supported Databases

If you develop using ASP 3.0 (Classic ASP), you can use Access and SQL Server 2008 databases with our hosting service.

Here are the connection strings for both database types:

ACCESS CONNECTION:

StringConexao = “Provider=Microsoft.Jet.OLEDB.4.0; Jet OLEDB:Database Password=”&Senha&”; Data Source=”&EnderecoFisico&””
Set conectar = Server.CreateObject(“ADODB.Connection”)
conectar.Open StringConexao

SQL SERVER 2008 CONNECTION

StringConexao = “Provider=SQLNCLI10; Server=”&EnderecoVirtual&”; Database=”&BancoNome&”; Uid=”&Usuario&”; Pwd=”&Senha&”;”
Set conectar = Server.CreateObject(“ADODB.Connection”)
conectar.Open StringConexao