| Michelle 2004-03-30, 9:33 pm |
| the code is this...
<html><%
Set Conn = Server.CreateObject ("ADODB.Connection")
Conn.Open Application ("text_ConnectionString")
Set RS = Conn.Execute ("SELECT * From form_results.txt")
Dim iCnt
Do Until RS.EOF
iCnt = iCnt + 1
Name = RS("Name")
Email = RS("Email")
Comments = RS("Comments")
File = RS("File")
RS.MoveNext
Loop
RS.Close
Conn.Close
%>
The error returned is this....
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Text Driver] In the text file specification 'form_results.txt', the ColNameHeader option is invalid.
/test/process1.asp, line 7
Line 7 looks like it's ok but I am looking through very newbie eyes.
Michelle
|