Jump to content


Photo
- - - - -

TRANSOFT ODBC DRIVER


7 replies to this topic

#1 George Walton

George Walton

    Advanced

  • Members
  • PipPipPip
  • 83 posts
  • Gender:Male
  • Location:Markham, Canada

Posted 20 June 2001 - 01:07 PM

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.

#2 Fred Marker

Fred Marker

    Advanced

  • Members
  • PipPipPip
  • 82 posts
  • Gender:Male
  • Location:Columbus, Ohio, United States

Posted 20 June 2001 - 06:47 PM

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

#3 George Walton

George Walton

    Advanced

  • Members
  • PipPipPip
  • 83 posts
  • Gender:Male
  • Location:Markham, Canada

Posted 20 June 2001 - 09:19 PM

Hi Fre

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

Cheer

George

#4 Fred Marker

Fred Marker

    Advanced

  • Members
  • PipPipPip
  • 82 posts
  • Gender:Male
  • Location:Columbus, Ohio, United States

Posted 21 June 2001 - 02:06 PM

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



#5 George Walton

George Walton

    Advanced

  • Members
  • PipPipPip
  • 83 posts
  • Gender:Male
  • Location:Markham, Canada

Posted 21 June 2001 - 07:39 PM

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.

#6 Rob Fantini

Rob Fantini

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 267 posts
  • Gender:Male
  • Location:Haverhill, United States

Posted 03 July 2001 - 12:31 AM

How much does the Transoft ODBC driver cost?

#7 Fred Marker

Fred Marker

    Advanced

  • Members
  • PipPipPip
  • 82 posts
  • Gender:Male
  • Location:Columbus, Ohio, United States

Posted 03 July 2001 - 11:45 AM

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.

#8 lawalton

lawalton

    Member

  • Members
  • PipPip
  • 29 posts
  • Gender:Female

Posted 03 July 2001 - 01:08 PM

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



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users