Hello >i think the problem is that i'm assuming that the text driver properties defaults to >: '"' for text delimiters, ';' for field >delimiters and lfcr for end of row
I think so too. You have various options: >can i specifi this in my conn string or does it have to be done using the scheme.ini http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp Explains in detail what schema.ini can do for you (and yes, it includes setting field delimiters). I strongly recommend you read this and put it into practice. Connection strings - the first port of call is always: http://www.able-consulting.com/ADO_Conn.htm There are various options you can set there as well. Whilst I'm at it, you are aware I take it that you cannot execute update or delete statements against a text file? Mark -----Original Message----- From: Tim Fletcher [mailto:[EMAIL PROTECTED]] Sent: dinsdag 10 september 2002 15:14 To: ActiveServerPages Subject: RE: DB text driver hi mark, i have attached a sample of the db file (.txt) at the bottom of the mail. it has 20 fields for each record, but when tested for the number of fields with the Rs.Fields.Count, it returns 2. (here is the code) --cut-- Set Conn = Server.CreateObject("ADODB.Connection") Set Rs = Server.CreateObject("ADODB.Recordset") ' debug test 'Response.write "Driver={Microsoft Text Driver (*.txt; *.csv)};" & "DBQ=" & Server.MapPath("..") & "\data\publication\unzipped\;" & "Extensions=asc,csv,tab,txt,mer" conn.Open "DRIVER={Microsoft Text Driver (*.txt; *.csv)};" & _ "DBQ=" & Server.MapPath("..") & "\data\publication\unzipped\;", "", "" rs.open "SELECT * FROM adpfBiblio.txt", conn response.write rs.fields.count rs.close conn.close set rs=nothing set conn=nothing --cut-- i think the problem is that i'm assuming that the text driver properties defaults to : '"' for text delimiters, ';' for field delimiters and lfcr for end of row can i specifi this in my conn string or does it have to be done using the scheme.ini Thanks Tim --data-- Titre;Edition;Collection;Description;R�f�rence;Prix;Nombre_de_pages;Date_parution;Th�me;Rubrique;Type;Nombre_de_volumes;Coffret;Impo rtance;Traduction,_langue;Identifiant;Th�me2;Rubrique2;Th�me3;Rubrique3;SaisiePar;Source "Itin�raire du patrimoine";"�d. du Patrimoine";"coll. � Itin�raire du patrimoine �";"ill. noir et coul.";"";"39 F";"";"2000";"Architecture";"ARCHITECTURE";"livre";"";"";"";"";"1008";"";"";"";"";"c�line";"vient de para�tre N�2" "Voyage au Cambodge. L'architecture khmer";"Maisonneuve et Larose";"";"ill. noir";"ISBN : 2-7068-1374-1";"190 F";"462 p.";"2000";"Architecture";"ARCHITECTURE";"livre";"";"";"";"";"1009";"";"";"";"";"c�line";"vient de para�tre N�2" "L'Invention du b�ton arm�. Hennebique 1890-1914";"Norma";"";"";"ISBN : 2-909283-46-1";"160 F";"345 p.";"2000";"Architecture";"ARCHITECTURE";"livre";"";"";"";"";"1010";"";"";"";"";"c�line";"vient de para�tre N�2" "Le Grand Louvre. De la Pyramide � l'Orangerie";"Le Moniteur ";"";"ill. noir et coul.";"ISBN : 2-281-19110-9";"245 F";"216 p";"2000";"Architecture";"ARCHITECTURE";"livre";"";"";"";"";"1011";"";"";"";"";"c�line";"vient de para�tre N�2" "Le B�ton � Paris";"Pavillon de l'Arsenal, Picard";"";"ill. noir et coul.";"ISBN : 2-7084-0559-4.";"230 F";"224 p.";"2000";"Architecture";"ARCHITECTURE";"livre";"";"";"";"";"1012";"";"";"";"";"c�line";"vient de para�tre N�2" "L'Effondrement de la Tr�s Grande Biblioth�que de France. Ses causes, ses cons�quenses";"�d. de l'Encyclop�die des nuisances";"";"";"ISBN : 2-910386-10-4";"75 F";"130 p.";"2000";"Architecture";"ARCHITECTURE";"livre";"";"";"";"";"1013";"";"";"";"";"c�line";"vient de para�tre N�2" "Regards sur l'immeuble priv�. Architecture d'un habitat (1880-1970)";"Le Moniteur";"";"ill. noir";"ISBN : 2-281-19103-6";"230 F";"227 p.";"2000";"Architecture";"ARCHITECTURE";"livre";"";"";"";"";"1014";"";"";"";"";"c�line";"vient de para�tre N�2" "Les Grandes Dates de l'architecture en Europe de 1850 � nos jours";"PUF";"coll. � Que sais-je ? �, no 3439";"";"ISBN : 2-13-049649-0";"42 F";"126 p.";"2000";"Architecture";"ARCHITECTURE";"livre";"";"";"";"";"1015";"";"";"";"";"c�line";"vient de para�tre N�2" "Architecture et Modestie";"Th��t�te �ditions";"";"ill. noir";"ISBN : 2-912860-12-1";"100 F";"97 p.";"2000";"Architecture";"ARCHITECTURE";"livre";"";"";"";"";"1016";"";"";"";"";"c�line";"vient de para�tre N�2" "La Mouvance. Du jardin au territoire, cinquante mots pour le paysage";"La Villette";"";"ill. noir";"ISBN : 2-903539-49-9";"60 F";"95 p.";"2000";"Architecture";"JARDINS ET PAYSAGES";"livre";"";"";"";"";"1017";"";"";"";"";"c�line";"vient de para�tre N�2" "France, terre de paysages";"F. Hazan";"";"ill. coul.";"ISBN : 2-85025-675-7";"275 F";"57 p.";"2000";"Architecture";"JARDINS ET PAYSAGES";"livre";"";"";"";"";"1018";"";"";"";"";"c�line";"vient de para�tre N�2" "Paris, avenir de la France";"L'Aube ";"";"ill. noir";"ISBN : 2-87678-480-7";"120 F";"198 p.";"2000";"Architecture";"URBANISME";"livre";"";"";"";"";"1019";"";"";"";"";"c�line";"vient de para�tre N�2" "Le Dessus des cartes : un atlas parisien";"Pavillon de l'Arsenal, Picard";"";"ill. noir et coul.";"ISBN : 2-7084-0570-5";"330 F";"288 p.";"2000";"Architecture";"URBANISME";"livre";"";"";"";"";"1020";"";"";"";"";"c�line";"vient de para�tre N�2" "Paris, biographie d'une capitale";"Hazan ";"";" ill. noir";"ISBN : 2-85025-671-4";"150 F";"268 p.";"2000";"Architecture";"URBANISME";"livre";"";"";"";"";"1021";"";"";"";"";"c�line";"vient de para�tre N�2" "Changer la ville. Pour une nouvelle urbanit�";"Odile Jacob";"";"";"ISBN : 2-7381-0706-0";"125 F";"219 p.";"2000";"Architecture";"URBANISME";"livre";"";"";"";"";"1022";"";"";"";"";"c�line";"vient de para�tre N�2" "Mon catalogue";"FRAC Limousin";"";"";"ISBN : 2-908257-24-6";"15O F";"non pagin�";"2000";"Art";"";"livre";"";"";"";"";"1023";"";"";"";"";"c�line";"vient de para�tre N�2" "Mon grand-p�re";"Allia";"";"";"ISBN : 2-844885-009-X";"4O F";"64 p.";"2000";"Art";"";"livre";"";"";"";"";"1024";"";"";"";"";"c�line";"vient de para�tre N�2" "Lettres � Bettine";"Actes Sud";"";"";"ISBN : 2-7427-2391-9";"189 F";"624 p.";"2000";"Art";"";"livre";"";"";"";"";"1025";"";"";"";"";"c�line";"vient de para�tre N�2" "Mais comment taire mes commentaires ?";"ENSBA";"coll. � �crits d'artistes �";"";"ISBN : 2-840 56-068-2";"1OO F";"27O p.";"2000";"Art";"";"livre";"";"";"";"";"1026";"";"";"";"";"c�line";"vient de para�tre N�2" "Cinquante Esp�ces d'espace";"Centre Pompidou / Mus�es de Marseille / RMN";"";"";"";"";"";"2000";"Art";"";"";"";"";"";"";"1027";"";"";"";"";"c�line";"vient de para�tre N�2" "Le Bo�tier de m�lancolie. La photographie en cent photographies";"Hazan";"";"";"ISBN : 2-85025-672-2";"298 F";"214 p.";"2000";"Art";"";"livre";"";"";"";"";"1028";"";"";"";"";"c�line";"vient de para�tre N�2" "Comix 2000";"L'Association";"";"noir";"ISBN : 2-84414-022-X";"365 F";"2000 p.";"2000";"Bande dessin�e";"";"livre";"";"";"";"";"1029";"";"";"";"";"c�line";"vient de para�tre N�2" "Sol�dango. Cand�labres, 1";"Delcourt";"";"coul.";"ISBN : 2-84055-256-6";"58 F";"48 p.";"2000";"Bande dessin�e";"";"livre";"";"";"";"";"1030";"";"";"";"";"c�line";"vient de para�tre N�2" "Gen�se. Universal war one, 1";"Soleil";"";"coul.";"ISBN : 2-87764-807-9";"79 F";"46 p.";"2000";"Bande dessin�e";"";"livre";"";"";"";"";"1031";"";"";"";"";"c�line";"vient de para�tre N�2" "Le R�ducteur de vitesse";"Dupuis";"coll. � Aire libre �";"coul.";"ISBN : 2-8001-2801-1";"79 F";"80 p.";"2000";"Bande dessin�e";"";"livre";"";"";"";"";"1032";"";"";"";"";"c�line";"vient de para�tre N�2" "Blotch. Le roi de Paris";"Audie / Fluide Glacial";"";"noir";"ISBN : 2-85815-263-2";"54 F";"50 p.";"2000";"Bande dessin�e";"";"livre";"";"";"";"";"1033";"";"";"";"";"c�line";"vient de para�tre N�2" "Le Mariage de monsieur Lakonik";"Mus�e de la Bande dessin�e";"coll. � Biblioth�que du 9e Art �";"bichromie";"ISBN : 2-907848-23-2";"95 F";"48 p.";"2000";"Bande dessin�e";"";"livre";"";"";"";"";"1034";"";"";"";"";"c�line";"vient de para�tre N�2" "Maestro";"Mus�e de la Bande dessin�e";"coll. � Biblioth�que du 9e Art �";"noir";"ISBN : 2-907848-19-4";"95 F";"120 p.";"2000";"Bande dessin�e";"";"livre";"";"";"";"";"1035";"";"";"";"";"c�line";"vient de para�tre N�2" --data-- -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoy� : mardi 10 septembre 2002 12:01 � : ActiveServerPages Objet : RE: DB text driver Hello when i change the extension from .mer to .csv, i don't get any errors, except it is not doing what it should :( So what does it do? Code, error messages etc? do i need special rights on the server to use the schema.ini? just write access, which you obviously have do you know of a good reference page? First one on this link is good: http://www.google.com/search?hl=en&ie=ISO-8859-1&q=schema.ini Cheers Mark -----Original Message----- From: Tim Fletcher [mailto:[EMAIL PROTECTED]] Sent: dinsdag 10 september 2002 11:56 To: ActiveServerPages Subject: RE: DB text driver when i change the extension from .mer to .csv, i don't get any errors, except it is not doing what it should :( do i need special rights on the server to use the schema.ini? do you know of a good reference page? Thanks for your help Cheers Tim -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoy� : mardi 10 septembre 2002 11:40 � : ActiveServerPages Objet : RE: DB text driver 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.unsub%% --- 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.unsub%% --- 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]
