Make Your SoftNet Cheque Writer Pro to Work in Network Environment

The default database for the SoftNet Cheque Writer Professional is microsoft access. Since we use ADO driver to access the database, it cannot handle concurrent sessions. But the program can work practically with all database as long as the database engine complies with SQL statement. The program has been tested with MSSQL, MySQL, and surely with MSACCESS database engine. MySQL is the most popular database server since it's freely available. Over here I'm going to guide you step by step on how to migrate from microsoft access database to MySQL database server. This does not include the data exporting yet. I will provide necessary tool to do that later on. But you can switch the datebase back and forth just to get hold to the old data.


1. Download MySQL server program from mysql website, http://dev.mysql.com/. Install it at your pc or server. If mysql was already installed somewhere at your networked computers and is running, you can skip this part. Just remember the computer ip address and the password for the mysql server.

2. Download this sql script, chequedb.sql, from VSS server.

3. You need database management application to run the script. Please download a free version of SQLyog here (SQLyog MySQL GUI - Community Edition ) and install it at your pc.



4. Run the SQLyog application and make a connection to your mysql database server. Please key in the correct ipaddress, userid (root) and password.

5. Open the sql script, you has just downloaded, with the SQLyog and run the script. The chequedb database will be created at your mysql server.


6. The MySQL database is ready and now you need to change the configuration at the softnet cheque writer so that it will point to the new server. Right click on Cheque Writer tray icon.









Select the Database Server Setting menu. The database setting dialog will appear.






Check the MySQL check box. Key in correct parameters for database server ip address and password. Click the Test Connection button. If connection is successful, click the ok button. To switch back to msacccess database uncheck the mySQL check box and click Ok button.

Now exit the application and run again.


If you download more than one trial version and install them at different pc, change the database configuration exactly the same as step no. 6 above. Now all your SoftNet Cheque Writer Pros are network ready.