GetRows and ASP 2.0

[Jenise]

Hello,

Are there a lot of differences between ASP 2.0 and 3.0. My
development environment is a bit more up to date then my
production system. I am using the following array to
retrieve records from sql 2k:

InfoArray_Set1=rsRSM.GetRows(rsRSM.recordcount,1,A rray
("Geography", "SumOfDWFEst", "Region"))
For i=0 to UBound(InfoArray_Set1,2)
response.write "<tr>"
Response.write "<td><a href=""RegionDetail.asp?
Geo=" & Server.URLEncode(InfoArray_Set1(0,i)) & " "">" &
InfoArray_Set1(0,i) & "</a></td>"
Response.write "<td>" & InfoArray_Set1(1,i)
& "</td></tr>"
Next%>

The code worked fine within development, but when I posted
it to production I received the following error:
ADODB.Recordset error '800a0d5d'
Data type conversion error.


The only thing I can think of is the difference in ASP
versions. Can I use the GETROWS statement in another
way? I wasn't able to find the differences on the
microsoft website, if anyone knows where they are, that
would be great.

Jenise

[Bob Barrows]

Here is your error statement:
ADODB.Recordset error '800a0d5d'

This is an ADODB error, not an ASP/vbscript error. You are not concentrating
on the right thing when you ask if differences between ASP versions could
lead to this error.

You need to tell us which line of code generates the error.It will probably
be a line of code dealing with a recordset method or property. Why are you
keying in on the GetRows statement as being the cause? Is that the line the
error message points to?

--
HTH,
Bob Barrows - ASP MVP
Please reply to the newsgroup. The email account listed in my From header is
my spam trap, so I don't check it very often. You will get a quicker
response by posting to the newsgroup.

"Jenise" <anonymous@discussions.microsoft.com> wrote in message
news:077101c39361$2f7b5af0$a301280a@phx.gbl...

> Hello,
>
> Are there a lot of differences between ASP 2.0 and 3.0. My
> development environment is a bit more up to date then my
> production system. I am using the following array to
> retrieve records from sql 2k:
>
> InfoArray_Set1=rsRSM.GetRows(rsRSM.recordcount,1,A rray
> ("Geography", "SumOfDWFEst", "Region"))
> For i=0 to UBound(InfoArray_Set1,2)
> response.write "<tr>"
> Response.write "<td><a href=""RegionDetail.asp?
> Geo=" & Server.URLEncode(InfoArray_Set1(0,i)) & " "">" &
> InfoArray_Set1(0,i) & "</a></td>"
> Response.write "<td>" & InfoArray_Set1(1,i)
> & "</td></tr>"
> Next%>
>
> The code worked fine within development, but when I posted
> it to production I received the following error:
> ADODB.Recordset error '800a0d5d'
> Data type conversion error.
>

The GETROWS line is where I am getting the error. I was
thinking it was the code because I have made no changes to
the database. I can retrieve the records, but just not in
the array...at least by using this statement.

thanks,
Jenise

>-----Original Message-----
>Here is your error statement:
>ADODB.Recordset error '800a0d5d'
>
>This is an ADODB error, not an ASP/vbscript error. You

are not concentrating

>on the right thing when you ask if differences between

ASP versions could

>lead to this error.
>
>You need to tell us which line of code generates the

error.It will probably

>be a line of code dealing with a recordset method or

property. Why are you

>keying in on the GetRows statement as being the cause? Is

that the line the

>error message points to?
>
>--
>HTH,
>Bob Barrows - ASP MVP
>Please reply to the newsgroup. The email account listed

in my From header is

>my spam trap, so I don't check it very often. You will

get a quicker

>response by posting to the newsgroup.
>
>"Jenise" <anonymous@discussions.microsoft.com> wrote in

message

>news:077101c39361$2f7b5af0$a301280a@phx.gbl...

>> Hello,
>>
>> Are there a lot of differences between ASP 2.0 and 3.0.

My

