Generate reports using Microsoft Access from OfficeClip database

#1 · March 1, 2023, 5:20 pm

Go to your Control Panel by and select ODBC Data Sources or Data Sources (ODBC) [depending on your system] icon. Note that the ODBC icon may also be in the Administrative Tools folder.
Click on the Systems DSN tab.
Click on the Add button. Scroll down to SQL Server entry in the Create New Data Source window and click on the Finish button. Type a name and select a server and click Next.
Select the authentication mode. This is provided in the web.config file at c:\program files\officeclip\8\officeclip directory. Click on Finish on the ODBC Microsoft SQL Server Setup.
On the next screen select the Change the default database to checkbox and scroll down to the database you want to connect. Click on Next. Click on Test Data Sources on the next screen.
Click on OK when the screen says that the Test completed successfully.
Click OK at the ODBC Data Source Administrator screen.