Setup AccredoDB OLEDB/ODBC driver

OLEDB (Object Linking and Embedding Database), and ODBC (Open Database Connectivity) are Microsoft protocols that allow applications to read Accredo files without opening Accredo. If the Data Interchange module is installed, you can use OLEDB and ODBC protocols to read Accredo data from within other applications such as Microsoft Access, Microsoft Excel and other Accredo Systems.

If using AccredoDB with SQL Server Integration Services to replicate data from Accredo in SQL Server 2008 and later, the mapping files located in the SQL Server folder on the Accredo Installation media or website need to be copied into the appropriate folder for SQL Server Integration Services.

Installing the AccredoDB driver creates an AccredoDB.ini file in the same directory as the AccredoDB.dll which specifies the output file for error logging. The default Error Log file name is AccredoDB.exc.

To setup ODBC DSN

1. From the System DSN tab, select Add
2. Select Accredo Database, click FINISH
3. Complete the fields as follows:
   • Data Source Name, the name to use for the data source
   • Description, a description (if required) for the data source
   • System, the path to Accredo, for example, C:\AccredoSaturn or C:\AccredoMercury
   • Company, (database) - the name of the folder containing the Company data. for example, DATA001
   • User name, the User name (when data is accessed, this User is logged into Accredo with the User's permissions)
   • Password, the password for the User specified above
4. Click OK, Accredo is added to the list of System Data Sources on the System DSN table

SQL Statements

Write SQL statements in the applications that will view Accredo data. When Users are in the other applications, the SQL statements allow reading the data in Accredo.

See also, Link a Server to Accredo ODBC Driver.