473,382 Members | 1,786 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

problem displaying MEMO field from ACCESS 2000 on WINDOWS 20003

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

Jul 19 '05 #1
8 5758
Show your code...

"euang" <eu**@digitalface.co.uk> wrote in message
news:eF**************@tk2msftngp13.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


Jul 19 '05 #2
Please do not multipost Euan. This is definitely a database-related question
so .asp.db was the perfect group in which to post it. Posting it here as
well did not increase your chances of getting an answer (most of us
subscribe to both groups). On the contrary, if somebody had taken his time
to answer it here, only to find that it was already resolved in the other
group, that person may have been annoyed enough to ignore any future posts
from you, thereby decreasing your chances of getting help in the future.

There are times when you will not be sure which group is most appropriate,
and you will want to post a question to both groups. In that situation, you
should use the cross-posting technique, rather than posting the same message
multiple times. To crosspost, put a semicolon-delimited* list of the
newsgroups to which you wish to post in the To: header of your post and post
it once. It, and any replies to it, will appear in all the newsgroups in
your list. So, if I reply in .asp.db, my reply will also appear here in
..asp.general.

* ... or whatever delimiter is recognized by your news client

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.
Jul 19 '05 #3
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


"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:Oj**************@TK2MSFTNGP09.phx.gbl...
Please do not multipost Euan. This is definitely a database-related question so .asp.db was the perfect group in which to post it. Posting it here as
well did not increase your chances of getting an answer (most of us
subscribe to both groups). On the contrary, if somebody had taken his time
to answer it here, only to find that it was already resolved in the other
group, that person may have been annoyed enough to ignore any future posts
from you, thereby decreasing your chances of getting help in the future.

There are times when you will not be sure which group is most appropriate,
and you will want to post a question to both groups. In that situation, you should use the cross-posting technique, rather than posting the same message multiple times. To crosspost, put a semicolon-delimited* list of the
newsgroups to which you wish to post in the To: header of your post and post it once. It, and any replies to it, will appear in all the newsgroups in
your list. So, if I reply in .asp.db, my reply will also appear here in
.asp.general.

* ... or whatever delimiter is recognized by your news client

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.

Jul 19 '05 #4
> 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. 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"))
Jul 19 '05 #5
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.
Jul 19 '05 #6
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
http://dev.live-work-relax.co.uk/test.asp

I also generated a page of the connection properties

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

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" <re******@NOyahoo.SPAMcom> wrote in message
news:uh**************@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.

Jul 19 '05 #7
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
http://dev.live-work-relax.co.uk/test.asp

I also generated a page of the connection properties

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

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" <re******@NOyahoo.SPAMcom> wrote in message
news:uh**************@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.

Jul 19 '05 #8
STICK TO ONE GROUP.
"euang" <eu**@digitalface.co.uk> wrote in message
news:u$**************@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
http://dev.live-work-relax.co.uk/test.asp

I also generated a page of the connection properties

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

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" <re******@NOyahoo.SPAMcom> wrote in message
news:uh**************@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.


Jul 19 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Alfredo Agosti | last post by:
Hi folks, I have an Access 2000 db with a memo field. Into the memo field I put text with bold attributes, URL etc etc What I need to to is converting the rich text contained into the memo...
4
by: Hugh Welford | last post by:
Hi ... using WIN XP/ FP 2000/ IIS. I need to be able to retieve variable length (>255 characters) messages which have been saved in a memo field in an access data base on the server. I am using...
6
by: Shyguy | last post by:
I want to create two buttons on a form. One would allow the user to Copy the contents of the current records memo field, the other would allow them to print. I set up a report based on the memo...
1
by: Rose | last post by:
I have an access 2000 database. In it I have a table OPEN Items which has a field Issue that is setup as a MEMO field. I am trying to append information from another table with the same setup,...
4
by: Mal | last post by:
I have an ACC 2000 database that has a strange behaviour I have a small table, with just a few fields... My report has very simple grouping and sorting, no code bar a NODATA event. I have a...
4
by: ghadley_00 | last post by:
I have an access database form where I have a button that is supposed to be appending the contents of 1 memo field to another is behaving non-predictably. The code is: Me! = Me! & Chr$(13) &...
0
by: Fendi Baba | last post by:
I am designing a simple application which has school records in one table. In a related table, I store school's comments, which essentially are feedback gathered about the school. This table has a...
3
by: Joe Salmeri | last post by:
I have found a data corruption problem with pyodbc. OS = Windows XP SP2 DB = Microsoft Access XP PROBLEM: When selecting columns from a table that are of type Memo the value returned is...
0
by: Kumba | last post by:
Hi all, Working on a pretty fancy access report that prints out a schedule of events in a two-column format, I've stumbled across the need for displaying formatted text into a field. Since I'm...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.