lxcc(虫莲)提供的网址是用SQL Server数据库,我不知道Oracle与之有多少区别,为什么我用这个程序不行。我的程序如下: Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim mstream As ADODB.StreamPrivate Sub Command1_Click() CommonDialog1.ShowOpenstrfile = CommonDialog1.FileName Label1.Caption = strfile Image1.Picture = LoadPicture(strfile) End Sub Private Sub Command2_Click() Set cn = New ADODB.Connection cn.Open "provider=MSDAORA.1;User ID=mis;Password=mis;datasource=ss;Persist Security Info=False"Set rs = New ADODB.Recordset rs.Open "Select * from pic_test where id='1'", cn, adOpenKeyset, adLockOptimisticSet mstream = New ADODB.Stream mstream.Type = adTypeBinary mstream.Open mstream.Write rs.Fields("blob").Value mstream.SaveToFile strfile, adSaveCreateOverWriters.Close cn.CloseEnd Sub 提示: 实时错误‘-2147467259(80004005)’: 数据类型不被支持。
Dim bteData() As Byters.Fields("BLOB字段").AppendChunk bteData
你会发现它十分的灵活方便!
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim mstream As ADODB.StreamPrivate Sub Command1_Click()
CommonDialog1.ShowOpenstrfile = CommonDialog1.FileName
Label1.Caption = strfile
Image1.Picture = LoadPicture(strfile)
End Sub
Private Sub Command2_Click()
Set cn = New ADODB.Connection
cn.Open "provider=MSDAORA.1;User ID=mis;Password=mis;datasource=ss;Persist Security Info=False"Set rs = New ADODB.Recordset
rs.Open "Select * from pic_test where id='1'", cn, adOpenKeyset, adLockOptimisticSet mstream = New ADODB.Stream
mstream.Type = adTypeBinary
mstream.Open
mstream.Write rs.Fields("blob").Value
mstream.SaveToFile strfile, adSaveCreateOverWriters.Close
cn.CloseEnd Sub
提示:
实时错误‘-2147467259(80004005)’:
数据类型不被支持。
用ADO的数据流也可以,不过我不太喜欢用高版本的ADO,所以用这个最基本的方法替换了~~
rs.Open "Select * from pic_test where id='1'", cn, adOpenKeyset,
会出错,错误提示为:数据类型不被支持。
谁知道?帮帮我吧!急急急