Appboard/2.4/admin/configuration database/example sybase

This section describes the tasks that you must perform to use SQL Anywhere with enPortal:

Downloading the Sybase JDBC Driver

After you have installed enPortal, you must download a JDBC driver that will enable enPortal to establish a connection to your Sybase database.

To install the JDBC driver:

1. Access the Sybase JDBC driver files at the following location: http://www.sybase.com/products/informationmanagement/softwaredeveloperkit/jconnect
2. Download the jConnect zip file to your local filesystem.
3. Locate the file jconn3.jar within the jConnect zip file.
4. Extract the file jconn3.jar and place it in the folder PORTAL_HOME/classes-custom/

Installing Sybase SQL Anywhere on Windows

To install Sybase SQL Anywhere on Windows systems:

1. Copy or unzip the Sybase installation files to a temporary folder.
2. Go the temporary folder where the installation files were unzipped and run setup.exe. The Welcome window opens. Click Next.
3. After reading the license agreement terms, click Yes to proceed with the installation.
4. On the Select Components window, select only the following components:
   1. Under the Databases node, select Adaptive Server Anywhere for Windows.
   2. Under the Synchronization node, select SQL Remote for Adaptive Server Anywhere.
5. Click Next. The Choose SQL Anywhere 8 Location window opens.
6. Specify the directory where SQLAnywhere 8 should be installed and click Next. The Choose Shared Components Location window opens.
7. Specify the directory where shared components should be installed and click Next. The Select Program Folder window opens.
8. Click Next unless you want to change the name of the program folder.
9. On the Server License window, enter the appropriate details.
10. The Start Copying Files window opens. Review your prior selections. Click Next if all items are correct or Back to change any information.
11. Click Finish on the next window that opens. The installation process begins. You will need to reboot your computer after the installation process is complete and before you proceed to the next stage.
12. Create a Sybase data archive file as outlined in the next section, Creating a Database.
13. Place the data archive file in a directory under the main Sybase directory, for example: sybase home directory/SYBSsa8/

Creating a Database

To create a Sybase SQL database:

1. Launch Sybase Central 4.0. In Windows, this is launched from the Start menu by selecting Programs→SQL Anywhere 8→Sybase Central.
2. On the Sybase Central screen, select Tools→Adaptive Server Anywhere 8→Create Database.
3. The Choose a Connection window opens. Select Connection created by a local engine and click Next.
4. The Create an Adaptive Server Anywhere Database window opens. Click the Browse button to display the Choose File dialog box. Navigate to the directory where you would like to create the database (the typical location is Sybase\SQLAnywhere) and then type the name. It is recommended that you use portal as the database name. Click Open and the dialog box closes.
   

   Sybase will not start the database if another database running on the same network/port already has the same name. Ensure that you use different names if you are running multiple databases, such as in a training or testing environment.
5. On the main window, click Next. The Choose the Transaction Log Options window displays. Keep the default values and click Next.
6. The Mirror the Transaction Log window opens. Accept the default values and click Next.
7. The Java in the Database window is displayed. Ensure that both check boxes are checked. Click Next.
8. The Choose the Database Attributes window opens. Check the Case sensitivity for all names and values and Create SYSCOLUMNS and SYSINDEXES views check boxes. Click Next.
9. The Which Page Size do you Want the Database to use window appears. Keep the default values and click Next.
10. The Which Collation Sequence do you Want the Database to use window appears. If internationalization is required, click the Use the following supplied collation radio button, and then select the UTF8 collation.
11. Click Finish. A database is created in the directory specified, with the parameters set. You are returned to the main Sybase Central screen.

Creating a Service Pointing to the Database

To create a Windows service that points to the Sybase SQL database:

1. Launch Sybase Central 4.0. In Windows, this is launched from the Start menu by selecting Programs→SQL Anywhere 8→Sybase Central.
2. In the left pane of the Sybase Central screen, expand the node Adaptive Server Anywhere 7 and then select Services.
3. In the right pane, double-click Add Service. The Create New Service window opens. Click Next.
4. The Choose Service Type window opens. Select Network Database Server from the list box and click Next.
5. The Choose Name and Startup window opens. Type SQLAnywhere in the field and select Automatic. Click Next.
6. The Choose Path Name window opens. Keep the default values and click Next.
7. The Specify Parameters window opens. On the first line, enter: –n database where database is the value you specified in Creating a Database.
8. On the same line, enter -x "tcpip(ServerPort=port_number)". This is optional and typically used when more than one database service is created.
9. On the next line, enter the full path (including the filename) of the database file you specified in Creating a Database.
   

   Make sure you enclose the path in double quotes.
   Click Next.
10. The Choose Account window opens. Select the Local system account option. Click Next.
11. The Choose Options window opens. Ensure that Start service when created is unchecked. Click Next.
12. The Ready to create new Service window opens. Click Finish. You are returned to the main Sybase Central screen
13. On the Sybase Central screen, right-click SQLAnywhere to display the pop-up menu and then select Start to start the service.
    

    You can also start the service from the NT service menu.

Connecting to the Database and Creating a User

To connect to the Sybase SQL database and create a user:

1. On the Sybase Central screen, select Tools→Connect.
2. The Connect window opens. Click the Identification tab and enter the following:
   • DBA in the User field.
   • SQL in the Password field.
3. Click the Database tab and perform the following:
   1. In the Server Name field, type the value you specified for Server Hostname. Note that the name is case-sensitive. Use the Find button to verify the name.
   2. In the Database name field, type the value you specified for Database Name in Creating a Database. You can also use the drop-down list to select the database.
   3. Ensure that the location of the database is displayed in the Database file field. If necessary, click the Browse button and navigate to the correct location.
   4. Ensure that both check boxes are checked and Click OK.
4. The window closes and Sybase Central connects to the portal database. You are returned to the main Sybase Central screen.
5. You should now change the password for the SQL Anywhere Database Administrator. This step is optional, but it is recommended in order to ensure security.
   1. In the right pane of the Sybase Central screen, select DBA.
   2. Right-click to display the pop-up menu and click Properties.
   3. Enter and confirm the new password.
   4. Click OK to return to the Sybase Central screen.
6. In the left pane of the Sybase Central screen, expand server portal and then database portal (DBA). Then select the Users and Groups node.
7. In the right pane, double-click Add User or Group.
8. The Choose Name and Type window is displayed. Select the radio button Create a user and type the desired user name in the field. It is recommended that you use portal for the user. Click Next.
9. The Attributes window is displayed. Enter values into the Password and Confirm fields. It is recommended that you use portal for the password.
10. Ensure that the check boxes User/Group is allowed to connect, Resource, and Remote DBA are checked.
11. Click Finish. A user is created for this database. You are returned to the main Sybase Central screen.