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 |
|
raginbullsht
Starting Member
8 Posts |
 Posted - 2009-04-28 : 13:10:36
|
| I have an access db that has 14000 jpeg images imbedded into the database and I am trying upload it into sql 2005, but when I am using the sql database with an asp page the images are not displaying properly. According to the asp develeper the problem is with access and sql when converting ole objects to simple binary.[url]http://demo.asprunner.net/jason_heyman_bgohio_org/card2/[/url]is a link to the asp page. Click on any of the view icons to see the jpeg issues. |
|
|
raginbullsht
Starting Member
8 Posts |
Posted - 2009-04-28 : 13:38:12
|
| I see this is somewhat covered in the sticky. Most suggest that I want to use links instead of blob data, but the end users of this web interface are very limited with computer skills and will not properly create links as need when new data is uploaded. |
 |
|
|
whitefang
Enterprise-Level Plonker Who's Not Wrong
272 Posts |
Posted - 2009-04-28 : 14:10:03
|
| No, the proper design should be that your DB should have "links" to the physical file. The user would upload the file through your web-interface which would store it on the server and then insert a link (the path) in the DB record. |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2009-04-28 : 14:15:42
|
| What version of SQL are you using and how are you importing the data from Access into SQL? |
|
|
|
raginbullsht
Starting Member
8 Posts |
Posted - 2009-04-28 : 14:44:19
|
| I am using sql 2005 and I am having the images directly scanned into the database by a contractor. Once all the records have been pushed into the database the end user will view/edit or upload any image changes with a asp page. I have a sample listed above |
|
|
|
maxime.gaboury
Starting Member
1 Post |
Posted - 2009-05-14 : 10:00:10
|
| So how can you transfert OLE OBJECT to BINARY Object? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-19 : 01:42:26
|
You can create a new VARBINARY(MAX) column and transfer all data between the two columnsUPDATE MyTableSET NewVarBinaryMaxColumn = OldColumnNameHere
E 12°55'05.63"N 56°04'39.26" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
convert access package (ole object) to binary