现在需要用vb连接oracle数据库,读取clob数据。但是用ado连接oracle后,对表select,然后就报错。认为不支持clob的select。代码如下:
Dim cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim rst As New ADODB.Recordset
Dim j As Integer
cn.Open "Provider=MSDAORA.1;User ID=as;password=342;Data Source=192.168.0.1;Persist Security Info=False"
Set cmd.ActiveConnection = cn
'cmd.Source = "select * from table"
rst.ActiveConnection = cn
rst.LockType = adLockOptimistic
rst.Source = "select STATIONID from table"
rst.CursorLocation = adUseClient
rst.Open'此处报错。错误为不支持类型。就是select的*里边包括clob数据。所以select出错。大家帮我看看需要怎么改。非常感谢。
Dim cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim rst As New ADODB.Recordset
Dim j As Integer
cn.Open "Provider=MSDAORA.1;User ID=as;password=342;Data Source=192.168.0.1;Persist Security Info=False"
Set cmd.ActiveConnection = cn
'cmd.Source = "select * from table"
rst.ActiveConnection = cn
rst.LockType = adLockOptimistic
rst.Source = "select STATIONID from table"
rst.CursorLocation = adUseClient
rst.Open'此处报错。错误为不支持类型。就是select的*里边包括clob数据。所以select出错。大家帮我看看需要怎么改。非常感谢。
解决方案 »
- 如何在picture里面播放avi视频?如何从picture中直接提取某刻图像对其操作?
- teechart的point序列,单击时怎样获得最近点的值
- 一个奇怪的现象,MS的产品怎么很少看到VB做的呢?
- 小弟对硬件一跷不通,按装显卡驱动是不是要先知道主板的生产厂家?那应该怎么来判断我机子上的主板是哪个厂生产的?
- 常州的软件高手来看看(我们要招人才)
- 有谁知道用richtext控件显示带颜色的VB代码?谢谢!
- 怎么让记录指针返回到第几条记录上?
- 怎样学VB???
- 高手的标准是什么?
- 请问VB能否调用winsock api的一系列函数呢?
- 做个财务系统交作业
- 利用VB建立鼠标键盘操作回放,回放中怎么停止它?
Dim cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim rst As New ADODB.Recordset
Dim j As Integer
cn.Open "Provider=MSDAORA.1;User ID=as;password=342;Data Source=192.168.0.1;Persist Security Info=False"
'Set cmd.ActiveConnection = cn
'cmd.Source = "select * from table"
rst.ActiveConnection = cn
rst.LockType = adLockOptimistic
rst.Source = "select STATIONID from table"
rst.CursorLocation = adUseClient
rst.Open "select * from table",cn