ASP web page with ADO

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Can anyone tell me how to use access with a web page (ASP)
I have some code that uses SQL server, and I have made a few changes
Please anyone


Here it is -------------------------------------

dsn = Application("Temp2")
Set connection = Server.CreateObject("ADODB.Connection")
connection.ConnectionTimeout = Application("ConnectionTimeout")
connection.Open dsn
sql = "SELECT * FROM People"
OpenRecordset sql,Conn,rs

<form action="Update.asp" method="post">
<input type="input" Name="Code" Value="<%=rs("Name")%>" size="4" readonly>

Database = DB1
Table = People
Field = Name

Re: ASP web page with ADO

Otuatail wrote:
Quoted text here. Click to load it

Whatever you have in Application("Temp2") should be changed to a valid
connection string for your mdb.

oledb is better than odbc
dsnless is more flexible than using a dsn.


William Tasso -

Site Timeline