January 12, 2015 at 3:23 am
Hi Friends,
I have the Image in FTP Server Folder and i need to insert that image into my local database.
How can i do this I tried with the below Query but i shows the errors as below.
Please help me to solve this solution.
--INSERT INTO AcademyStudents (ImageURL)
--SELECT BULKCOLUMN FROM OPENROWSET(BULK'https://iconic-solutions.net/OTA/test/images(1).jpeg',Single_Blob) AS BLOB
--Where StudentIdentificationNum = 2
--GO
GOt Error
;
Cannot bulk load because the file "https://iconic-solutions.net/OTA/test/images(1).jpeg" could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.).
January 12, 2015 at 8:20 am
Does the login for SQL Server have privs to see that other machine? And I'm not sure that an HTTP address will actually work with OpenRowset. A UNC will but I don't believe a web address like that will.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply