ADODB.Stream error when i try to get and re-generate it on server

Question

0.00/5 (No votes)

See more:

I wrote this code in vb6 , it 's work

But it 's error on ASP

How do i resolve this problem.

PS:please observe the position wich i made underline

XML

Set Stream = Server.CreateObject("adodb.Stream")

Set rx = Server.CreateObject("adodb.recordset")<br>
rx.open "select top 1 Picturefield from databasePicture",cn,3,3


if not rx.eof then
Stream.open<br>
<big>Stream.Write rx("Picturefield") '<-- This line generate err-->ADODB.Stream error '800a0bb9'
<br>If </br></big>fso.FileExists(px & filename ) Then 'check old file exists!<br>
fso.DeleteFile  px & filename  'delete old file<br>
end if
Stream.SaveToFile  px & filename    'save bin to file<br>
Stream.Close<br>
Set Stream = Nothing <br>
End if</br></br></br></br></br></br></br>

Posted 13-Dec-10 1:23am

chatbundid

Updated 13-Dec-10 13:54pm

v4

Add a Solution

Comments

Toniyo Jackson 13-Dec-10 7:27am

Corrected the alignment.

Dave Kreskowiak 13-Dec-10 15:42pm

You left out the most important part of your question. WHAT'S THE ERROR?!

Sandeep Mewara 13-Dec-10 23:29pm

Update the question with error.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Accepted Answer · 2010-12-15T11:26:00

Solution 1

Why didn't you included the complete error message in your question otherwise you would get the solution 2 days ago.

Full error message is:

ADODB.Stream error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

Any way try the below link which has answer.

You need to reference the ado constants....also compare the code with the referred ink.

ADODB.Stream error[^]

Posted 15-Dec-10 11:26am

thatraja

Updated 15-Dec-10 11:39am

v2

Comments

Dalek Dave 15-Dec-10 18:32pm

You must be psychic!

thatraja 15-Dec-10 18:43pm

Not at all/may be. Actually I was worked AB6, ASP too which is the main reason to remember the errors. :-)