YesAX V3.1.2 - Software User Manual - 第208页

15 -4 SPC Data Logg ing PWD : set to the password of the SQL Server. WinNTMode : set to 1 when use windows authentication mode for login validation. Under this mode the user don’t need to set the value of UID and PWD. If…

SPC Data Logging 15-3

Nordson YESTECH provides a sample MS Access file, SPCReportSample.mdb, to illustrate

the type of information AXI users can extract from the data generated by the AXI machines. You

can use the sample database as the starting point to develop your own custom reporting system.

The sample database carries no copyright and is distributed in open source form. The Sample

database plus a write-up describing its usage can be found on the Installation CD in the

document folder under the name SPCReportSample2.zip.

In addition to logging data into a MS Access database, you can also write the SPC data to an

ASCII text file/files. To turn on the feature, edit the YesAX.ini file and change:

[ODBC_Report]

TextOut=1

TextFolder=C:\Aoi_Data\SPC_DataLog ;folder for the text files

The software put the exact content of the SPC_Data table into one file called SPC_Data.txt.

15.2 Using MS SQL Server

MS SQL Server can be used instead of MS Access for database management. There are some

parameter changes needed in the YesAX.ini file, [ODBC_Report] section.

UseSQLServer=1

Server=

Address=

UID=

PWD=

WinNTMode=

UseNamedPipe=

UseSQLServer is set to 1 to enable software to write data to SQL Server instead of MS Access.

Before dumping data to SQL server, set up SQL Server either locally or on a remote machine.

SQL database name (default)

YesDb

SQL Server name

Server

SQL Server local server, default value

(local)

SQL Server computer name

Address

SQL Server User ID

UID

SQL Server Current Password

PWD

If software cannot connect to the specified SQL Server “YesDb”, it will automatically switch

back to Access database.

Server/Address: set to the name of computer or IP address of computer that has SQL Server

installed. If the server is stored locally, then it should be set to “(local)”.

UID: set to the user ID of the SQL Server.

15-4 SPC Data Logging

PWD: set to the password of the SQL Server.

WinNTMode: set to 1 when use windows authentication mode for login validation. Under this

mode the user don’t need to set the value of UID and PWD. If set WinNTMode to 0, connection

will use SQL Server mode, then the user needs to set up both UID and PWD.

UseNamedPipe: set to 1 when using Win32 named pipes(i.e. computer name for “Server =”

and/or “Address=”); set to 0 when using Win32 Winsock TCP/IP (i.e. actual IP address of the

Server and/or Address).

With the parameters set, starting the YesAX software will cause the creation of YesDb database

in the MS SQL server folder. (By default the full path is: C:\Program Files\Microsoft SQL

Server\MSSQL\Data). It is important to let the software create the YesDb database

automatically. Do NOT try to manually create the database or try to import the database using

the YesDb.mdb file created by the MS Access software. Doing so could prevent the YesAX

software from connecting to the SQL server.

The SQL Server main computer and all computers connecting to the SQL database can be within

the same workgroup (domain) or at different workgroup. For a remote connection, use the IP

address on both the Address and Server fields. If you have problems connecting to the remote

SQL database, try turning off the firewall on the remote machine. YesAX connects to the default

instance (SQL Server 2000 and later support multiple installations of SQL Server on a single

computer) of SQL Server, which is the first installation of SQL Server.

Below is an example of SQL Server connection settings:

UseSQLServer=1

Server=SQLServer1

Address=192.168.1.1

UID=sa

PWD=yestech

WinNTMode=0

UseNamedPipe=0

Sometimes when the user connects to SQL server for the first time, the following error message

“Cannot connect to SQL Server master database” may show up. In this case, the YesAX

software was not able to connect to master database thus it cannot create the YesDb database for

data logging. To solve the issue, it is possible for the user to attach the YesDb database (created

by YesAX software in early case) to SQL database and then the YesAX software should be able

to connect to this YesDb database. To do this, the user needs to go to YesTech ftp site and get

the yesdb.mdf and yesdb_log.ldf file first and then copy these two files to the SQL server

computer. After that the database administrator can use his preferred SQL database tools to do

the attach job.

15.3 Using MySQL Database

MySQL database can be used instead of MS Access or MS SQL Server for database

management. There are some parameter changes needed in the YesAX.ini file, [ODBC_Report]

section. These parameters look similar to SQL Server database settings but are not exactly the

same.

SPC Data Logging 15-5

UseMySQL=1

MySQLServer=localhost

MySQLUser=root

MySQLPassword=rootpassword

MySQLPort=3306

MySQLOption=3

UseMySQL is set to 1 to enable software to write data to MySQL database instead of MS Access.

Before dumping data to MySQL database, set up MySQL database either locally or on a remote

machine.

 NOTE

UseMySQL and UseSQLServer cannot be set to 1 at the same time. If it is,

software will ignore both requests and write data to the default Access database

instead.

MySQLServer: parameter specifies the name of the MySQL database server. If the installed

database locates in the local YesAX computer, the default parameter will be “localhost”. If

software cannot connect to the specified MySQL database, it will automatically switch back to

Access database.

MySQLUser: specifies the current user.

MySQLPassword: specifies the password for current user.

MySQLPort: specifies the network port used by the current database. The default value is 3306.

MySQLOption: specifies the current connection options for MySQL database. The default

value is set to 3.

With the parameters set, starting the YesAX software will cause the creation of YesDb database

in the MySQL database folder. (By default the full path for MySQL Server version 5.0 is:

C:\Program Files\MySQL\MySQL Server 5.0\data). It is important to let the software to create

the YesDb database automatically. Do NOT try to manually create the database or try to import

the database using the YesDb.mdb file created by the MS Access software. Doing so could

prevent the YesAX software from communicating with the MySQL database server.

To write data to MySQL database, install one extra software package on the local computer. The

name of the installation package is called “mysql-connector-odbc-3.51.26-win32.msi”. Double

click this file to start the installation. This package will install MySQL version 3.51 ODBC

driver on the local computer. This driver will allow YesVision/YesAX to have the ability to

write data to the MySQL database. If you don’t want to export data to the MySQL database,

there is no need to install the MySQL ODBC driver.

15.4 XY Position Tracking

YesAX software can be used to track the XY position of parts on PCBs. The feature is

implemented as an extension to the Marking Inspection feature of the AXI. Marking Inspection

is able to verify placement of any markings or parts using template matching. The feature

compares the “found” position with the “trained” position. If the difference is greater than a

preset tolerance the software will fail the inspection. To track the XY position, the software can

be instructed to log all the “found” positions on the selected parts.