Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
helixpoint
Constraint Violating Yak Guru
291 Posts |
 Posted - 2011-01-24 : 13:07:48
|
| Not to up on this, but I am doing the following statement. I am getting the following error:Does this mean that the file had to be on the server? Is there anyway I can do this from my laptop on a network?UPDATE dbo.Report_Image_LKPSET Image = (SELECT * FROM OPENROWSET(BULK 'C:\IMAGES\LetterHeadLogo.jpg', SINGLE_BLOB) AS derivedtbl_1)WHERE (Report_Image_LKP_ID = 5)Cannot bulk load because the file "C:\IMAGES\LetterHeadLogo.jpg" could not be opened. Operating system error code 3(The system cannot find the path specified.).DaveHelixpoint Web Developmenthttp://www.helixpoint.com |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-24 : 13:10:27
|
| yup. if you're running it on local machine use UNC path instead as //server/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-01-25 : 03:41:09
|
quote:
Originally posted by visakh16
yup. if you're running it on local machine use UNC path instead as //server/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
It should be \\server\file_pathMadhivananFailing to plan is Planning to fail |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-01-26 : 03:22:01
|
quote:
Originally posted by madhivanan
quote:
Originally posted by visakh16
yup. if you're running it on local machine use UNC path instead as //server/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
It should be \\server\file_pathMadhivananFailing to plan is Planning to fail
Shouldn't it be rather \\remotemachine\file_path?PBUH |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-01-27 : 04:33:51
|
quote:
Originally posted by Sachin.Nand
quote:
Originally posted by madhivanan
quote:
Originally posted by visakh16
yup. if you're running it on local machine use UNC path instead as //server/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
It should be \\server\file_pathMadhivananFailing to plan is Planning to fail
Shouldn't it be rather \\remotemachine\file_path?PBUH
Yes. It isMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
trying to do a bulkload for images