Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem wiht DBF CHAR field in VB 6
Message
From
18/04/2006 22:09:44
 
 
To
18/04/2006 12:53:18
Larry Huisingh
Lockheed Martin Information Technology
Richland, Washington, United States
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01114321
Message ID:
01114459
Views:
17
Larry,

It's been awhile since I've done anything with VFP (and never with any form of VB) ... so I have no answers, just suggestions ... perhaps the VFPOleDb driver will work better. Have you given it a try?

~~Bonnie



>We have a VB6 program that is trying to take data from a DBF file and load it into a SQL Server table. There is a CHAR(4) field that contains characters that have an ASCII value > 128. When the VB6 program accesses this field via the dBASE III ODBC connector it translates the high order characters to some other high order value. For example, the character whose ASCII value was 138 comes back as 232.
>
>I don't know if this is a VB thing or an ODBC thing. Is it possible to work around this in VB6 (or VB.Net or C#)? I know VFP6 can handle reading the field properly but I'd like to avoid redeveloping this app. But, if it has to, it has to.
>
>Thanks in advance for any advice/help.
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform