when insert image in sql server 2005 ,i got this error(Cannot bulk load. The file "C:\photo.PNG" does not exist.)

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

This is my query

CREATE TABLE myTable(Photo varbinary(max))

INSERT INTO myTable(photo)
SELECT * FROM
OPENROWSET(BULK 'C:\photo.PNG', SINGLE_BLOB)as Image

ERROR:Cannot bulk load. The file "C:\photo.PNG" does not exist.

please help me ............

Posted 10-Aug-13 8:27am

Nag226

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manas Bhardwaj · Answer 1 · 2013-08-10T08:29:00

Solution 1

Is that file on the SQL Server's C:\ drive?? SQL BULK INSERT etc. always works only with local drive on the SQL Server machine. Your SQL Server cannot reach onto your own local drive.

You need to put the file onto the SQL Server's C:\ drive and try again.

Posted 10-Aug-13 8:29am

Manas Bhardwaj

Comments

Nag226 10-Aug-13 14:34pm

my inserted image placed in c:\photo.png(path of my image) is it work if it is placed in this path

Maciej Los 10-Aug-13 14:36pm

Move file to SQL server machine.

Manas Bhardwaj 10-Aug-13 14:38pm

Right! But for that you might end up seeing another question on code project.

i.e. How to move file to SQL Server machine? ;)

Maciej Los 10-Aug-13 15:13pm

Reported as repost ;)

Maciej Los 10-Aug-13 14:36pm

+5!

Manas Bhardwaj 10-Aug-13 14:37pm

thx!

silvercr0w · Answer 2 · 2013-08-10T08:32:00

Solution 2

Make sure if you have permission to read directly from C drive. Try adding the file into a folder. Something like "C:\Folder\photo.PNG".

Posted 10-Aug-13 8:32am

silvercr0w

Comments

Nag226 10-Aug-13 14:38pm

sorry to say the same error message is shown again(Cannot bulk load. The file "C:\Images\photo.PNG" does not exist.)