|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Database connection. |
|
From: |
Anonymous |
|
Date: |
3/22/2001 1:43:07 PM |
|
IP: |
207.236.117.3 |
Try the following.
vdsn="WEB"
vuserid="myuserid"
vpassword="mypassword"
set rescatDB = server.createObject("ADODB.Connection")
rescatDB.open "DSN=" & vdsn & ";UID=" & vuserid & ";PWD=" & vpassword
theSQL="select * from mytable"
set dataSet = rescatDB.Execute(theSQL)
dataSet.close
set dataSet = Nothing
rescatDB.close
set rescatDB = Nothing
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
