Home Recent Sign up Sign in

MS Dynamics C5

 

Support for MS Dynamics C5 (including older C5 versions). Both MS-SQL based and native databases supported.

 

The following versions of MS Dynamics C5 are supported

  • MS Dynamics C5 2008
  • MS Dynamics C5 4.0
  • older version are also supported - please ask.

The following data-types are supported:   STR: Yes "Varchar" INT: Yes "Integer" REAL: Yes "Numeric(28,12)" DATE: Yes "Datetime" ENUM: Yes "Integer" BLOB: No ...

 

Additional installation

In order for RapidiOnline to connect to your local database server, you need to download and install a small service, that we call the "RapidiConnector". ...

 

For MS-SQL based systems you might need to install a MS-SQL client on the computer running the RapidiConnector.

For native databases, you need to have ODBC access in your C5 license and to install the MS Dynamics C5 ODBC driver on the computer running the RapidiConnector.

 

Configuration

The fields of the MS Dynamics C5 Data Source Card are described as follows:

  • Description: Enter a text describing the Data Source.
  • Database Type: Choose which database you want the Data Source to run on (Native or MS-SQL Server).
  • Server Connect: If running on an MS-SQL server you specify the name of the MS-SQL Server.
    If it is a Native database, leave this field blank.
  • Database Path: If running on an MS-SQL Server you specify the name of the database on the MS-SQL Server.
    If running on a Native database, specify the full path to the database file. For example "C:\\Program Files\\c52008\\C5data.dat"
  • Use Windows Authentication (only on SQL Server): If you use the same UserID and Password to access the database as for when logging on to your Windows, you can mark this field. Please note that it is the username that the RapidiConnector is running under, that is used. If you use windows authentication, then the fields UserID and Password are ignored.
  • UserID: If access to the database requires a UserID you have to specify the UserID here.
  • Password: If you enter a UserID the corresponding Password is applied here.
  • Company: Enter which Company you want to use (specify the name) - usually "DAT".
  • Schema: You can specify which schema should be used - can normally be left blank.
  • Installation Path: If running on a native database, then specify the path to the directory of your MS Dynamics C5 Client. For example "C:\\Program Files\\c52008"

Test and Read Design

 

You can Test that the access to a DataSource works using the Test button on the DataSource. Select the Configure Tab and then go to ...

 

Read Design is the way to read the layout - the information about tables and fields - from a DataSource. Reading the design is necessary ...