Can ASP handle the SQL text datatype ?



When I try to use it in my ASP page it returns the following error ...



	error '80020009' 

	Exception occurred. 



Any ideas ?



Thanks for your help.

Yes, it can handle SQL text.  Could you paste in your code for your 

connection string?  You would need to specify this as adCmdText in the 

[options] section when you open your recordset.  Here's a small example:



Set MyRS = Server.CreateObject("ADODB.RecordSet")

Set MyRS.ActiveConnection = MyConn

SQL = "SELECT * FROM myTable"

MyRS.Open SQL, MyConn, adOpenDynamic, adLockPessimistic, adCmdText





lemme know if you need anything else.



shawn





On 04/18/00, ""Jim Tait" wrote:

> Can ASP handle the SQL text datatype ?



When I try to use it in my ASP page it returns the following error ...



	error '80020009' 

	Exception occurred. 



Any ideas ?



Thanks for your help.

I went to support.microsoft.com (you did try this didn't you?) and did a

search for error '80020009'

and returned:



http://support.microsoft.com/support/kb/articles/Q175/2/39.ASP?LN=EN-US&SD=g

n&FR=0



which is probably the problem you are having (namely returning SQL Server

Text fields via ASP)



HTH



Cheers

Ken



----- Original Message -----

From: Jim Tait 

To: ASP Databases <asp_databases@p...>

Sent: Tuesday, April 18, 2000 12:00 PM

Subject: [asp_databases] ASP - Handling of SQL text type





> Can ASP handle the SQL text datatype ?

>

> When I try to use it in my ASP page it returns the following error ...

>

> error '80020009'

> Exception occurred.

>

> Any ideas ?

>

> Thanks for your help.

>

> ---

Hi Jim

I have worked on the problem from the 18 april.



As a solution I've used the following SQL statement :



strSQL = " Select CallLog.*, CallDesc as sCallDesc,CloseDesc as

sCloseDesc" & _

	",RecvdBy,RecvdDate,RecvdTime,ModBy,ModDate,ModTime" & _

	" from CallLog where CallID = '50'"





Set rsCallLog = dbConnection.Execute(strSQL)



The fields CallDesc , CloseDesc are Text datatypes.

But this statement has presented new problems. It does not return all the 

values for the particular record.



Regards

Ray-yaan



>From: "Jim Tait" 

>Reply-To: "ASP Databases" <asp_databases@p...>

>To: "ASP Databases" <asp_databases@p...>

>Subject: [asp_databases] ASP - Handling of SQL text type

>Date: Tue, 18 Apr 2000 12:7:47

>

>Can ASP handle the SQL text datatype ?

>

>When I try to use it in my ASP page it returns the following error ...

>

>	error '80020009'

>	Exception occurred.

>

>Any ideas ?

>

>Thanks for your help.