I am trying to send a string from a input text field in my visual basic 2005 program to a SQL Server Express database I have set up...
Heres the problem:
The program links to the database just fine, and sends the inputs from the text fields without error, BUT when I send a string more than 10 characters the program truncates the remaining characters. In my database on SQL Server, I set the field's Data Type to 'ntext'.... and I can add long strings when accessing the database and adding data through SQL Server Express Management Studio, but I want to send a string from my Visual Basic program from the input text field to the database untruncated.
Is there a way to stop this truncating because I want my program to save user comments in my database along with the data it stores already.
PLEASE HELP!
Thankyou