Saving Error

[gsgurdeep]

When I insert rtf data from rich text box in sql table containing 3 char(255) type columns + char(6000) columns it returns access violation error.

what it mean
&
waht is the solution

Please Help Me soon

[truezplaya]

i think you need to do more reasearch in to this before posting comments on here otherwise you will have the admin telling you that they don't give answers you work towards your answers

[Frinavale]

@gsgurdeep

What is causing the error?
The code accessing the rich text box?
Or the code saving the information to the database?

Please post your error message and explain your problem in more detail so that we can help you better. Include things like: What you've tried so far, What you think is causing the problem, and any error messages are you getting

-Frinny

[gsgurdeep]

I used to post my problems after lot of search on Google & MSN.
There is no specific error message, only says Saving data in table fails.

[MrMancunian]

Can you insert your code in a Try...Catch-block and see what 'ex' is returning? Otherwise, it's impossible for us to come up with an answer...

Steven

[Frinavale]

@gsgurdeep
I would check to make sure that your SQL statement for saving the data is correct.
Use something like Query Analyzer to test your SQL.

[gsgurdeep]

If I insert plaint text data inserted successfully. but when i used any bulleted rich text it throw error says. "Error Insert"
Try Catch block is replied same.

but when
I used Query Analyzer for inserting data.....
this reply with an error..........says
Access Violation.............

Please Help Me ......

[r035198x]

Any chance we'll get to see the code that's inserting the rich text?

[gsgurdeep]

Here is my code

DIM conString As String = "provider=SqlOleDb; Data Source=SERVER;Initial Catalog=DATA_BASE;Persist Security Info=True;User ID=SA"
 
Dim  m1, m2, m3, m4, m5 As String
 
m1=0
m2 =text_name.Text.Trim 'ITEM MODEL
m3 = text_part.Text.Trim 'ITEM PART NO.
m4 = rich_text.Rtf.Trim 'ITEM DESCRIPTION OR SPECIFICATION
m5 = text_model.Text.Trim  'ITEM MODEL NO.
 
Try
            Dim Db As OleDb.OleDbConnection
            Dim Cmd As OleDb.OleDbCommand
            Dim Rs As OleDb.OleDbDataReader
            Db = New OleDb.OleDbConnection(conString)
            Db.Open()
            Cmd = New OleDb.OleDbCommand
            Cmd.CommandText = "Insert Into items Values ('" & m1 & "', '" & m2 & "', '" & m3 & "', '" & m4 & "', '" & m5 & "')"
            Cmd.Connection = Db
            Rs = Cmd.ExecuteReader
            Rs.Close()
            Db.Close()
Catch ex As Exception
            MsgBox("insert+++++++++++++" & ex.Message)
End Try

it works fine if i use

m4 = rich_text.text.Trim 

in place of

m4 = rich_text.Rtf.Trim 

please help me

[r035198x]

Shouldn't you be using ExecuteNonQuery instead of ExecuteReader which you only use for select statements?
Make that change, try it and post the full error message that you get exactly as it is.

P.S You should also be using parameters for this type of thing.

[gsgurdeep]

I Have used ExecuteNonQuery instead of ExecuteReader, But Result is same.

Again Modified code run well with

m4=rich_text.text.trim 

but says error when

 m4=rich_text.rtf 

My Try Catch Block says following Error
" Syntex Error or Access Violation. "

[r035198x]

Now print out the command text before executing the query to see if your command is valid. Post the text that's printed as well.
P.S Which version of SQL server are you using (if you are using SQL server that is)?

[raids51]

what might be happening is that some character in the string(because with all those weird characters that the rtf format puts in there ) may be messin with sql and tellin it to do some command, kinda like how sql injection works(putting quotes in the beginning of the string will allow you to run a sql command on it EX the query 'and 1=1 in a login name would tell sql server the command if password = '' and 1=1 then login.... if im not bein clear then you can google this). so this would throw a syntax error. im just puttin some ideas out there.