>> development environment is a bit more up to date then my
>> production system. I am using the following array to
>> retrieve records from sql 2k:
>>
>> InfoArray_Set1=rsRSM.GetRows(rsRSM.recordcount,1,A rray
>> ("Geography", "SumOfDWFEst", "Region"))
>> For i=0 to UBound(InfoArray_Set1,2)
>> response.write "<tr>"
>> Response.write "<td><a href=""RegionDetail.asp?
>> Geo=" & Server.URLEncode(InfoArray_Set1(0,i)) & " "">" &
>> InfoArray_Set1(0,i) & "</a></td>"
>> Response.write "<td>" & InfoArray_Set1(1,i)
>> & "</td></tr>"
>> Next%>
>>
>> The code worked fine within development, but when I

posted

>> it to production I received the following error:
>> ADODB.Recordset error '800a0d5d'
>> Data type conversion error.
>>

>
>
>.
>

[Bob Barrows]

You should install the latest version of MDAC (ADO) on the server. go to
[url]www.microsoft.com/data[/url].

Bob Barrows

[email]anonymous@discussions.microsoft.com[/email] wrote:

> The GETROWS line is where I am getting the error. I was
> thinking it was the code because I have made no changes to
> the database. I can retrieve the records, but just not in
> the array...at least by using this statement.
>
> thanks,
> Jenise
>

>> -----Original Message-----
>> Here is your error statement:
>> ADODB.Recordset error '800a0d5d'
>>
>> This is an ADODB error, not an ASP/vbscript error. You are not
>> concentrating on the right thing when you ask if differences between
>> ASP versions could lead to this error.
>>
>> You need to tell us which line of code generates the error.It will
>> probably be a line of code dealing with a recordset method or
>> property. Why are you keying in on the GetRows statement as being
>> the cause? Is that the line the error message points to?
>>
>> --
>> HTH,
>> Bob Barrows - ASP MVP
>> Please reply to the newsgroup. The email account listed in my From
>> header is my spam trap, so I don't check it very often. You will get
>> a quicker response by posting to the newsgroup.
>>
>> "Jenise" <anonymous@discussions.microsoft.com> wrote in message
>> news:077101c39361$2f7b5af0$a301280a@phx.gbl...

>>> Hello,
>>>
>>> Are there a lot of differences between ASP 2.0 and 3.0. My
>>> development environment is a bit more up to date then my
>>> production system. I am using the following array to
>>> retrieve records from sql 2k:
>>>
>>> InfoArray_Set1=rsRSM.GetRows(rsRSM.recordcount,1,A rray
>>> ("Geography", "SumOfDWFEst", "Region"))
>>> For i=0 to UBound(InfoArray_Set1,2)
>>> response.write "<tr>"
>>> Response.write "<td><a href=""RegionDetail.asp?
>>> Geo=" & Server.URLEncode(InfoArray_Set1(0,i)) & " "">" &
>>> InfoArray_Set1(0,i) & "</a></td>"
>>> Response.write "<td>" & InfoArray_Set1(1,i)
>>> & "</td></tr>"
>>> Next%>
>>>
>>> The code worked fine within development, but when I posted
>>> it to production I received the following error:
>>> ADODB.Recordset error '800a0d5d'
>>> Data type conversion error.
>>>

>>
>>
>> .

[Jenise]

Actually, I just installed the latest MDAC and Microsoft
Jet, which helped in giving me access to the database, but
I can't figure out why some of my code does not work the
same way. Do you need any more information from me?

thanks,
Jenise

>-----Original Message-----
>You should install the latest version of MDAC (ADO) on

the server. go to

>[url]www.microsoft.com/data[/url].
>
>Bob Barrows
>
>anonymous@discussions.microsoft.com wrote:

>> The GETROWS line is where I am getting the error. I was
>> thinking it was the code because I have made no changes

to

>> the database. I can retrieve the records, but just not

in

>> the array...at least by using this statement.
>>
>> thanks,
>> Jenise
>>

>>> -----Original Message-----
>>> Here is your error statement:
>>> ADODB.Recordset error '800a0d5d'
>>>
>>> This is an ADODB error, not an ASP/vbscript error. You

are not

>>> concentrating on the right thing when you ask if

differences between

>>> ASP versions could lead to this error.
>>>
>>> You need to tell us which line of code generates the

error.It will

>>> probably be a line of code dealing with a recordset

method or

