lxcc(虫莲)提供的网址是用SQL Server数据库,我不知道Oracle与之有多少区别,为什么我用这个程序不行。我的程序如下:
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim mstream As ADODB.Stream
Private Sub Command1_Click()
CommonDialog1.ShowOpen
strfile = 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, adLockOptimistic
Set mstream = New ADODB.Stream
mstream.Type = adTypeBinary
mstream.Open
mstream.Write rs.Fields("blob").Value
mstream.SaveToFile strfile, adSaveCreateOverWrite
rs.Close
cn.Close
End Sub
提示:
实时错误‘-2147467259(80004005)’:
数据类型不被支持。