MSDE Text datatype - unable to store more than 900 characters. (msde + visual studio 2003)

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

MSDE installation for .Text blogging

Hi All
A little help for MSDE please. I have tried and tried but
no luck ;-(
I followed the steps on the Installation page and
installed .Text and MSDE.
To install MSDE i used the instructions
Setup SAPWD=Test123 SecurityMode=SQL
My first question is
In the connection string, whats the username for the MSDE.
I tried looking for a default login but couldn't find one.
If i use my domain login, it doesn't work.
When i load the default page i get
"Sql Server does not exist or access denied"
I know Sql Server Exists and i can use the MSDE Query
tool. If i use NT Auth i can log in. Please advise for the
connection string.
<DbProvider type
= "Dottext.Framework.Data.SqlDataProvider,
Dottext.Framework"
connectionString = "Password=test1234;Persist
Security Info=True;User ID=admin;Initial
Catalog=blogDb;Data Source=localhost" />
Do i need to grant users for access. how do i do that.
I havent used databases in about 10 yers. a little rusty.
Raj
hi Raj,
"Raj" <raj.sinha@.gmail.com> ha scritto nel messaggio
news:996601c49747$c0098ca0$a601280a@.phx.gbl...
> Hi All
> A little help for MSDE please. I have tried and tried but
> no luck ;-(
> I followed the steps on the Installation page and
> installed .Text and MSDE.
> To install MSDE i used the instructions
> Setup SAPWD=Test123 SecurityMode=SQL
> My first question is
> In the connection string, whats the username for the MSDE.
> I tried looking for a default login but couldn't find one.
> If i use my domain login, it doesn't work.
> When i load the default page i get
> "Sql Server does not exist or access denied"
> I know Sql Server Exists and i can use the MSDE Query
> tool. If i use NT Auth i can log in. Please advise for the
> connection string.
> <DbProvider type
> = "Dottext.Framework.Data.SqlDataProvider,
> Dottext.Framework"
> connectionString = "Password=test1234;Persist
> Security Info=True;User ID=admin;Initial
> Catalog=blogDb;Data Source=localhost" />
> Do i need to grant users for access. how do i do that.
> I havent used databases in about 10 yers. a little rusty.
> Raj
>
for potential causes of access denied, please have a look at
http://support.microsoft.com/default...06&Product=sql
please verify MSDE accepts SQL Server connections too, and that the
credentials you are passing have been granted logins rights...
the "admin" SQL Server user must of course exists in SQL Server logins
collection, and so all other logins, both WindowsNT and SQL Server...
you can do that via oSql.exe, the command prompt management tool provided
with MSDE, more info at
http://support.microsoft.com/default...EN-US;q325003, but for
your convenience, you can have a look at further management tools, both free
and/or commercials, at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply