473,847 Members | 1,457 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 5803
Show your code...

"euang" <eu**@digitalfa ce.co.uk> wrote in message
news:eF******** ******@tk2msftn gp13.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.acces s 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.CreateO bject("ADODB.Re cordset")
objRS.Open "SELECT ID,News_Article 2 FROM News ",ObjConn

Response.Write( objRS.Fields("N ews_Article2"). attributes)

cchChunkRequest ed = 16
Do
sChunk = objRS.Fields("N ews_Article2"). GetChunk(cchChu nkRequested)
' Check how much we got
cchChunkReceive d = Len(sChunk)
' If we got anything,
' concatenate it to the main BLOB
If cchChunkReceive d > 0 Then
sNotes = sNotes & sChunk
End If

Loop While cchChunkReceive d = cchChunkRequest ed
'Close the recordset
objRS.Close
response.write( sNotes)

TIA

Euan


"Bob Barrows" <re******@NOyah oo.SPAMcom> wrote in message
news:Oj******** ******@TK2MSFTN GP09.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.CreateO bject("ADODB.Re cordset")
objRS.Open "SELECT ID,News_Article 2 FROM News ",ObjConn
Set objRS = objConn.execute ("SELECT ID, ...")
Response.Write( objRS.Fields("N ews_Article2"). attributes)


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_Art icle2"))
Jul 19 '05 #5
Foo Man Chew wrote:
Set objRS =Server.CreateO bject("ADODB.Re cordset")
objRS.Open "SELECT ID,News_Article 2 FROM News ",ObjConn
Set objRS = objConn.execute ("SELECT ID, ...")
Response.Write( objRS.Fields("N ews_Article2"). attributes)


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_Art icle2"))


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******@NOyah oo.SPAMcom> wrote in message
news:uh******** ******@TK2MSFTN GP12.phx.gbl...
Foo Man Chew wrote:
Set objRS =Server.CreateO bject("ADODB.Re cordset")
objRS.Open "SELECT ID,News_Article 2 FROM News ",ObjConn
Set objRS = objConn.execute ("SELECT ID, ...")
Response.Write( objRS.Fields("N ews_Article2"). attributes)


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_Art icle2"))


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******@NOyah oo.SPAMcom> wrote in message
news:uh******** ******@TK2MSFTN GP12.phx.gbl...
Foo Man Chew wrote:
Set objRS =Server.CreateO bject("ADODB.Re cordset")
objRS.Open "SELECT ID,News_Article 2 FROM News ",ObjConn
Set objRS = objConn.execute ("SELECT ID, ...")
Response.Write( objRS.Fields("N ews_Article2"). attributes)


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_Art icle2"))


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**@digitalfa ce.co.uk> wrote in message
news:u$******** ******@TK2MSFTN GP11.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******@NOyah oo.SPAMcom> wrote in message
news:uh******** ******@TK2MSFTN GP12.phx.gbl...
Foo Man Chew wrote:
> Set objRS =Server.CreateO bject("ADODB.Re cordset")
> objRS.Open "SELECT ID,News_Article 2 FROM News ",ObjConn

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

> Response.Write( objRS.Fields("N ews_Article2"). attributes)

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_Art icle2"))


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
8701
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 field in plain text. That's because I truncate the string text but if, when I truncate it there's a rich tag the code following the truncated string is corrupted. Don't know if it's clear enough.
4
5811
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 the following code to test this : - <% set objconn = server.createobject ("ADODB.connection") set objrec = server.createobject ("ADODB.recordset") objconn.open "DSN=daters"
6
10484
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 field, and it works. But, it seems wrong since I had to create a huge text box to accommodate memo fields with a lot of text. Thanks for any help, ShyGuy
1
3142
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, but it does not bring in all of my memo field - it cuts off the data. I have other queries setup to do the same thing from different tables and they work fine. I cannot see anything different in my tables or queries. Anyone have any ideas of...
4
5409
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 memo field When CAN GROW is set to NO everything works just fine. When CAN GROW is set to YES - watch out.... One record causes BIG
4
2179
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) & Chr$(10) & Me! & Chr$(13) & Chr$(10) & Me! Me! = Me! & Chr$(13) & Chr$(10) & Me! & Chr$(13) & Chr$(10) & Me! DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
0
317
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 memo field which stores the actual feedback. To display the data, I created a form, with a subform containing the feedbacks, I displayed the feedback using datagrid. This is of course not ideal, The memo field content are displayed in a single...
3
3049
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 padded with a bunch of null characters at the end.
0
1552
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 using Access 2000, it lacks the ability to do this natively, so I was wondering if anyone had a solution. I've made use of one of the controls of Lebans.com (TextWidthHeight one, rather spiffy), but it seems the RTF display controls there are for...
0
9892
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10991
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10653
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10347
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9490
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7061
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5725
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
4129
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3168
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.