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 > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
