Hello,
I'm not sure if it's the setup I did wrong, but I can't seem to get mytext datatype in my database to store more than 900 characters. I'm trying to setup a news database for my website, which will populatethe information into a datagrid. To test, I manually added a newsitem in the database through the visual studio 2003 gui. Iimmediately noticed a problem as the I was getting an error after along news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is"text" filled with simple text in the column. As a further test,Isimply entered 12334567890123... up to 900 characters and stillrecevied the error.
I would appreciate someone leading me in the right direction on this one.
Thanks a lot.
I think may be your create table statement was not executed correctly because text can grow it is not table space based SQL Server creates an Arithmetic pointer to the file. Try the link below see if you can download the eval edition of the SQL Server. Or you could drop the table and recreate it and test again. Hope this helps.
http://www.microsoft.com/sql/evaluation/trial/default.mspx
Showing posts with label store. Show all posts
Showing posts with label store. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
msde sp4
Why can't I execute sp_attach/sp_detach in MSDE? It said it didn't have
those 2 store procedures.
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 8:33pm up 4:06 0 users 1.06 0.75Hi
Maybe because you are using the wrong names?
Try
execute master.dbo.sp_attach_db
execute master.dbo.sp_detach_db
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"man-wai chang" <toylet.toylet@.gmail.com> wrote in message
news:e0SpEyMoFHA.2580@.TK2MSFTNGP09.phx.gbl...
> Why can't I execute sp_attach/sp_detach in MSDE? It said it didn't have
> those 2 store procedures.
> --
> .~. Might, Courage, Vision. http://www.linux-sxs.org
> / v \
> /( _ )\ Linux 2.4.31
> ^ ^ 8:33pm up 4:06 0 users 1.06 0.75|||man-wai chang wrote:
> Why can't I execute sp_attach/sp_detach in MSDE? It said it didn't have
> those 2 store procedures.
>
sorry... I forgot. It should be sp_attach_db..
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 8:43pm up 4:16 0 users 0.63 0.63|||
> Maybe because you are using the wrong names?
> Try
> execute master.dbo.sp_attach_db
> execute master.dbo.sp_detach_db
yes.. sorry. :)
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 8:49pm up 4:22 0 users 0.52 0.58
those 2 store procedures.
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 8:33pm up 4:06 0 users 1.06 0.75Hi
Maybe because you are using the wrong names?
Try
execute master.dbo.sp_attach_db
execute master.dbo.sp_detach_db
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"man-wai chang" <toylet.toylet@.gmail.com> wrote in message
news:e0SpEyMoFHA.2580@.TK2MSFTNGP09.phx.gbl...
> Why can't I execute sp_attach/sp_detach in MSDE? It said it didn't have
> those 2 store procedures.
> --
> .~. Might, Courage, Vision. http://www.linux-sxs.org
> / v \
> /( _ )\ Linux 2.4.31
> ^ ^ 8:33pm up 4:06 0 users 1.06 0.75|||man-wai chang wrote:
> Why can't I execute sp_attach/sp_detach in MSDE? It said it didn't have
> those 2 store procedures.
>
sorry... I forgot. It should be sp_attach_db..
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 8:43pm up 4:16 0 users 0.63 0.63|||
> Maybe because you are using the wrong names?
> Try
> execute master.dbo.sp_attach_db
> execute master.dbo.sp_detach_db
yes.. sorry. :)
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 8:49pm up 4:22 0 users 0.52 0.58
Monday, March 26, 2012
MSDE replacing Access2000 in VB Application
I support a Visual Basic application, about 150,000 lines. It's basic
functionality is to pull data from an Oracle database and store it in arrays,
then perform about 6 dozen different kinds of analysis on the data, as the
user chooses.
Access 2000 is used in two fashions, both behind the scenes and static. (1)
The data from Oracle is temporarily stored in one MDB for cross-tabbing and
reorganization into the VB arrays. (2) Certain reference databases are
populated in other MDB files in order to support off-line analysis. Also,
user-defined associations are stored in a separate MDB.
So here are the questions: would I benefit from the use of MSDE? If not, why
not (to explain to boss and customer). If yes, how, and with what kind of
effort?
Thanks!
If you're making heavy use of cross-tab queries, that's probably
reason enough right there to stick with Access mdb's. It's much harder
to do in SQL Server, and you'd need to rewrite that entire piece of
your application. It doesn't appear that there are really any
advantages to using MSDE in your case since you also require
heterogeneous queries to Oracle, which is also much easier from
Access. It works differently in SQL Server, and you'd need to rewrite
a lot of your data access functionality as well. I can't really think
of any benefit to migrating this particular app to MSDE unless you're
getting paid by the hour :-)
-- Mary
On Tue, 14 Sep 2004 10:03:03 -0700, Rick Coen
<rick.coen@.eds.com.nospam> wrote:
>I support a Visual Basic application, about 150,000 lines. It's basic
>functionality is to pull data from an Oracle database and store it in arrays,
>then perform about 6 dozen different kinds of analysis on the data, as the
>user chooses.
>Access 2000 is used in two fashions, both behind the scenes and static. (1)
>The data from Oracle is temporarily stored in one MDB for cross-tabbing and
>reorganization into the VB arrays. (2) Certain reference databases are
>populated in other MDB files in order to support off-line analysis. Also,
>user-defined associations are stored in a separate MDB.
>So here are the questions: would I benefit from the use of MSDE? If not, why
>not (to explain to boss and customer). If yes, how, and with what kind of
>effort?
>Thanks!
|||I agree with Mary but wanted to point out that the next version of MSDE (Sql
server 2005 express) is supposed to support the cross tab queries (PIVOT I
think)
"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
news:g4fek0lnib00ce9nimo5urm9jb2vssgn5n@.4ax.com... [vbcol=seagreen]
> If you're making heavy use of cross-tab queries, that's probably
> reason enough right there to stick with Access mdb's. It's much harder
> to do in SQL Server, and you'd need to rewrite that entire piece of
> your application. It doesn't appear that there are really any
> advantages to using MSDE in your case since you also require
> heterogeneous queries to Oracle, which is also much easier from
> Access. It works differently in SQL Server, and you'd need to rewrite
> a lot of your data access functionality as well. I can't really think
> of any benefit to migrating this particular app to MSDE unless you're
> getting paid by the hour :-)
> -- Mary
> On Tue, 14 Sep 2004 10:03:03 -0700, Rick Coen
> <rick.coen@.eds.com.nospam> wrote:
arrays,[vbcol=seagreen]
the[vbcol=seagreen]
(1)[vbcol=seagreen]
and[vbcol=seagreen]
Also,[vbcol=seagreen]
why[vbcol=seagreen]
of
>
functionality is to pull data from an Oracle database and store it in arrays,
then perform about 6 dozen different kinds of analysis on the data, as the
user chooses.
Access 2000 is used in two fashions, both behind the scenes and static. (1)
The data from Oracle is temporarily stored in one MDB for cross-tabbing and
reorganization into the VB arrays. (2) Certain reference databases are
populated in other MDB files in order to support off-line analysis. Also,
user-defined associations are stored in a separate MDB.
So here are the questions: would I benefit from the use of MSDE? If not, why
not (to explain to boss and customer). If yes, how, and with what kind of
effort?
Thanks!
If you're making heavy use of cross-tab queries, that's probably
reason enough right there to stick with Access mdb's. It's much harder
to do in SQL Server, and you'd need to rewrite that entire piece of
your application. It doesn't appear that there are really any
advantages to using MSDE in your case since you also require
heterogeneous queries to Oracle, which is also much easier from
Access. It works differently in SQL Server, and you'd need to rewrite
a lot of your data access functionality as well. I can't really think
of any benefit to migrating this particular app to MSDE unless you're
getting paid by the hour :-)
-- Mary
On Tue, 14 Sep 2004 10:03:03 -0700, Rick Coen
<rick.coen@.eds.com.nospam> wrote:
>I support a Visual Basic application, about 150,000 lines. It's basic
>functionality is to pull data from an Oracle database and store it in arrays,
>then perform about 6 dozen different kinds of analysis on the data, as the
>user chooses.
>Access 2000 is used in two fashions, both behind the scenes and static. (1)
>The data from Oracle is temporarily stored in one MDB for cross-tabbing and
>reorganization into the VB arrays. (2) Certain reference databases are
>populated in other MDB files in order to support off-line analysis. Also,
>user-defined associations are stored in a separate MDB.
>So here are the questions: would I benefit from the use of MSDE? If not, why
>not (to explain to boss and customer). If yes, how, and with what kind of
>effort?
>Thanks!
|||I agree with Mary but wanted to point out that the next version of MSDE (Sql
server 2005 express) is supposed to support the cross tab queries (PIVOT I
think)
"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
news:g4fek0lnib00ce9nimo5urm9jb2vssgn5n@.4ax.com... [vbcol=seagreen]
> If you're making heavy use of cross-tab queries, that's probably
> reason enough right there to stick with Access mdb's. It's much harder
> to do in SQL Server, and you'd need to rewrite that entire piece of
> your application. It doesn't appear that there are really any
> advantages to using MSDE in your case since you also require
> heterogeneous queries to Oracle, which is also much easier from
> Access. It works differently in SQL Server, and you'd need to rewrite
> a lot of your data access functionality as well. I can't really think
> of any benefit to migrating this particular app to MSDE unless you're
> getting paid by the hour :-)
> -- Mary
> On Tue, 14 Sep 2004 10:03:03 -0700, Rick Coen
> <rick.coen@.eds.com.nospam> wrote:
arrays,[vbcol=seagreen]
the[vbcol=seagreen]
(1)[vbcol=seagreen]
and[vbcol=seagreen]
Also,[vbcol=seagreen]
why[vbcol=seagreen]
of
>
Subscribe to:
Posts (Atom)