RDBMS SQL Database Support
SMSgee application support using RDBMS SQL Database, the supported database :
- MS Access (default database on installer)
- MS SQL Server 2005-2012
- Oracle 9 or later
- My SQL 5
Preparing Database for SMSgee Software
When using the database beside the default database from the installer,
The steps for MS SQL Server 2005-2012, Oracle 9 or later and MySQL 5 are :
1. Create the new blank database
2. Create the table by running the SQL Script for creating Table, the SQL Script could be found on "DB Table Script" folder on the installation directory.
- smsgee44_tablescript_mssqlserver2005-2008-2012.sql for MS SQL Server 2005-2012
- smsgee44_tablescript_mysql5.sql for MySQL 5 or later
- smsgee44_tablescript_oracle9.sql for Oracle 9 or later
3. After the the SMSgee software's table is created, the Database is ready to be connected to SMSgee software (proceed to Database Connecting section to connecting SMSgee software with the Database)
Database Connection Settings (MS Access)
The connection between the application and the Database using ADO Connection, before settings the Database Connection Settings The ADO Driver from Database vendor should be installed.
Setting ADO Database Connection Settings :
1. Open the Settings in the main form
2. On the Settings Page go select the Application Settings >> SMS Service .
3. Click the ADO Connection String button to shows the Data Link Properties, select the DB OLE Provider depend on the database used. MS Access database use the Microsoft JET OLE DB Provider.
4. After the OLE DB Provider is selected, select the connection tab, in this example the OLE DB Provider is using Microsoft JET OLE DB Driver. Set the path of the MS Access file on the the "Select or enter database name"
5. Click "Test Connection" to test the Database Connection
6. Click OK on the Datalink Properties, then on the Settings page click "Save and Apply" to save the settings.
Database Connection Settings (MS SQL Server)
The connection between the application and the Database using ADO Connection, before settings the Database Connection Settings The ADO Driver from Database vendor should be installed.
Setting ADO Database Connection Settings :
1. Open the Settings in the main form
2. On the Settings Page go select the Application Settings >> SMS Service .
3. Click the ADO Connection String button to shows the Data Link Properties, select the DB OLE Provider depend on the database used. MS Access database use the Microsoft JET OLE DB Provider.
4. After the OLE DB Provider is selected, select the connection tab, in this example the OLE DB Provider is using Microsoft OLE DB Driver for SQL Server. Set the Server Name, Username&Password and the Database onthe server
5. Click "Test Connection" to test the Database Connection
6. Click OK on the Datalink Properties, then on the Settings page click "Save and Apply" to save the settings.