hi,
i'm trying to read data from a text file using the ODBC text driver. the Connection
string i'm using is
--cut--
Conn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"DBQ=" & Server.MapPath("..") & "\data\publication\unzipped\;" & _
"Extensions=asc,csv,tab,txt,mer"
--cut--
and the SQLString is
--cut--
Rs.Open "SELECT * FROM adpfBiblio.mer", Conn, 1, 3
--cut--
the problem is i get the following message
--cut--
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/publication/import.asp, line 83
--cut--
line 83 being the "rs.open" statment
this code worked fine on my local server, so could it be that the text driver isn't
supported on the server? i have tried removing
the ",1,3" from the open statment, but i then get the following message
--cut--
[Microsoft][ODBC Text Driver] Cannot update. Database or object is read-only.
--cut--
why is it trying to "update" when i'm just executing a "SELECT" statment?
i hope this is clear enough :)
TIA
Cheers
Tim
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
