7 replies to this topic

[George Walton]

H

Has anyone out there used the Transoft ODBC Driver to access PRO-ISAM files?
am trying to integrate Crystal Report Writer into my system

Regard

George Walton Snr.

[Fred Marker]

Yes, we have the Transoft ODBC driver and are doing reports from ProISAM data using MS Access.

[George Walton]

Hi Fre

I would appreciate any specs that you might have - particularly on how to create the UF
and the UDD files

Cheer

George

[Fred Marker]

You must create your own Data Dictionary (.UDD) for all the ProISAM files that you wish to access via ODBC. This involves creating a text file (.UDF) that describes the file and record layout. Then run U/SQLi to convert the .UDF into a .UDD file.

ProIV field names that use invalid characters (like '# ','$' and '.') aren't allowed in ODBC. You must change these. Also you must give each array element, like PM.DEPTVIEW(1), a unique name since ODBC does not support arrays.

I wrote a ProIV function to try to automate creating this .UFD file. However, my function does not handle ProIV array fields properly when creating the text file for the .UFD file. You must manually create a separate field for each element of the array and adjust the offset accordingly.

Attached is a crude function that exports the basic info needed for the .UFD file.

Good Luck!

Attached Files

•  odbc_ufd.prx   9KB   270 downloads

[George Walton]

Hi Fre

Thanks a ton for taking the time an effort to answer my problem. I have tried it out on a smal
file and I am happy to report that I have been able to print this file with Crystal Reports
Thanks once again for response

Regard

George Walton Snr.

[Rob Fantini]

How much does the Transoft ODBC driver cost?

[Fred Marker]

I don't recall the exact cost but it was nearly $2,500 US for 1 server license (Windows NT) supporting 5 concurrent connections and 5 U/SQL ODBC client licenses.

[lawalton]

The cost for the ODBC driver is as follows

Client $125.00 per use
Server $420 per user (Number of client concurrent users x $420
Maintenance is 15