• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

Import numeric field from dbf file - field shrinks by 1 digit

For years I have been importing FoxPro dbf files into SQL Server using a SQL procedure. Everything worked fine.

Recently I had to reinstall some of the software. Now, when I import such a file, each numeric field ends up in SQL Server with the numeric fields 1 digit smaller (i.e., a size-7 numeric field becomes size=6). Character fields are unchanged.

Any idea why this is happening and how to correct it?

Len Rodberg
0
Lrodberg
Asked:
Lrodberg
  • 5
  • 2
1 Solution
 
chapmandewCommented:
It did this when you reinstalled SQL Server or FoxPro?  It sounds like the default of the floating point data type has changed somehow.
0
 
LrodbergAuthor Commented:
How would one change the floating point default  -- or the way it imports a numeric field? I haven't found anything that changes it.
0
 
CarlWarnerCommented:
You may have been doing the import for years, but you haven't told us what version of FoxPro the data is you're importing or what connectivity mechanism you're using to perform the import.  Without more information, we have to just throw up our hands and give up.

[I guess you didn't think this was important enough to place in the FoxPro zone where those folks know more about the nature of Fox data than those in the SQL Server zone.  ??? ]
0
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
CarlWarnerCommented:
>> I'm using Visual Foxpro 6.0 and importing through the ODBC connection. Does that help?

Do you know which version of the ODBC driver you're using?

Are you adverse to using an OLE DB Provider for VFP which would have better performance?
0
 
CarlWarnerCommented:
Here are the links for both the latest ODBC driver and the latest OLE DB Provider for VFP:

Visual FoxPro ODBC Driver
http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
[There were many versions of the ODBC driver, even with VFP6.  VFP6 was involved in five Service Packs, most of which (if not all) included a revision to the ODBC driver.]

Microsoft OLE DB Provider for Visual FoxPro
http://www.microsoft.com/downloads/details.aspx?FamilyID=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&DisplayLang=en

0
 
CarlWarnerCommented:
On the topic of the OLE DB Provider for VFP--

The Visual FoxPro OLE DB Provider includes the following:

Support for most Open Database Connectivity (ODBC) driver functionality from earlier versions of FoxPro

Improved threading model for scalability

OLE DB Provider for Visual FoxPro
http://msdn2.microsoft.com/en-us/library/0xzsac67(VS.80).aspx
0
 
LrodbergAuthor Commented:
I downloaded the latest ODBC driver but it gave an unspecified error when trying to install it (I'm running Windows Server 2003).

The driver I am using (which gives the 1-digit-less numeric field) is version 6.000.8167.

Any idea what the problem might be?
0
 
CarlWarnerCommented:
That definitely isn't the latest version.  (the latest should end with 8629, I believe).  The one you show looks like it might have been the very first one for VFP6.  They had a lot of fixes since the base product of VFP6 with five service packs following it.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now