Appboard/old/configuration database/example sybase - Revision history

imported>Jason.nicholls at 09:15, 18 July 2014

2014-07-18T09:15:55Z

← Older revision		Revision as of 09:15, 18 July 2014
Line 1:		Line 1:
	{{DISPLAYTITLE:Sybase SQL Anywhere}}		{{DISPLAYTITLE:Sybase SQL Anywhere}}
			[[Category:AppBoard old]]

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

imported>Jason.nicholls: moved Configuring Databases/Sybase SQL Anywhere to appboard/old/configuration database/example sybase

2014-07-18T09:15:26Z

moved Configuring Databases/Sybase SQL Anywhere to appboard/old/configuration database/example sybase

← Older revision	Revision as of 09:15, 18 July 2014
(No difference)

imported>David.moore at 19:14, 25 November 2013

2013-11-25T19:14:27Z

← Older revision		Revision as of 19:14, 25 November 2013
Line 67:		Line 67:
	#The Ready to create new Service window opens. Click Finish. You are returned to the main Sybase Central screen		#The Ready to create new Service window opens. Click Finish. You are returned to the main Sybase Central screen
	#On the Sybase Central screen, right-click SQLAnywhere to display the pop-up menu and then select Start to start the service. {{Note\|You can also start the service from the NT service menu.}}		#On the Sybase Central screen, right-click SQLAnywhere to display the pop-up menu and then select Start to start the service. {{Note\|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:

			#On the Sybase Central screen, select Tools→Connect.
			#The Connect window opens. Click the Identification tab and enter the following:
			#*DBA in the User field.
			#*SQL in the Password field.
			#Click the Database tab and perform the following:
			##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.
			##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.
			##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.
			##Ensure that both check boxes are checked and Click OK.
			#The window closes and Sybase Central connects to the portal database. You are returned to the main Sybase Central screen.
			#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.
			##In the right pane of the Sybase Central screen, select DBA.
			##Right-click to display the pop-up menu and click Properties.
			##Enter and confirm the new password.
			##Click OK to return to the Sybase Central screen.
			#In the left pane of the Sybase Central screen, expand server portal and then database portal (DBA). Then select the Users and Groups node.
			#In the right pane, double-click Add User or Group.
			#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.
			#The Attributes window is displayed. Enter values into the Password and Confirm fields. It is recommended that you use portal for the password.
			#Ensure that the check boxes User/Group is allowed to connect, Resource, and Remote DBA are checked.
			#Click Finish. A user is created for this database. You are returned to the main Sybase Central screen.

imported>David.moore: /* = Creating a Service Pointing to the Database */

2013-11-25T19:05:14Z

= Creating a Service Pointing to the Database

← Older revision		Revision as of 19:05, 25 November 2013
Line 50:		Line 50:
	#Click Finish. A database is created in the directory specified, with the parameters set. You are returned to the main Sybase Central screen.		#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 ==		=== Creating a Service Pointing to the Database ===

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

imported>David.moore at 19:04, 25 November 2013

2013-11-25T19:04:54Z

@@ Line 35: / Line 35: @@
 === Creating a Database ===
 To create a Sybase SQL database:
 #Launch Sybase Central 4.0. In Windows, this is launched from the Start menu by selecting Programs→SQL Anywhere 8→Sybase Central.
 #On the Sybase Central screen, select Tools→Adaptive Server Anywhere 8→Create Database.
@@ Line 47: / Line 49: @@
 #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.
 #Click Finish. A database is created in the directory specified, with the parameters set. You are returned to the main Sybase Central screen.

imported>David.moore: /* Creating a Database */

2013-11-25T18:59:21Z

Creating a Database

← Older revision		Revision as of 18:59, 25 November 2013
Line 39:		Line 39:
	#On the Sybase Central screen, select Tools→Adaptive Server Anywhere 8→Create Database.		#On the Sybase Central screen, select Tools→Adaptive Server Anywhere 8→Create Database.
	#The Choose a Connection window opens. Select Connection created by a local engine and click Next.		#The Choose a Connection window opens. Select Connection created by a local engine and click Next.
	#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.		#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. {{Warning\|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.}}

	{{Warning\|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.}}

	#On the main window, click Next. The Choose the Transaction Log Options window displays. Keep the default values and click Next.		#On the main window, click Next. The Choose the Transaction Log Options window displays. Keep the default values and click Next.
	#The Mirror the Transaction Log window opens. Accept the default values and click Next.		#The Mirror the Transaction Log window opens. Accept the default values and click Next.

