Knowledgebase: Windows Hosting > Plesk
|
I want to use MS Access database, what is the connection string ?
Posted by Senthil, Last modified by on 07 November 2005 02:01 PM
|
|
|
Upload your .mdb file into "httpdocs" Use the below connection string, Dim oConn Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath(".") & "mydatabase.mdb;" NOTE : (i) Replace mydatabase.mdb with actual database name and give read / write permission to your .mdb file. | |
|
|
Comments (0)
