Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to solve ODBC - Microsoft DBASE Driver Limitation?

Posted on 2004-09-23
8
Medium Priority
?
922 Views
Last Modified: 2013-12-20
Hi Techies,

To create DBF using Microsoft DBASE Driver(*.dbf), the limitation of Microsoft DBASE Driver is:
While dBASE allows a precision and a scale to be specified with a NUMERIC data type, it is not supported by the ODBC dBASE driver. The ODBC dBASE driver always returns a precision of 15 and a scale of 0 for a NUMERIC data type.

How do I overcome this?
Say, I need a field to contain currency, I would like to specify the length of that field to be 10,2. How can this be done?

Thanks in advance.
0
Comment
Question by:lakshmi_n
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 12144039
Can you create it as a Long instead?

Leon
0
 

Author Comment

by:lakshmi_n
ID: 12158115
Hi Leon,

I cannot change the currency field of the DBF to long, as the DBF is used by another system, which has been designed to take up DBASE - DBF with Numeric data type for that particular field.

Is there any way to change the format(structure as (10,2)) after creating the DBF atleast?

Thanks
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 12185402
The other system you mention, is it in fact a dBASE system?  Or is it really a FoxPro system?

The reason I ask is that the dBASE driver supplied by MS is a lowest common denominator driver where if you actually could use the freely downloadble FoxPro driver that supports .dbf files you might have more control and functionality.  dBASE is not a MS product where FoxPro/Visual FoxPro is.

Visual FoxPro ODBC Driver
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx

No guarantees, but another possible way to attack your problem.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 29

Expert Comment

by:leonstryker
ID: 12972232
I believe CarlWarner should get these points.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12996081
PAQed with no points refunded (of 500)

modulo
Community Support Moderator
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 12997177
I'm glad I could help.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Suggested Courses

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question