imported>David.moore: /* Creating a Database */

2013-11-25T18:58:11Z

Creating a Database

← Older revision		Revision as of 18:58, 25 November 2013
Line 41:		Line 41:
	#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.		#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.

	{{Warning\|Sybase will not start the database if another database running on the same network/port		{{Warning\|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.}}
	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.}}

	#On the main window, click Next. The Choose the Transaction Log Options window displays. Keep the default values and click Next.		#On the main window, click Next. The Choose the Transaction Log Options window displays. Keep the default values and click Next.

imported>David.moore at 18:57, 25 November 2013

2013-11-25T18:57:26Z

← Older revision		Revision as of 18:57, 25 November 2013
Line 33:		Line 33:
	#Create a Sybase data archive file as outlined in the next section, Creating a Database.		#Create a Sybase data archive file as outlined in the next section, Creating a Database.
	#Place the data archive file in a directory under the main Sybase directory, for example: sybase home directory/SYBSsa8/		#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:
			#Launch Sybase Central 4.0. In Windows, this is launched from the Start menu by selecting Programs→SQL Anywhere 8→Sybase Central.
			#On the Sybase Central screen, select Tools→Adaptive Server Anywhere 8→Create Database.
			#The Choose a Connection window opens. Select Connection created by a local engine and click Next.
			#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.

			{{Warning\|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.}}

			#On the main window, click Next. The Choose the Transaction Log Options window displays. Keep the default values and click Next.
			#The Mirror the Transaction Log window opens. Accept the default values and click Next.
			#The Java in the Database window is displayed. Ensure that both check boxes are checked. Click Next.
			#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.
			#The Which Page Size do you Want the Database to use window appears. Keep the default values and click Next.
			#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.
			#Click Finish. A database is created in the directory specified, with the parameters set. You are returned to the main Sybase Central screen.

imported>David.moore at 17:49, 25 November 2013

2013-11-25T17:49:37Z

← Older revision		Revision as of 17:49, 25 November 2013
Line 13:		Line 13:
	#Locate the file jconn3.jar within the jConnect zip file.		#Locate the file jconn3.jar within the jConnect zip file.
	#Extract the file jconn3.jar and place it in the folder PORTAL_HOME/classes-custom/		#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:

			#Copy or unzip the Sybase installation files to a temporary folder.
			#Go the temporary folder where the installation files were unzipped and run setup.exe. The Welcome window opens. Click Next.
			#After reading the license agreement terms, click Yes to proceed with the installation.
			#On the Select Components window, select only the following components:
			##Under the Databases node, select Adaptive Server Anywhere for Windows.
			##Under the Synchronization node, select SQL Remote for Adaptive Server Anywhere.
			#Click Next. The Choose SQL Anywhere 8 Location window opens.
			#Specify the directory where SQLAnywhere 8 should be installed and click Next. The Choose Shared Components Location window opens.
			#Specify the directory where shared components should be installed and click Next. The Select Program Folder window opens.
			#Click Next unless you want to change the name of the program folder.
			#On the Server License window, enter the appropriate details.
			#The Start Copying Files window opens. Review your prior selections. Click Next if all items are correct or Back to change any information.
			#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.
			#Create a Sybase data archive file as outlined in the next section, Creating a Database.
			#Place the data archive file in a directory under the main Sybase directory, for example: sybase home directory/SYBSsa8/

imported>David.moore: Created page with '{{DISPLAYTITLE:Sybase SQL Anywhere}} This section describes the tasks that you must perform to use SQL Anywhere with enPortal: === Downloading the Sybase JDBC Driver === After…'

2013-11-25T17:44:33Z

Created page with '{{DISPLAYTITLE:Sybase SQL Anywhere}} This section describes the tasks that you must perform to use SQL Anywhere with enPortal: === Downloading the Sybase JDBC Driver === After…'

New page

{{DISPLAYTITLE:Sybase SQL Anywhere}}

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:

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