Have you got a schema.ini file set up to describe this .mer file? Mark
-----Original Message----- From: Tim Fletcher [mailto:[EMAIL PROTECTED]] Sent: dinsdag 10 september 2002 11:33 To: ActiveServerPages Subject: DB text driver 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.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
