|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Setting up an Access connection using Visual InterDev |
|
From: |
Mike |
|
Date: |
5/3/2000 3:03:35 PM |
|
IP: |
159.75.32.249 |
You can do a couple of things,
Here is one;
Setup an ODBC connection on the web server to the access database.
Then connect to the name you gave it like ODBCname
Once you have a connection, you can pull out the data in the body of the ASP.
Dim Connect, TableRS, Query
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "ODBCname"
Set TableRS = Server.CreateObject("ADODB.Recordset")
Query = "SELECT * " _
& "FROM TBLdata "
TableRS.Open Query, Connect, 1, 3
<body>
Location : <%=TableRS("shiptolocation")%><br> |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
