I've inserted images into an sql table (image col) to view the image from an Access form This inserts the image successfully but Access doesn't display the picture: textcopy.exe /S myDesktop /U sa /P pass /D salesPeople /T tblImage /C personImage /W "WHERE ID = 001" /F cicsguy.jpg /I /Z the Access error when double clicking the image container "a problem occurred while access data project was communicating with the ole server or activex control....restart the ole server...try again" If I insert the image directly from my Access form, it works like a charm. What seems to be the problem ?
Do you have any Anti-virus software installed? Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
The Issue seems to be this: Added with Access, the data in the column is shown as: "Microsoft 3.0 photo editor photo" Added with TextCopy.exe, the data in the column is shown as: "Long Binary Data" So how do you get Access to display "Long Binary Data" as a picture I have no idea.
Refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q295824 which is related to the issue and resolve the problem. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
hi..... I am not able to insert an image in to sql server 2005 and frontend is c#.net. Plz help me........[:'(]
[quote user="destroyer"] I am not able to insert an image in to sql server 2005 and frontend is c#.net. [/quote] See if this helps: http://weblogs.sqlteam.com/peterl/archive/2007/09/26/Insert-binary-data-like-images-into-SQL-Server-without-front-end.aspx