title: how to get clob data with vb6
body: <p>I want to get clob data with vb 6 . For this purpose , I have written the following code  :</p>
  
  <pre><code>    Dim conn As New ADODB.Connection
  Dim cmd As New ADODB.Command
  Dim rs As New ADODB.Recordset
  Dim cn As String
  Dim fingerdata1 As String
  Dim SQL As String
  
  Private Sub Command1_Click()
  conn.Open cn
  cmd.ActiveConnection = conn
  conn.CursorLocation = adUseClient
  SQL = "select FINGERDATA from FINGERDATA"
   rs.ActiveConnection = conn
    rs.CursorLocation = adUseServer
  rs.LockType = adLockReadOnly
  rs.Source = SQL
  rs.Open
  rs.MoveFirst ' to be safe
  Do While Not rs.EOF
         fingerdata1 = rs.Fields("FINGERDATA").Value
         MsgBox (fingerdata1)
         rs.MoveNext
  Loop
  End Sub
  
  Private Sub Form_Load()
  cn = "Provider=MSDAORA.1;Password=fingerprintdata;User ID=fingerprintdata;Data Source=10.11.201.84;Persist Security Info=True"
  End Sub
  </code></pre>
  
  <p>But when I am running this code , I am getting the following error : </p>
  
  <p><a href="https://i.stack.imgur.com/gi15u.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gi15u.png" alt="enter image description here"></a></p>
  
  <p>How can I solve this error ? Please help me to get clob data from oracle in vb6 . </p>