>>> property. Why are you keying in on the GetRows

statement as being

>>> the cause? Is that the line the error message points

to?

>>>
>>> --
>>> HTH,
>>> Bob Barrows - ASP MVP
>>> Please reply to the newsgroup. The email account

listed in my From

>>> header is my spam trap, so I don't check it very

often. You will get

>>> a quicker response by posting to the newsgroup.
>>>
>>> "Jenise" <anonymous@discussions.microsoft.com> wrote

in message

>>> news:077101c39361$2f7b5af0$a301280a@phx.gbl...
>>>> Hello,
>>>>
>>>> Are there a lot of differences between ASP 2.0 and

3.0. My

>>>> development environment is a bit more up to date then

my

>>>> production system. I am using the following array to
>>>> retrieve records from sql 2k:
>>>>
>>>> InfoArray_Set1=rsRSM.GetRows(rsRSM.recordcount,1,A rray
>>>> ("Geography", "SumOfDWFEst", "Region"))
>>>> For i=0 to UBound(InfoArray_Set1,2)
>>>> response.write "<tr>"
>>>> Response.write "<td><a href=""RegionDetail.asp?
>>>> Geo=" & Server.URLEncode(InfoArray_Set1(0,i))

& " "">" &

>>>> InfoArray_Set1(0,i) & "</a></td>"
>>>> Response.write "<td>" & InfoArray_Set1(1,i)
>>>> & "</td></tr>"
>>>> Next%>
>>>>
>>>> The code worked fine within development, but when I

posted

>>>> it to production I received the following error:
>>>> ADODB.Recordset error '800a0d5d'
>>>> Data type conversion error.
>>>>
>>>
>>>
>>> .

>
>
>
>.
>

[Bob Barrows]

Oh wait, you're passing too many arguments here:
This:
InfoArray_Set1=rsRSM.GetRows(rsRSM.recordcount,1,A rray("Geography",
"SumOfDWFEst", "Region"))
should be this:
InfoArray_Set1=rsRSM.GetRows(,,Array("Geography", "SumOfDWFEst", "Region"))

Look up GetRows in online help and read the argument descriptions a little
more closely.

--
HTH,
Bob Barrows - ASP MVP
Please reply to the newsgroup. The email account listed in my From header is
my spam trap, so I don't check it very often. You will get a quicker
response by posting to the newsgroup.

"Jenise" <anonymous@discussions.microsoft.com> wrote in message
news:0e5d01c393f2$4b6450a0$a401280a@phx.gbl...

> Actually, I just installed the latest MDAC and Microsoft
> Jet, which helped in giving me access to the database, but
> I can't figure out why some of my code does not work the
> same way. Do you need any more information from me?
>
> thanks,
> Jenise
>

> >-----Original Message-----
> >You should install the latest version of MDAC (ADO) on

> the server. go to

> >[url]www.microsoft.com/data[/url].
> >
> >Bob Barrows
> >
> >anonymous@discussions.microsoft.com wrote:

> >> The GETROWS line is where I am getting the error. I was
> >> thinking it was the code because I have made no changes

> to

> >> the database. I can retrieve the records, but just not

> in

> >> the array...at least by using this statement.
> >>
> >> thanks,
> >> Jenise
> >>
> >>> -----Original Message-----
> >>> Here is your error statement:
> >>> ADODB.Recordset error '800a0d5d'
> >>>
> >>> This is an ADODB error, not an ASP/vbscript error. You

> are not

> >>> concentrating on the right thing when you ask if

> differences between

> >>> ASP versions could lead to this error.
> >>>
> >>> You need to tell us which line of code generates the

> error.It will

> >>> probably be a line of code dealing with a recordset

> method or

> >>> property. Why are you keying in on the GetRows

> statement as being

> >>> the cause? Is that the line the error message points

> to?

> >>>
> >>> --
> >>> HTH,
> >>> Bob Barrows - ASP MVP
> >>> Please reply to the newsgroup. The email account

> listed in my From

> >>> header is my spam trap, so I don't check it very

> often. You will get

> >>> a quicker response by posting to the newsgroup.
> >>>
> >>> "Jenise" <anonymous@discussions.microsoft.com> wrote

