pooya


hi

i write a prg that read data from Dos dbf And Convert Some Filed in Dbf And it work But Same Code (Changed in Vb.net) Dosent Work when Data Come To .net Layer Reform and Ascii Code Change

I think There Is problem in ado Or Some thing like that

Any body know What is The diffrence Between Odbc Provider In Vfox And Vb.net

Thank u

Best Regards Pooya





Re: What is The diffrence Between Odbc Provider In Vfox And Vb.net

dni


There are no diferences. You mean OLE DB provider

http://msdn2.microsoft.com/en-us/library/ms810682.aspx







Re: What is The diffrence Between Odbc Provider In Vfox And Vb.net

Cindy Winegarden

Hi Pooya,

When you write code to access data you need to use the ODBC driver or OLE DB data provider that matches the data. Since you're working with Fox DBFs then you should use the FoxPro ODBC driver, or preferably the OLE DB data provider, even when you're accessing the data via VB.NET.

Can you please post your connection string and the code you're using, and also the exact text of the error message(s) that you get







Re: What is The diffrence Between Odbc Provider In Vfox And Vb.net

pooya

Hi

i know

I use Odbc manager and create A connection in it and Set Driver to Vfp Dbf And In My ado Connection I use "" Dsn = Name ""

I am Using ado .net 2

Best Regards






Re: What is The diffrence Between Odbc Provider In Vfox And Vb.net

Cindy Winegarden

Hi Kharamesh,

I'm still unclear what you mean by "difference between ODBC in VFox and Vb.net." You say you're using an ODBC connection to Fox data and I assume you're using VB.net and ADO to access the data. That should work fine although VFP OLE DB is preferable. Are you having trouble with accessing the data through this connection or using ADO to manipulate it






Re: What is The diffrence Between Odbc Provider In Vfox And Vb.net

Alex Feldstein

Cindy,

Maybe we are misunderstanding his question as it is not clear. The original post mentions reading from DOS and having "ASCII Code Change". Could it be he's referring to a CodePage problem

Pooya:

What is the language (and codepage) used in the original DOS data