SQL Support

Select Configuration/SQL Support from the Options, and the SQL Support dialog window appears. This dialog box allows you to set the location of the SQL server that hosts the AccuMark Storage Areas. The dialog box also features an area to configure a CAD Relational Database.

You can select a drive number 0-9 to identify the SQL drive number to display in the AccuMark Explorer for Storage Area locations.

The CAD Relational Database is not an AccuMark Storage Area, but is a database that contains model, piece, and marker statistical information that can be used by Yunique PLM, Web PDM or any external query that you may set up directly in SQL server management or a similar program.

These image files can be displayed in Yunique PLM or WebPDM. Images can be created with or without Annotation on them. To have annotation appear on these images, specify an AccuMark annotation table to use.

In order to create the binary image data that will be stored in the CAD Relational database temporary .wmf and .bmp are used. These files are created in the \userroot\temp folder. Unless delete restrictions are enforced, these files will automatically get deleted the next time the system is rebooted.

SQL Support features two modes of user authentication: Windows and SQL. If Windows

authentication is used, then the user’s credentials are verified based on the Windows

login. If SQL authentication is used, a username must be specified with the password.

The DSN in SQL Support will allow the user the option to use SQL Server authentication

or Windows authentication. Users may create a System ODBC connection to the SQL

server and use that DSN name in SQL Support. Be sure to check systems’

firewall settings as well.

Select the TEST key located at the bottom right of the window to complete the test.

Detailed reference information related to installing and using SQL with AccuMark can be found in the Training Docs folder under the AccuMark ITManual directory on the installation media.