i have default installation of SQL 7.0 on win2K wid Arabic as default language.. i managed to insert Arabic data from Enterprise Mnaneger
But Unable to insert it from VB.I can easily write Arabic in rich text box it gives when i save.. run time error 424 "Object Required"


the code snipet is as under

 Dim db As New ADODB.Connection
 db.Open "dsn=Jdeep"
db.Execute "insert into Arabic values(123," & "'" & RichTextBox1.Text & "')"

to be sure this error from arabic insertion do you
first could insert english text instead of arabic

if so reply

Ahmed Ali
Software Developer

thanks..
i managed to remove the error ,
English insertion is fine but when i write arabic in text box it is inserted in DB as ?????? ?

Plz i need help

change the language local on your machine to arabic
it's related to your OS ...
you can do that through regional setting in control panel

Ahmed Ali
Software Developer

the last check is the collation for Database must be one of the Arabic collations,also check collation for the table field which you are inserting in.

Ahmed Ali
Software Developer

Hi all!

I am having the same problem. I can input Arabic (Input locale etc all set)in a text box in my VB app. I can also input Arabic in Sql Server 2000 (collation for this field set too). But when saving from VB to Sql I get ãäÊÈÇÔãÓäíÈ instead of my Arabic input.

I am using the following SQL String :

"UPDATE agLanguage SET Language2 = N'" & tReference.Text & "' WHERE id = 1"

tReference.Text contains Arabic text but when debugged or saved I get ãäÊÈÇÔãÓäíÈ instead. The font of this text box is Arial Unicode MS.

any help please ?

Thanks
Dom