MS Access DSN Less Connection Example

Here is the example code for dsn less ms access connection.

<%
Set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("database.mdb") & ";"

db.execute("INSERT INTO MyTable VALUES ('Dan Hendricks', 22)")
set rs=db.execute("SELECT * FROM MyTable")

rs.MoveFirst
Do Until rs.EOF
Response.Write rs("NAME") & "<br>"
rs.MoveNext
Loop
rs.Close
%>

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Perl

PROBLEM: When you use a Common Gateway Interface (CGI) application with Microsoft Internet...

HELM Navigation

i : Login to HELM using your information ii : Click on [ Domains ] iii : Now click on the row...

Creating SQL Server DataBase in HELM

i : Login to HELM using your information ii : Click on [ Domains ] iii : Now click on the row...

SQL Server Connection String

string str = 'server=localhost;database=dbname;uid=dbuser;pwd=dbpass;'; dbname : Your Database...

Uploading / Updating Microsoft SQL Server DataBase

1 : Upload your local database files [ LDF & MDF ] any where in WWW folder. Theses database...

Powered by WHMCompleteSolution