Exporting Image data to local hard drive

Question

Post reply

Exporting Image data to local hard drive

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323741 More actions · Answer 1

the server thinks C:\ drive is it's own drive....

to write to your PC, you need to use a UNC path:

\\YOURPCNAME\c$\ImageFolder

that might not work if the account that the SQL Service is running under(NOT the login you are using!) has access to network shares or not.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

bryan.duchesne Ten Centuries Points: 1134 More actions · Answer 2

Unfortunately, our network does not support that way of addressing the local PC.

Lowell SSC Guru Points: 323741 More actions · Answer 3

in that case, if you cannot access the server's C:\Temp folder as in your example, you'll have to use some intermediate item...a vbscript, your own program, etc to connect to SQL from your PC, download the image from the db, and write it to local disk;

here's the first gfoogle item i found:

http://www.motobit.com/tips/detpg_read-write-binary-files/

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

bryan.duchesne Ten Centuries Points: 1134 More actions · Answer 4

Thanks for all the tips. I wrote a VB.NET application (very small) that does the job that I need.