|
 |
asp_databases thread: 50 character limit.
Message #1 by "Brad Libby" <libby_brad@b...> on Tue, 26 Sep 2000 18:51:28 +0100
|
|
My scripts are kicking back errors everytime i try to insert more than 50
characters into a database field. is there any way that increase this
limit from a asp script rather than call the server guys and have them do
it server side?
again at 49 characters everything goes fine and at 51 characters an error
occurs..
the error:
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.
/sell/postit.asp, line 39
Message #2 by "Jason A. Greenfeld" <jgreenfeld@r...> on Wed, 27 Sep 2000 08:34:45 -0400
|
|
Are you using a SQL database or an Access database?
If you are using SQL, you can write a SQL statement to increase the size of
the field. This might work in Access too, but I have never tried it. I
really don't suggest that method though. I would just go to the DB, Access
or SQL, and manually update it.
Here is another suggestion. If you are using SQL, and the field is VarChar,
set the size to 8000. It won't use 8000 bytes, approximately 8000
characters, it will only use the amount of bytes that are sent to it.
Jason Greenfeld
Rubicon Technologies, Inc.
http://www.rubicontechnologies.com
-----Original Message-----
From: Brad Libby [mailto:libby_brad@b...]
Sent: Tuesday, September 26, 2000 1:51 PM
To: ASP Databases
Subject: [asp_databases] 50 character limit.
My scripts are kicking back errors everytime i try to insert more than 50
characters into a database field. is there any way that increase this
limit from a asp script rather than call the server guys and have them do
it server side?
again at 49 characters everything goes fine and at 51 characters an error
occurs..
the error:
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.
/sell/postit.asp, line 39
Message #3 by "Michael Goldman" <mg188@h...> on Wed, 27 Sep 2000 07:00:35 -0700
|
|
could it be the setting in your database for number of characters?
best of luck
----- Original Message -----
From: "Brad Libby" <libby_brad@b...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, September 26, 2000 10:51 AM
Subject: [asp_databases] 50 character limit.
> My scripts are kicking back errors everytime i try to insert more than 50
> characters into a database field. is there any way that increase this
> limit from a asp script rather than call the server guys and have them do
> it server side?
>
> again at 49 characters everything goes fine and at 51 characters an error
> occurs..
>
> the error:
> 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.
>
> /sell/postit.asp, line 39
>
>
Message #4 by "David E" <registerukh@h...> on Wed, 27 Sep 2000 12:43:57 EDT
|
|
Brad,
I think we can alter the columns in a table thru ASP/SQL.
The following command changes the <field_name> field of the <table_name>
table to hold 100 characters:
ALTER TABLE <table_name> MODIFY <field_name> CHAR(100)
Hope this helps.
>From: "Brad Libby" <libby_brad@b...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] 50 character limit.
>Date: Tue, 26 Sep 2000 18:51:28 +0100
>
>My scripts are kicking back errors everytime i try to insert more than 50
>characters into a database field. is there any way that increase this
>limit from a asp script rather than call the server guys and have them do
>it server side?
>
>again at 49 characters everything goes fine and at 51 characters an error
>occurs..
>
>the error:
>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.
>
>/sell/postit.asp, line 39
>
>
Message #5 by "Nemesys70 Nemesys70" <nemesys70@h...> on Wed, 27 Sep 2000 19:33:46 GMT
|
|
I've seen this ole db type of error when i was using Access 2000 and ADO
2.5. I had to upgrade to Jet 4.0 service pack 4. Your problem may be
related. hope it helps.
Neil
>From: "Michael Goldman" <mg188@h...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] Re: 50 character limit.
>Date: Wed, 27 Sep 2000 07:00:35 -0700
>
>could it be the setting in your database for number of characters?
>
>best of luck
>
>
>----- Original Message -----
>From: "Brad Libby" <libby_brad@b...>
>To: "ASP Databases" <asp_databases@p...>
>Sent: Tuesday, September 26, 2000 10:51 AM
>Subject: [asp_databases] 50 character limit.
>
>
> > My scripts are kicking back errors everytime i try to insert more than
>50
> > characters into a database field. is there any way that increase this
> > limit from a asp script rather than call the server guys and have them
>do
> > it server side?
> >
> > again at 49 characters everything goes fine and at 51 characters an
>error
> > occurs..
> >
> > the error:
> > 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.
> >
> > /sell/postit.asp, line 39
> >
> >
>
Message #6 by "Matthew Lohr" <mlohr@t...> on Wed, 27 Sep 2000 15:13:42 -0400
|
|
Access databases by default have a 50 char limit but it can be increased to
255. Anything beyond this you need a better database.
-----Original Message-----
From: Michael Goldman [mailto:mg188@h...]
Sent: Wednesday, September 27, 2000 10:01 AM
To: ASP Databases
Subject: [asp_databases] Re: 50 character limit.
could it be the setting in your database for number of characters?
best of luck
----- Original Message -----
From: "Brad Libby" <libby_brad@b...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, September 26, 2000 10:51 AM
Subject: [asp_databases] 50 character limit.
> My scripts are kicking back errors everytime i try to insert more than 50
> characters into a database field. is there any way that increase this
> limit from a asp script rather than call the server guys and have them do
> it server side?
>
> again at 49 characters everything goes fine and at 51 characters an error
> occurs..
>
> the error:
> 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.
>
> /sell/postit.asp, line 39
>
>
Message #7 by "Ken Schaefer" <ken@a...> on Thu, 28 Sep 2000 12:04:23 +1000
|
|
If you're using SQL Server, just execute a T-SQL statement.
If you're using Access, look up ALTER TABLE in your online help (however
it's probably just easier to download the database, alter it locally and
upload again)
Cheers
Ken
----- Original Message -----
From: "Brad Libby" <libby_brad@b...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, September 27, 2000 3:51 AM
Subject: [asp_databases] 50 character limit.
> My scripts are kicking back errors everytime i try to insert more than 50
> characters into a database field. is there any way that increase this
> limit from a asp script rather than call the server guys and have them do
> it server side?
>
> again at 49 characters everything goes fine and at 51 characters an error
> occurs..
>
> the error:
> 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.
>
> /sell/postit.asp, line 39
>
Message #8 by Toby Anscombe <tanscombe@m...> on Thu, 28 Sep 2000 10:44:43 +0100
|
|
Silly question but it's not a char(50) or varchar(50) field ?
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: 28 September 2000 03:04
To: ASP Databases
Subject: [asp_databases] Re: 50 character limit.
If you're using SQL Server, just execute a T-SQL statement.
If you're using Access, look up ALTER TABLE in your online help (however
it's probably just easier to download the database, alter it locally and
upload again)
Cheers
Ken
----- Original Message -----
From: "Brad Libby" <libby_brad@b...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, September 27, 2000 3:51 AM
Subject: [asp_databases] 50 character limit.
> My scripts are kicking back errors everytime i try to insert more than 50
> characters into a database field. is there any way that increase this
> limit from a asp script rather than call the server guys and have them do
> it server side?
>
> again at 49 characters everything goes fine and at 51 characters an error
> occurs..
>
> the error:
> 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.
>
> /sell/postit.asp, line 39
>
|
|
|
View Cart
