ODBC (ODBC (Open Data Base Connectivity))

 

Top  Previous  Next

ResSched supports Open Data Base Connectivity (ODBC). ODBC allows customers to use their own database managers, spreadsheets, and other applications to generate reports and analysis using ResSched data.  To access ResSched data from other applications, you must have the 32 bit ODBC driver for TopSpeed data files.  The ResSched Corporate Edition CD includes a single-user, read-only ODBC driver.

 

To install the ODBC driver on a workstation:

 

1.Place the ResSched CD in your CD drive.

 

2.Open the ODBC folder on the CD and run program file there (TS-ODBC-RO-505.exe at this time)

               

3.Enter your name, your organization's name, and the serial number provided in your ResSched license letter sent with the CD.

 

3.Click the Next button until you are finished the installation.

 

 

 

To configure the ResSched data file as an ODBC data source:

 

1.  From the Start button,  go to Control Panel and select Administrative Tools

 

2.  Select Data Sources (ODBC) and then click Add

       

ODBC

 

4.Enter your choice for name and description (the ones shown here are suggested). Use the TopSpeed Super File button to enter the full path of the resdata.tps file in your ResSched data folder, then click OK.

 

5.Click OK.

 

 

Some ODBC applications require special configuration of the data source.   The installation program has installed a Help file for the Soft Velocity ODBC driver on your work station.

 

The ODBC driver that is provided on the CD is a read only driver.   There is a read/write driver available as well, but because using this driver can corrupt your ResSched data, we only provide the read/write driver and its key on request. 

 

If you need to use the ODBC driver on more than one workstation, you must purchase additional licences from Madrigal Soft Tools or, if you need four or more workstation licences, from SoftVelocity Corporation.   If you order from SoftVelocity, make sure to use only the 32 bit read-only driver. Using the read/write driver risks making your data files unusable.

 

SoftVelocity Corporation

1-800-354-5444

1-954-785-4555

 

http://www.softvelocity.com