> in message

> >>> news:077101c39361$2f7b5af0$a301280a@phx.gbl...
> >>>> Hello,
> >>>>
> >>>> Are there a lot of differences between ASP 2.0 and

> 3.0. My

> >>>> development environment is a bit more up to date then

> my

> >>>> production system. I am using the following array to
> >>>> retrieve records from sql 2k:
> >>>>
> >>>> InfoArray_Set1=rsRSM.GetRows(rsRSM.recordcount,1,A rray
> >>>> ("Geography", "SumOfDWFEst", "Region"))
> >>>> For i=0 to UBound(InfoArray_Set1,2)
> >>>> response.write "<tr>"
> >>>> Response.write "<td><a href=""RegionDetail.asp?
> >>>> Geo=" & Server.URLEncode(InfoArray_Set1(0,i))

> & " "">" &

> >>>> InfoArray_Set1(0,i) & "</a></td>"
> >>>> Response.write "<td>" & InfoArray_Set1(1,i)
> >>>> & "</td></tr>"
> >>>> Next%>
> >>>>
> >>>> The code worked fine within development, but when I

> posted

> >>>> it to production I received the following error:
> >>>> ADODB.Recordset error '800a0d5d'
> >>>> Data type conversion error.
> >>>>
> >>>
> >>>
> >>> .

> >
> >
> >
> >.
> >

Actually, I just installed the latest MDAC and Microsoft
Jet Engines(just in case), and that was what gave me
access to the database. Let me know if you need any
additional information from me...I'm really stumped on
this one.

thanks,
Jenise

>-----Original Message-----
>You should install the latest version of MDAC (ADO) on

the server. go to

>[url]www.microsoft.com/data[/url].
>
>Bob Barrows
>
>anonymous@discussions.microsoft.com wrote:

>> The GETROWS line is where I am getting the error. I was
>> thinking it was the code because I have made no changes

to

>> the database. I can retrieve the records, but just not

in

>> the array...at least by using this statement.
>>
>> thanks,
>> Jenise
>>

>>> -----Original Message-----
>>> Here is your error statement:
>>> ADODB.Recordset error '800a0d5d'
>>>
>>> This is an ADODB error, not an ASP/vbscript error. You

are not

>>> concentrating on the right thing when you ask if

differences between

>>> ASP versions could lead to this error.
>>>
>>> You need to tell us which line of code generates the

error.It will

>>> probably be a line of code dealing with a recordset

method or

>>> property. Why are you keying in on the GetRows

statement as being

>>> the cause? Is that the line the error message points

to?

>>>
>>> --
>>> HTH,
>>> Bob Barrows - ASP MVP
>>> Please reply to the newsgroup. The email account

listed in my From

>>> header is my spam trap, so I don't check it very

often. You will get

>>> a quicker response by posting to the newsgroup.
>>>
>>> "Jenise" <anonymous@discussions.microsoft.com> wrote

in message

>>> news:077101c39361$2f7b5af0$a301280a@phx.gbl...
>>>> Hello,
>>>>
>>>> Are there a lot of differences between ASP 2.0 and

3.0. My

>>>> development environment is a bit more up to date then

my

>>>> production system. I am using the following array to
>>>> retrieve records from sql 2k:
>>>>
>>>> InfoArray_Set1=rsRSM.GetRows(rsRSM.recordcount,1,A rray
>>>> ("Geography", "SumOfDWFEst", "Region"))
>>>> For i=0 to UBound(InfoArray_Set1,2)
>>>> response.write "<tr>"
>>>> Response.write "<td><a href=""RegionDetail.asp?
>>>> Geo=" & Server.URLEncode(InfoArray_Set1(0,i))

& " "">" &

>>>> InfoArray_Set1(0,i) & "</a></td>"
>>>> Response.write "<td>" & InfoArray_Set1(1,i)
>>>> & "</td></tr>"
>>>> Next%>
>>>>
>>>> The code worked fine within development, but when I

posted

>>>> it to production I received the following error:
>>>> ADODB.Recordset error '800a0d5d'
>>>> Data type conversion error.
>>>>
>>>
>>>
>>> .

>
>
>
>.
>