Connect to a Sybase11.9.2 database

  • Thread starter Thread starter microsoft
  • Start date Start date
M

microsoft

I want to access a Sybase11.9.2 database by ADO.net.
Then I create an OleDbConnection named oConn,and the connection string is
"Provider=Sybase.ASEOLEDBProvider;Server Name=myASEserver,5000;Initial
Catalog=myDBname;User Id=username;Password=password", it can be opened
succeeded . But when I use it to query a data table , the result is
rough-and-tumble code (my result is Chinese).

I think that I should set up the character'set of the Sybase database in the
connection string, but I don't know how to do .

Anyone have any ideas?

Huzs
 
Hi,

I remember we had similar issue with Japanses some time ago and, if I
remember correctly, you need to configure Sybase server itself to support
the language. At least it worked after our guys applied some sort of the
language support against the server
 
Back
Top