Microsoft Text Driver ???
Hi,
<script language="vbs">
Dim Conn, rs
Set Conn = CreateObject("ADODB.Connection")
Conn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"Dbq=http://127.0.0.1;" & _
"Extensions=asc,csv,tab,txt;" & _
"Persist Security Info=False"
Dim sql
sql = "SELECT * from foobar.txt"
set rs = conn.execute(sql)
set rs =CreateObject("ADODB.recordset")
rs.Open "SELECT * from foobar.txt", conn
...
I have code like this I want to run.
Idea is for the CLIENT to connect to SERVER page
and begins download from foobar.txt into
a file locally.
My current test machine is Windows with SERV-U for ftp server
and Apache 1.3.29 for the webserver with PHP.
I get the following error: "[Microsoft][ODBC Text Driver] Internal internet failure"
Does this mean I need to actually install ADODB for this to work ?
Do I need to install Microsoft SQL server ?
Do I need to add ADODB support to PHP ? How cna I check if I have
support for it already if this is the case ?
Is all this possible from a Unix machine ?
I realize this is the "ASP" section but I wrote this here
as I hoped ASP people would have experience with this.
I heard that you need an 'anon' user to have access rights
to read the foobar.txt file. I know there has to be an anonymous FTP user - which exists. But what other 'anon' user is there meant to be, this is where I am confused.
Please help.
Thank you.
|