hello all
this is the structure of the the two tables
in which i am inserting data
CREATE TABLE [dbo].[customer_login] (
[username] [varchar] (50) NT NULL ,
[password] [text] NT NULL ,
[createddate] [datetime] NT NULL ,
[disabled] [bit] NT NULL ,
[loggedin] [bit] NT NULL ) N [PRIMARY] TEXTIMAGEN
[PRIMARY]
G
in this table i am using a text field in which i am
storing hash of the password
one more thing the system which i used to develop
the site has .NET 1.1 version and sql server 2000 but
the server on which i uploaded my site has
NET Beta 2.0 version and sql server version
08.00.0760
can this be a possible cause of problem as the same
code and table structure are giving no error in my
localhost
CREATE TABLE [dbo].[customer_detail] (
[fname] [varchar] (50) NT NULL ,
[lname] [varchar] (50) CLLATE NULL ,
[dob] [datetime] NULL ,
[sex] [char] (1) NULL ,
[address] [varchar] (100)NT NULL ,
[city] [varchar] (50) NT NULL ,
[state] [varchar] (50)NULL ,
[country] [varchar] (100)NT NULL ,
[pin] [varchar] (20) NT NULL ,
[education] [varchar](100) NULL ,
[email] [varchar] (50) NULL ,
[username] [varchar] (50)NT NULL ,
[detailid] [bigint] NT NULL
) N [PRIMARY]
G
Bob Grommes <bob (AT) bobgrommes (DOT) comwrote:
Hm this is a long shot, but based on the fact
that the message sayd
"String or binary data would be truncated", it seems
possible, even likely,
that the statement you are executing would truncate
data ;-)
What you will find is that you are trying to put
data in one or more fields
that is longer than the maximum width for that field
as defined in SQL
Server.
Message
From: "mit pandey" <mit_025 (AT) yahoo (DOT) com>
To: "csharpnet" <csharpnet (AT) yahoogroups (DOT) com>
Sent: Thursday, July 21, 2005 7:12 AM
Subject: [C#.NET] error while inserting data
what can be the possible reason of this error
--
Error Message:String or binary data would be
truncated.
The statement has been terminated.
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Yahoo! Groups Links
<*To visit your group on the web, go to:
<*To unsubscribe from this group, send an email to:
CSharpNET-unsubscribe (AT) yahoogroups (DOT) com
<*Your use of Yahoo! Groups is subject to: