Improve company productivity with a Business Account.Sign Up

x
?
Solved

Inter-change MS-SQL and Clipper .DBF

Posted on 2002-06-19
3
Medium Priority
?
248 Views
Last Modified: 2012-08-13
Hi all,

Now I'm studing the possiblity to build a new system using MS-SQL server. I have to integrate this system with the legacy system which using Clipper. The communication will be batch mode run by schedule or as request. In the communication process include select and update command in Clipper DBF file.

What is the best solution to do this. The final application will be Web based application using MS-SQL.

Thank you

Nititum

0
Comment
Question by:nititum
2 Comments
 
LVL 1

Accepted Solution

by:
qhanrahan earned 80 total points
ID: 7111492
You could use DTS to import and export the DBF.  Check out Alaska-Software.com for possible driver to access MS-
SQL.
0
 

Expert Comment

by:CleanupPing
ID: 9280307
nititum:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

608 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