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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-25 : 13:10:43
|
Phil J. writes "Sean,
We have a directive for a project to use IBM's DB2 UDB for our database. (Basically a DB2 for a PC database server). One table is intended to hold images, both gif and jpeg; this column is designated as a "Blob" data type. We have run into a brick wall
in trying to insert the image into the database...keep getting the error that DB2 is expecting more parameters. I know we have a valid reference to the image, because I can do a
Response.BinaryWrite imagevar on the page and get the image fine
on the page. We do a
rs("MyImage").AppendChunk imagevar to attempt the insert, and have tried rs("MyImage") = imagevar with every combination of
cursor type, etc. to no avail.
Any ideas at all would be appreciated - the above syntax may be slightly flawed, as I am at home, away from my code...Our DBA people and all DB2 UDB documention are pretty much in a mainframe IBM OS-390 mindset, so they are at a loss as well.
We are trying this on a Windows NT box, running IIS and ASP,
and VBScript 5.1 - the DB2 UDB is on another box. Commenting
out the reference to the blob field insert allows inserts of the
other two fields, ID and ContentType just fine.
Again, any insights would be greatly appreciated!!!
Phil Jackson
Texas Farm Bureau" |
|
|
|
|
|
Using ASP ADO to insert BLOBs into a DB2 UDB database