Click here to Skip to main content
15,891,136 members
Home / Discussions / Web Development
   

Web Development

 
QuestionHow to ... in Crystal Report 9? Pin
HyVong16-Sep-04 12:29
HyVong16-Sep-04 12:29 
GeneralExcel loader to asp Pin
steve75916-Sep-04 7:28
steve75916-Sep-04 7:28 
GeneralProblems in user control name after installing .NetFramework 1.0 sp1 Pin
GanesanM16-Sep-04 5:01
GanesanM16-Sep-04 5:01 
GeneralSynchronization between two web pages asp 3 Pin
jackboy7016-Sep-04 4:15
jackboy7016-Sep-04 4:15 
GeneralRe: Synchronization between two web pages asp 3 Pin
jackboy7016-Sep-04 4:18
jackboy7016-Sep-04 4:18 
Generalencoding problem Pin
karanba16-Sep-04 3:36
karanba16-Sep-04 3:36 
Generalstored images from image sqlfield to hard disk Pin
Anonymous15-Sep-04 0:25
Anonymous15-Sep-04 0:25 
GeneralRe: stored images from image sqlfield to hard disk Pin
iwcsecure18-Sep-04 11:36
iwcsecure18-Sep-04 11:36 
Howdey

Now you can look at my code but before you do that there is only two things that you must check.

(1) Do you have MDAC 2.5 or later installed (I think the Stream object is in any case only included in version 2.5 and later ...)

(2) I'm not using late binding - you are.

Other than that I don't know why you would get that error message.
Good luck anyways!

Below is my code:

Dim Rst As New ADODB.Recordset
Dim adoCon As New ADODB.Connection

Public Sub TEST_OPEN()
adoCon.ConnectionString = "PROVIDER=SQLOLEDB;DATA SOURCE=IANLAP;DATABASE=MYDB;USER ID=developer;PASSWORD=developer;"
adoCon.Open
'
Dim s As String

'
s = "Select [id],[data] From [tblImage] Where [id]=1"
Set Rst.ActiveConnection = adoCon
Rst.LockType = adLockOptimistic
Rst.CursorType = adOpenKeyset
Rst.Open s
'
Dim mStream As New ADODB.Stream
'
If Dir("C:\temppicture.bmp") <> "" Then Kill "C:\temppicture.bmp"

'
With mStream
.Type = adTypeBinary

.Open
.Write Rst("data")

.SaveToFile "C:\temppicture.bmp"
.Close
End With
Set mStream = Nothing
'
Rst.Close
Set Rst = Nothing
End Sub


Ian
Generalconnecting to MS ACCESS in PHP Pin
samithas14-Sep-04 20:14
samithas14-Sep-04 20:14 
GeneralRe: connecting to MS ACCESS in PHP Pin
Milan200721-Sep-04 15:27
Milan200721-Sep-04 15:27 
GeneralWeb Documnetation pages generated by VS 2003 Pin
Gary Hyslop at home14-Sep-04 10:29
Gary Hyslop at home14-Sep-04 10:29 
GeneralRe: Web Documnetation pages generated by VS 2003 Pin
Syed Abdul Khader16-Sep-04 2:18
Syed Abdul Khader16-Sep-04 2:18 
GeneralXML Web Services AUTHENTICATION with C#.net Pin
programming14-Sep-04 5:58
programming14-Sep-04 5:58 
GeneralRe: XML Web Services AUTHENTICATION with C#.net Pin
Kodanda Pani17-Sep-04 23:08
Kodanda Pani17-Sep-04 23:08 
Questionhow to disappear save as menu from browser Pin
ashu_aegis14-Sep-04 3:36
ashu_aegis14-Sep-04 3:36 
AnswerRe: how to disappear save as menu from browser Pin
Steven Campbell14-Sep-04 8:06
Steven Campbell14-Sep-04 8:06 
GeneralImage Management Pin
zumichu13-Sep-04 19:49
zumichu13-Sep-04 19:49 
GeneralRe: Image Management Pin
Steven Campbell14-Sep-04 4:27
Steven Campbell14-Sep-04 4:27 
GeneralProtect ASP application files Pin
TPN13-Sep-04 18:31
TPN13-Sep-04 18:31 
GeneralRe: Protect ASP application files Pin
Steven Campbell14-Sep-04 2:43
Steven Campbell14-Sep-04 2:43 
GeneralSPF: Sender Policy Framework Pin
osblues13-Sep-04 13:03
osblues13-Sep-04 13:03 
GeneralRe: SPF: Sender Policy Framework Pin
osblues21-Sep-04 1:57
osblues21-Sep-04 1:57 
GeneralIIS/ASP/ASPX Pin
Anonymous13-Sep-04 10:12
Anonymous13-Sep-04 10:12 
GeneralRe: IIS/ASP/ASPX Pin
Mike Ellison13-Sep-04 11:28
Mike Ellison13-Sep-04 11:28 
GeneralRe: IIS/ASP/ASPX Pin
Anonymous13-Sep-04 12:12
Anonymous13-Sep-04 12:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.