ODBC LONG/MEMO PROBLEM

From: Yves-Patrice Kerremans <patrice_at_netit.be>
Date: Mon, 17 Aug 1998 13:01:25 +0200
Message-ID: <35D80D85.2C1739A8@netit.be>

I'm using the Oracle7 32-bit ODBC Driver for Windows NT and Windows 95 Version 2.5.3.1.0b Production.

And I'm having a little problem with the following ASP-code (the error that occurs is 'errors occurred' -see the *** in the code). Anyone any ideas?

Thanks,

Patrice.

patrice_at_thepentagon.com

Set DB = Server.CreateObject("ADODB.Connection") DB.Open ConnectionString()

SQL = "SELECT doctext FROM texttable WHERE ID = " & ID 'ID is a valid id in the table!!!
Set rs = Server.CreateObject("ADODB.Recordset") rs.CursorType = adOpenDynamic
rs.open SQL, DB

  if not rs.EOF AND not RS.BOF then
   TextHRN = rs.fields(0).value '*** here the erro occurs   else
   'No documents available to edit/delete.   end if

rs.Close

DB.Close Received on Mon Aug 17 1998 - 06:01:25 CDT