|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
