ADO VB ASP and lots of text

From: James (ram_at_iexpress.net.au)
Date: 06/28/04


Date: Mon, 28 Jun 2004 11:01:30 +0800

HI Guys,

I have set up a reportng feature in my software that will allow users to
conenct to my website and submit a report with one click.

In the VB app I have

Dim ors As New ADODB.Recordset
ors.Open "http://mysite.com/report.asp?RN=stuff&ER=Losts_of_text

And then i have an asp page to submit it to the database

The process works fine until the ER param has lots of text in it then it has
an error. The field size in the DB is set to memo so the amount of data
isnot a problem. I thnik it is an issue with the asp and the amount of text
sent via the querysting.

The error is 3709 Method 'Open' of object'_recordset' failed

DB is access

Is there another or better way to do the above?

Cheers

James