|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Connecting to a DB |
|
From: |
Gie Gie |
|
Date: |
2/6/1999 11:32:27 AM |
|
IP: |
202.77.161.34 |
Actually you need to establish a connection before you execute a SQL
<OBJECT RUNAT=Server ID=Conn progid="ADODB.Connection"></OBJECT>
You can incl. the above object in your asp then use the following code to open the database
Conn.Open "DSN Name"
Set rs=Conn.Execute( "Select * from table" )
and you can also retrieve the infomation by
rs("field_name")
These are the method to retrieve execute SQL in ASP.
And you can use RecordSet to Insert or update a db.
Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = "DSN=user_DSN_name;"
rs.Open( "Select * from Table" )
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
