Thread: Connecting to Paradox database
01-16-03, 17:08 #1Registered User
- Join Date
- Jan 2003
Unanswered: Connecting to Paradox database
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>
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
08-27-03, 18:14 #2Registered User
- Join Date
- Aug 2003
- Bologna - Italy
Have you checked the SQL syntax?
The case of the tablename, putting ; in the end of the statement, and things like that?The only failure is not trying to do it.