Ubuntu

Hi,

Anyone can help me, I can connect from ubuntu "freetds driver" to Windows sqlserver Database and doing select, insert, update, etc.

But when I try to use the Bulk Insert with these command;

1> BULK INSERT test FROM '/home/test/test.txt' WITH (FIRSTROW = 2, CODEPAGE = 'ACP', DATAFILETYPE = 'char', FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')
2> go
Msg 4861, Level 16, State 1, Server GMSERVER, Line 1
Cannot bulk load because the file "/home/test/test.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.).

Thanks in Advance.

The documentation for BULK INSERT confirms what I suspected: the path you specify has to be reachable from the server the database is running on, which isn't true for a local UNIX path. You can either install & configure Samba and specify a UNC path, or upload the file to a location that the server knows & load it from there.

Hi Pludi,

Now it works, so sweet.

Cheers