Solved

Maximum character number in OleDbType.LongVarChar

Posted on 2009-05-10
3
2,316 Views
Last Modified: 2012-08-13
Hi, I'm hoping I can use the program I just wrote to add more than 200 characters in an access database. It says you can use up to 6,000 which would be more than enough. Right now I can only get about 200. I read a article that using the below code should work, but it's not working. I have the access database field set to memo.


cmd.Parameters.Add("@description", OleDbType.LongVarChar, txtDescription.Text.Length, txtDescription.Text)

Open in new window

0
Comment
Question by:designaire
  • 2
3 Comments
 

Author Comment

by:designaire
Comment Utility
I don't have any problems when I update the field in the datagrid and add more characters. It just gives me an error message when I try to add to the database.
   openAccessConnection() 

Dim cmd As New OleDbCommand("insert into tblImg(dateorder,title,times,description,img_type,img_stream) values(@dateorder,@title,@times,@description,@img_type,@img_stream)", myAccessConnection)

                cmd.CommandType = CommandType.Text

                cmd.Parameters.Add("@dateorder", OleDbType.VarChar).Value = txtDateOrder.Text

                cmd.Parameters.Add("@title", OleDbType.VarChar).Value = txtDescription.Text

                cmd.Parameters.Add("@times", OleDbType.VarChar).Value = txtTimes.Text

                cmd.Parameters.Add("@description", OleDbType.LongVarChar, 6000).Value = txtDescription.Text

                'cmd.Parameters.Add("@description", OleDbType.LongVarBinary,  txtDescription.Text
 

                cmd.ExecuteNonQuery()
 

                closeAccessConnection()

                Response.Redirect("eventsEdit.aspx")

     

Open in new window

0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 125 total points
Comment Utility
According to this MSDN article,

http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbtype.aspx

LongVarChar translates to String. String can hold unlimited number of characters (depending on available memory). What is the column size in database and what is the exact text of the error message?
0
 

Author Comment

by:designaire
Comment Utility
I found my error. I had one imput going to 2 fields. One of which was a text fiield and not a memo field.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now