Mario, I also noticed that you have the file named test.csv in one place and test.cvs in another place. Other than that, I'm not sure what could be wrong. You are correct in calling the filename in the query ie. 'select * from test.csv'
----- Original Message ----- From: "Mario Martinez R." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 3:13 PM Subject: Re: ODBC and cvs files > I gave access to everyone user to the folder where the > file is holded , and the file is not read only either. > When I test the ODBC conecction through the CF > Administrator page it works . I must have had > something wrong but I can figure out what is going on. > Any help would be appreciated. > Mario > > --- Marlon Moyer <[EMAIL PROTECTED]> escribió: > > Just a stab in the dark, but did you make sure > > test1.cvs is not marked read > > only in the file system? > > > > Marlon > > > > ----- Original Message ----- > > From: "Mario Martinez R." <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, April 09, 2002 12:48 PM > > Subject: ODBC and cvs files > > > > > > > Hi friends: > > > I'm trying to make a query from a csv file > > > (test1.csv). > > > The way I thought was to make an ODBC entry for > > text > > > files . In the ODBC entry I only can specify the > > > directory not the file name. > > > So I guessed I had to include that in the final > > query. > > > There is something I'm missing . > > > I will appreciate your help.Any new ideas could be > > > great too. > > > Down the code and what I see in my browser . > > > Thanks for any help > > > Mario > > > > > > //my code > > > <cfquery name="InstrLedAttQuery" > > > datasource="EkOutsideFiles" dbtype="ODBC"> > > > SELECT * FROM test1.cvs > > > </cfquery> > > > > > > //What I get in my browser > > > Error Diagnostic Information > > > ODBC Error Code = 42000 (Syntax error or access > > > violation) > > > > > > [Microsoft][ODBC Text Driver] Cannot update. > > Database > > > or object is read-only. > > > > > > The error occurred while processing an element > > with a > > > general identifier of (CFQUERY), occupying > > document > > > position (199:1) to (199:75). > > > > > > Date/Time: 03/11/02 12:20:20 > > > Browser: Mozilla/4.0 (compatible; MSIE 5.01; > > Windows > > > NT 5.0) > > > Remote Address: 66.109.35.50 > > > > > > > > > > > > _________________________________________________________ > > > Do You Yahoo!? > > > Información de Estados Unidos y América Latina, en > > Yahoo! Noticias. > > > Visítanos en http://noticias.espanol.yahoo.com > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
