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]
