I don't know much about
VB but here is what I'm trying to do. This code produces nothing. The web browser will just time out.
The code below uses a datasource named timereports. I'm 100% sure the datasource works as I've tested some sql statements using winsql.
I don't care if I need to connect without the data source, I just need to successfully send and retrieve an SQL statement from the database and I can go from there.
This is a paradox 5.x database, on my K drive in this example.
Thanks again and the code follows:
<html><head><Title>Database on the internet</title></head>
<body>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "dsn=TimeReports;" & "UID=master;" & "pwd=master;"
SQL = "SELECT * from untcard"
Set RS = Conn.Execute(SQL)
%>
<table border="1" bgcolor="lightblue">
<tr><td colspan="2">Here is the data in the table</td></tr>
<%
' keep printing out data until EOF
Do While Not RS.EOF
%>
<tr> <td><%=rs("TC_EMPNO")%></td>
<td><%=rs("TC_ATIME")%></td></tr>
<%
RS.MoveNext
Loop
Conn.Close %>
</table>
</body></html>
dBforums
>
Connecting to Paradox database
01-16-03, 16:08
Connecting to Paradox database
Linear Mode
