> > Hello, > > Thank you for your prompt reply. > > i did as you sayed, but still getting the same > error: > > > C:\maxdb\programs\bin> > C:\maxdb\programs\bin>loadercli -u DBA,dba -d crap1 > Loader Server Protocol File: > 'c:\maxdb\data\wrk\loader.prt' > > User DBA connected to database CRAP1 on local host. > loadercli> > DATALOAD TABLE dba.contacts contactid 1 surename 2 > INFILE 'c:\maxdb\tests\contac > ts.csv' SEPARATOR ';' > ERR -25502 > Error opening file '1': wrong file or device name. > > --- > loadercli> > > > > The log for the loader has the following: > > // M START 20040112 00130215 > // * > USE USER "DBA" * SERVERDB "CRAP1" > // * > // M USER: 'DBA' on DB: 'CRAP1' > // * > // M START 20040112 00130228 > // * > DATALOAD TABLE dba.contacts contactid 1 surename 2 > INFILE 'c:\maxdb\tests\contacts.csv' SEPARATOR ';' > // * > // E -25502: Error opening file '1': wrong file or > device name. > // M Error at record 1 in infile. > // E -25502: Error opening file '1': wrong file or > device name. > // M Last transaction committed at input record 0 > // * > // M Sum of inserted records 0, sum of rejected > records 1 > // * > > > Any ideas on what's going wrong? i'm using latest > maxdb on win2000. > > Thank you again for your help and looking forward to > your response. > > > > > --- "Schildberg, Steffen" > <[EMAIL PROTECTED]> > wrote: > > Hi Matt, > > > > > > matt rogers [mailto:[EMAIL PROTECTED] wrote: > > > > > > i created the database and table in maxdb, but > > when i > > > run the loader the following error happens: > > > > > > loadercli -u DBA,dba -d crap1 -b > > > c:\maxdb\tests\imp.txt > > > > > > where imp.txt is: > > > > > > DATALOAD TABLE dba.contacts > > > contactid 1 > > > surename 2 > > > INFILE 'C:\maxdb\tests\contacts.csv' > > > SEPARATOR ';' > > > > > > > > > and contects.csv is: > > > > > > "1";"Smith" > > > "2";"Robinson" > > > "3";"Cage" > > > > > > the paths i verified that are all correct. > > > > > > the error i get is: > > > > > > > > > C:\maxdb\programs\bin>loadercli -u DBA,dba -d > > crap1 -b > > > c:\maxdb\tests\imp.txt Loader Server Protocol > > File: > > > 'c:\maxdb\data\wrk\loader.prt' > > > > > > User DBA connected to database CRAP1 on local > > host. > > > DATALOAD TABLE dba.contacts > > > contactid 1 > > > surename 2 > > > INFILE 'C:\maxdb\tests\contacts.csv' > > > SEPARATOR ';' > > > > > > Error during execution > > > -->-25502 > > > Error opening file '1': wrong file or device > name. > > > > > > Defined maximum number of errors (1) reached > > > > > > > > > 1 error(s) during execution of command file > > > 'c:\maxdb\tests\imp.txt'. ---> > > > See log file(s) for more information. > > > > > I have not the faintest idea what's going wrong > > here. But > > could you please have a look into the loader.prt > (if > > not > > yet done) and see if there is some usable > > information. > > I suppose you use version 7.5.00.05? > > If there is nothing found in the logfile try to > run > > the > > statement directly from the command line. It looks > > like the > > Loader interprets the pos of the first column as > > file name - huh. > > Are there any special/hidden characters in your > cmd > > file? > > Ok, to run the command from the command prompt use > > the command > > line: > > loadercli -u DBA,dba -d crap1 > > > > without specifying the imp.txt file. Then the > Loader > > will prompt you for > > the command. Type it in and run and see. Well, and > > let me know. > > > > Regards, > > Steffen > > -- > > Steffen Schildberg > > SAP DB Team > > SAP Labs Berlin > > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Hotjobs: Enter the "Signing Bonus" > Sweepstakes > http://hotjobs.sweepstakes.yahoo.com/signingbonus >
__________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
