problem displaying MEMO field from ACCESS 2000 on WINDOWS 20003

[euang]

Hi,

I have been using access 2000 for two years on WINDOWS NT to display dynamic
aweb page using ASP

My ISP has now changed to Windows 2003, and I am having major problems
displaying information from MEMO fields within the Access 2000 database. I
have not had any problems before displaying MEMO fields on NT and have tried
various tips to resolve this issue but no luck so far. I was wondering if
anyone had come accross a similar problem.

I have tried the following so far:

Specifying which columns to use in the SELECT statetment, and not using
SELECT *
Adding the memo field I want to display to the last column in the select
list
Adding the value to a variable before displaying it.

I have also tried using the getChunk method, but cannot get this to work,
the following error appears:

'Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done. '

I think it is something to do with the Windows 2003 server set up but am at
a loss as to what it is. I do not have access toit. I have informed my ISP
and they are also looking into this issue. I've got ten websites to migrate
in ten days, all of which use the MEMO field to display information, so I am
getting a little bit worried :-(

Please can anyone help me?

Thank you in advance for any time you can spare me on this problem. I have
been working on this for three days now and feel I have come up against a
brick wall. I can supply test links if needed?

Euan Green

[Foo Man Chew]

Argh, Mr. Barrows is absolutely right. This is utterly annoying.




"euang" <euan@digitalface.co.uk> wrote in message
news:OKEXx1psDHA.980@TK2MSFTNGP10.phx.gbl...

> Hi,
>
> I have been using access 2000 for two years on WINDOWS NT to display

dynamic

> aweb page using ASP
>
> My ISP has now changed to Windows 2003, and I am having major problems
> displaying information from MEMO fields within the Access 2000 database.

I

> have not had any problems before displaying MEMO fields on NT and have

tried

> various tips to resolve this issue but no luck so far. I was wondering if
> anyone had come accross a similar problem.
>
> I have tried the following so far:
>
> Specifying which columns to use in the SELECT statetment, and not using
> SELECT *
> Adding the memo field I want to display to the last column in the select
> list
> Adding the value to a variable before displaying it.
>
> I have also tried using the getChunk method, but cannot get this to work,
> the following error appears:
>
> 'Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
>
> Multiple-step OLE DB operation generated errors. Check each OLE DB status
> value, if available. No work was done. '
>
> I think it is something to do with the Windows 2003 server set up but am

at

> a loss as to what it is. I do not have access toit. I have informed my

ISP

> and they are also looking into this issue. I've got ten websites to

migrate

> in ten days, all of which use the MEMO field to display information, so I

am

> getting a little bit worried :-(
>
> Please can anyone help me?
>
> Thank you in advance for any time you can spare me on this problem. I have
> been working on this for three days now and feel I have come up against a
> brick wall. I can supply test links if needed?
>
> Euan Green
>
>

[Ray at]

STOP MULTIPOSTING PLEASE.

Ray at work

[euang]

My apologies,

The only reason I multi posted is because I have been getting bounced from
one forum to another, starting with windows nt - 2003 server migration
forum, then from microsoft.access forums to here. I am just getting
frustrated that's all, I didn't intend to pxxx anyone off.

If anyone could find time to help me, despite my multi postings, I would
greatly appreciate it.

So what do I do with this apology? multi post it.....????

My code is attached below.

Set objRS =Server.CreateObject("ADODB.Recordset")
objRS.Open "SELECT ID,News_Article2 FROM News ",ObjConn

Response.Write(objRS.Fields("News_Article2").attri butes)

cchChunkRequested = 16
Do
sChunk = objRS.Fields("News_Article2").GetChunk(cchChunkReq uested)
' Check how much we got
cchChunkReceived = Len(sChunk)
' If we got anything,
' concatenate it to the main BLOB
If cchChunkReceived > 0 Then
sNotes = sNotes & sChunk
End If

Loop While cchChunkReceived = cchChunkRequested
'Close the recordset
objRS.Close
response.write(sNotes)

TIA

Euan


"Foo Man Chew" <foo@man.chew> wrote in message
news:#9lOEDqsDHA.3224@tk2msftngp13.phx.gbl...

> Argh, Mr. Barrows is absolutely right. This is utterly annoying.
>
>
>
>
> "euang" <euan@digitalface.co.uk> wrote in message
> news:OKEXx1psDHA.980@TK2MSFTNGP10.phx.gbl...

> > Hi,
> >
> > I have been using access 2000 for two years on WINDOWS NT to display

> dynamic

> > aweb page using ASP
> >
> > My ISP has now changed to Windows 2003, and I am having major problems
> > displaying information from MEMO fields within the Access 2000 database.

> I

> > have not had any problems before displaying MEMO fields on NT and have

> tried

> > various tips to resolve this issue but no luck so far. I was wondering

if

> > anyone had come accross a similar problem.
> >
> > I have tried the following so far:
> >
> > Specifying which columns to use in the SELECT statetment, and not using
> > SELECT *
> > Adding the memo field I want to display to the last column in the select
> > list
> > Adding the value to a variable before displaying it.
> >
> > I have also tried using the getChunk method, but cannot get this to

work,

> > the following error appears:
> >
> > 'Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
> >
> > Multiple-step OLE DB operation generated errors. Check each OLE DB

status

> > value, if available. No work was done. '
> >
> > I think it is something to do with the Windows 2003 server set up but am

> at

> > a loss as to what it is. I do not have access toit. I have informed my

> ISP

> > and they are also looking into this issue. I've got ten websites to

> migrate

> > in ten days, all of which use the MEMO field to display information, so

I

> am

> > getting a little bit worried :-(
> >
> > Please can anyone help me?
> >
> > Thank you in advance for any time you can spare me on this problem. I

have

> > been working on this for three days now and feel I have come up against

a

> > brick wall. I can supply test links if needed?
> >
> > Euan Green
> >
> >

>
>

[Bob Barrows]

euang wrote:

> My apologies,
>
> The only reason I multi posted is because I have been getting bounced
> from one forum to another, starting with windows nt - 2003 server
> migration forum, then from microsoft.access forums to here. I am
> just getting frustrated that's all, I didn't intend to pxxx anyone
> off.

I wasn't pxxx'ed off. That was my canned reply about multiposting.

>
> If anyone could find time to help me, despite my multi postings, I
> would greatly appreciate it.

I'm sorry, but our web servers are still on NT4 boxes (not much longer
though) so I've never experienced this issue.

>
> So what do I do with this apology? multi post it.....????

And there you see the problem with multiposting :-)

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
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.

[Bob Barrows]

Foo Man Chew wrote:

>> Set objRS =Server.CreateObject("ADODB.Recordset")
>> objRS.Open "SELECT ID,News_Article2 FROM News ",ObjConn

>
> Set objRS = objConn.execute("SELECT ID, ...")
>

>> Response.Write(objRS.Fields("News_Article2").attri butes)

>
> I don't understand this. I don't believe the Fields collection has an
> attributes property.

the collection itself doesn't, but the Field object does.

> Did you mean to obtain the column named
> "attributes"? What exactly are you attempting to display? You can
> return the column's value this way:
>
> Response.Write(objRS("News_Article2"))

I'm assuming the above was an attempt to figure out why your suggested code
was not working.

Please follow up in .asp.db. We don't want two conversations going on. This
is a database-related question, so that should be the group to use.



--
Microsoft MVP -- ASP/ASP.NET
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.

[euang]

Yes,

I was trying to find out what attributes the field object has,there's a
property called:

adFldLong ( a constant)

which if is set to true allows the getChunk method to be used. Iw as trying
to find out if this was set to true or not, but it seems it is a rather
wierd process of finding this out, convert the hex number (in this case it
is 230) to binary etc
[url]http://dev.live-work-relax.co.uk/test.asp[/url]

I also generated a page of the connection properties

[url]http://dev.live-work-relax.co.uk/test2.asp[/url]

I thought that the
Maximum Row Size Includes BLOB: False

might be the cause of the problem also, but am not sure.

I should be able to do this, it seems a very straightforward issue. Has
anyone else got an access2000 database running on a new windows 2003 server
and is able to display memo fields? (it is only text that is being stored in
these memo fields)

Thanks again

Euan




"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:uhrIVdqsDHA.2340@TK2MSFTNGP12.phx.gbl...

> Foo Man Chew wrote:

> >> Set objRS =Server.CreateObject("ADODB.Recordset")
> >> objRS.Open "SELECT ID,News_Article2 FROM News ",ObjConn

> >
> > Set objRS = objConn.execute("SELECT ID, ...")
> >

> >> Response.Write(objRS.Fields("News_Article2").attri butes)

> >
> > I don't understand this. I don't believe the Fields collection has an
> > attributes property.

>
> the collection itself doesn't, but the Field object does.
>

> > Did you mean to obtain the column named
> > "attributes"? What exactly are you attempting to display? You can
> > return the column's value this way:
> >
> > Response.Write(objRS("News_Article2"))

>
> I'm assuming the above was an attempt to figure out why your suggested

code

> was not working.
>
> Please follow up in .asp.db. We don't want two conversations going on.

This

> is a database-related question, so that should be the group to use.
>
>
>
> --
> Microsoft MVP -- ASP/ASP.NET
> 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.
>
>

[euang]

Yes,

I was trying to find out what attributes the field object has,there's a
property called:

adFldLong ( a constant)

which if is set to true allows the getChunk method to be used. Iw as trying
to find out if this was set to true or not, but it seems it is a rather
wierd process of finding this out, convert the hex number (in this case it
is 230) to binary etc
[url]http://dev.live-work-relax.co.uk/test.asp[/url]

I also generated a page of the connection properties

[url]http://dev.live-work-relax.co.uk/test2.asp[/url]

I thought that the
Maximum Row Size Includes BLOB: False

might be the cause of the problem also, but am not sure.

I should be able to do this, it seems a very straightforward issue. Has
anyone else got an access2000 database running on a new windows 2003 server
and is able to display memo fields? (it is only text that is being stored in
these memo fields)

Thanks again

Euan



"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:uhrIVdqsDHA.2340@TK2MSFTNGP12.phx.gbl...

> Foo Man Chew wrote:

> >> Set objRS =Server.CreateObject("ADODB.Recordset")
> >> objRS.Open "SELECT ID,News_Article2 FROM News ",ObjConn

> >
> > Set objRS = objConn.execute("SELECT ID, ...")
> >

> >> Response.Write(objRS.Fields("News_Article2").attri butes)

> >
> > I don't understand this. I don't believe the Fields collection has an
> > attributes property.

>
> the collection itself doesn't, but the Field object does.
>

> > Did you mean to obtain the column named
> > "attributes"? What exactly are you attempting to display? You can
> > return the column's value this way:
> >
> > Response.Write(objRS("News_Article2"))

>
> I'm assuming the above was an attempt to figure out why your suggested

code

> was not working.
>
> Please follow up in .asp.db. We don't want two conversations going on.

This

> is a database-related question, so that should be the group to use.
>
>
>
> --
> Microsoft MVP -- ASP/ASP.NET
> 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.
>
>

[Foo Man Chew]

STICK TO ONE GROUP.


"euang" <euan@digitalface.co.uk> wrote in message
news:u$t$UtqsDHA.3496@TK2MSFTNGP11.phx.gbl...

> Yes,
>
> I was trying to find out what attributes the field object has,there's a
> property called:
>
> adFldLong ( a constant)
>
> which if is set to true allows the getChunk method to be used. Iw as

trying

> to find out if this was set to true or not, but it seems it is a rather
> wierd process of finding this out, convert the hex number (in this case it
> is 230) to binary etc
> [url]http://dev.live-work-relax.co.uk/test.asp[/url]
>
> I also generated a page of the connection properties
>
> [url]http://dev.live-work-relax.co.uk/test2.asp[/url]
>
> I thought that the
> Maximum Row Size Includes BLOB: False
>
> might be the cause of the problem also, but am not sure.
>
> I should be able to do this, it seems a very straightforward issue. Has
> anyone else got an access2000 database running on a new windows 2003

server

> and is able to display memo fields? (it is only text that is being stored

in

> these memo fields)
>
> Thanks again
>
> Euan
>
>
>
>
> "Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
> news:uhrIVdqsDHA.2340@TK2MSFTNGP12.phx.gbl...

> > Foo Man Chew wrote:

> > >> Set objRS =Server.CreateObject("ADODB.Recordset")
> > >> objRS.Open "SELECT ID,News_Article2 FROM News ",ObjConn
> > >
> > > Set objRS = objConn.execute("SELECT ID, ...")
> > >
> > >> Response.Write(objRS.Fields("News_Article2").attri butes)
> > >
> > > I don't understand this. I don't believe the Fields collection has an
> > > attributes property.

> >
> > the collection itself doesn't, but the Field object does.
> >

> > > Did you mean to obtain the column named
> > > "attributes"? What exactly are you attempting to display? You can
> > > return the column's value this way:
> > >
> > > Response.Write(objRS("News_Article2"))

> >
> > I'm assuming the above was an attempt to figure out why your suggested

> code

> > was not working.
> >
> > Please follow up in .asp.db. We don't want two conversations going on.

> This

> > is a database-related question, so that should be the group to use.
> >
> >
> >
> > --
> > Microsoft MVP -- ASP/ASP.NET
> > 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.
> >
> >

>
>

[euang]

Yes, I am just posting to this group now.

Euan


"Foo Man Chew" <foo@man.chew> wrote in message
news:usLH0KssDHA.2508@TK2MSFTNGP12.phx.gbl...

> STICK TO ONE GROUP.
>
>
> "euang" <euan@digitalface.co.uk> wrote in message
> news:u$t$UtqsDHA.3496@TK2MSFTNGP11.phx.gbl...

> > Yes,
> >
> > I was trying to find out what attributes the field object has,there's a
> > property called:
> >
> > adFldLong ( a constant)
> >
> > which if is set to true allows the getChunk method to be used. Iw as

> trying

> > to find out if this was set to true or not, but it seems it is a rather
> > wierd process of finding this out, convert the hex number (in this case

it

> > is 230) to binary etc
> > [url]http://dev.live-work-relax.co.uk/test.asp[/url]
> >
> > I also generated a page of the connection properties
> >
> > [url]http://dev.live-work-relax.co.uk/test2.asp[/url]
> >
> > I thought that the
> > Maximum Row Size Includes BLOB: False
> >
> > might be the cause of the problem also, but am not sure.
> >
> > I should be able to do this, it seems a very straightforward issue. Has
> > anyone else got an access2000 database running on a new windows 2003

> server

> > and is able to display memo fields? (it is only text that is being

stored

> in

> > these memo fields)
> >
> > Thanks again
> >
> > Euan
> >
> >
> >
> >
> > "Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
> > news:uhrIVdqsDHA.2340@TK2MSFTNGP12.phx.gbl...

> > > Foo Man Chew wrote:
> > > >> Set objRS =Server.CreateObject("ADODB.Recordset")
> > > >> objRS.Open "SELECT ID,News_Article2 FROM News ",ObjConn
> > > >
> > > > Set objRS = objConn.execute("SELECT ID, ...")
> > > >
> > > >> Response.Write(objRS.Fields("News_Article2").attri butes)
> > > >
> > > > I don't understand this. I don't believe the Fields collection has

an

> > > > attributes property.
> > >
> > > the collection itself doesn't, but the Field object does.
> > >
> > > > Did you mean to obtain the column named
> > > > "attributes"? What exactly are you attempting to display? You can
> > > > return the column's value this way:
> > > >
> > > > Response.Write(objRS("News_Article2"))
> > >
> > > I'm assuming the above was an attempt to figure out why your suggested

> > code

> > > was not working.
> > >
> > > Please follow up in .asp.db. We don't want two conversations going on.

> > This

> > > is a database-related question, so that should be the group to use.
> > >
> > >
> > >
> > > --
> > > Microsoft MVP -- ASP/ASP.NET
> > > 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.
> > >
> > >

> >
> >

>
>