how can we a connect a msaccess database with asp?how to use the connection statement
Set objConn = Server.CreateObject("ADODB.Connection")<BR> objConn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.Mappath("YourDatabase.mdb") & ";USER ID=;PASSWORD=;"
please get yourself this book:<BR>Beginning ASP Databases By John Kauffmann
Do you know the provider for SQL Server as I am trying to access an SQL Server database through VBScript and I need to provide a username and password
Install msaccess2000 if u have MS data Link and create a udl File using MSAccess driver.Else u create DSN file using ODBC.<BR>Use ADODB connection and then Conn.Open sampleDSN.
provider = sqloledb.1;