ADO.NET and SQL2000 and Arabic data
I have a project made with VB6 using RDO connection to connect to SQL 2000 to a database with collation sequence SQL_Latin1_General_CP1_CI_AS, same collation is used for the columns, This database contains Arabic Data in VARCHAR fields
I wrote a small program with VB.Net 2005 that connect to the same database using ADO.Net.
The problem I faced is that this program couldnt read and save Arabic in the database. I tried to change the fields data type from VARCHAR to NVARCHAR this way I could save Arabic and read only the newly entered data after the data type changed after that the old VB6 project stopped read Arabic.
I need these 2 projects to read and write Arabic data
Do you have any suggestions? Please help.
[734 byte] By [
mamian] at [2007-11-20 11:27:08]
# 1 Re: ADO.NET and SQL2000 and Arabic data
the RDO connection I'm using is :
dim cn as As rdoConnection
cn.Connect = "uid=" & UserName & ";pwd=" & Pwd & ";server=" & ServerName & ";driver={SQL Server};database=" & DBName & ";AutoTranslate='No';DSN='';"
cn.CursorDriver = rdUseOdbc
cn.EstablishConnection rdDriverNoPrompt
cn.QueryTimeout = 3000
the ADO.Net connection i'm using is :
Dim connection As New SqlConnection("server=" & ServerName & ";uid=" & UserName & ";pwd=" & Pwd & ";database=" & DBName & ";Connect Timeout=3000")
If my question is not clear please let me know I'm waiting your help thank you.
mamian at 2007-11-10 3:29:58 >
