July 10, 2006 at 4:06 pm
I have a client who has developed a lot of prototype code in Lotus Approach, and subsequently has migrated to a SQL Server DB.
He is looking for a way to avoid having to rewrite all of the reports he has written in Approach, for obvious reasons, and would prefer to be able to simply extract data from the SQL Server DB using the reports developed using Approach.
ODBC has been tried, but is coming up too slow for the volume of reporting that the client ultimately wants to be able to do (large volumes of data, large numbers of reports, etc.)
Does anyone know of any other approaches -- somebody's better ODBC drivers, or possibly another alternative?
Or does anybody know a way to intercept any non-binary intermediate format that could be transformed via a program into a native language format to produce reports out of the SQL Server DB?
At least that way, hopefully, the code that got written would be a one-time deal, that could be applied to any and all future Approach reports that were developed.
July 10, 2006 at 4:15 pm
If I remember correctly Lotus Approach relies on the old DBF format.
You could use a DTS package to export the data you want into suitable DBF files to use for his reports.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply