polish character.dbf VFP6.0 -CSharp VS2003

[krzysiek]

File ".dbf" with codepage mazovia (620) from VFP6.0. In field nazw_mat
value:±æê³ñ󶿼¡ÆÊ£ÑÓ¦¯¬1 .

Program C# VS2003

Read first and ±æê³ñ󶿼¡ÆÊ£ÑÓ¦¯¬1 - ok.

read secend and acelnószzACELNÓSZZ1 - not ok.

I'm sure, that secend open bloking acces to file codepage .dbf and copy to
another file and this same .



???.

thx for reply.

Krzysiek



Program:



string strConn =@"User ID=;DSN=;Cache Authentication=False;Data
Source=e:\firmy\freg0603 ;Password=;Provider='VFPOLEDB.1';Collating
Sequence=MACHINE;Mask Password=False;Mode=Share Deny None;Extended
Properties=;Encrypt Password=False";


OleDbDataReader myReader1=null;

OleDbConnection myConnection = new OleDbConnection(strConn);

OleDbCommand myCommand=new OleDbCommand();

myCommand.CommandText=@"select * from e:\firmy\freg0603"+@"\M1\kslow_ha.dbf
where ind_typ='000000'";

myConnection.Open();

myCommand.Connection=myConnection;

myReader1=myCommand.ExecuteReader();

myReader1.Read();

string pupa1;

pupa1=myReader1["NAZW_MAT"].ToString();

myReader1.Close();

myConnection.Close();

myCommand.Dispose();

//wynik: ±æê³ñ󶿼¡ÆÊ£ÑÓ¦¯¬1


i tu wszystko ok.







string strConn1 =@"User ID=;DSN=;Cache Authentication=False;Data
Source=e:\firmy\freg0603 ;Password=;Provider='VFPOLEDB.1';Collating
Sequence=MACHINE;Mask Password=False;Mode=Share Deny None;Extended
Properties=;Encrypt Password=False";


OleDbDataReader myRe= null;

OleDbConnection myCon = new OleDbConnection(strConn1);

OleDbCommand myCom=new OleDbCommand();

myCom.CommandText=@"select * from e:\firmy\freg0603"+@"\M1\kslow_ha.dbf
where ind_typ='000000'";

myCon.Open();

myCom.Connection=myCon;

myRe=myCom.ExecuteReader();

myRe.Read();

string pupa2;

pupa2=myRe["NAZW_MAT"].ToString();

//wynik:acelnószzACELNÓSZZ1



a tu uci±³ polskie znaki



Krzysiek.

 

[krzysiek]

vfpoledb9

and no problem.

Krzysiek

 

[Cindy Winegarden]

Hi Krzysiek,

I'm not sure what you mean below, but the latest FoxPro and Visual FoxPro
OLE DB data provider, downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates works for all versions of
FoxPro tables and has been significantly improved over earlier OLE DB data
providers.