%META:TOPICPARENT{name="ConfigTroubleshootASA"}%
How do I create a JDBC Type 3 URL to connect to Sybase ASA?    %BR%

Sybase Type 3 JDBC connection URLs take the following form: %BR%
%BR%
{{{
jdbc:openlink://<Hostname>:[portnumber] [/UID] [/PWD] [/READONLY] [/SVT]
		[/APPLICATION] [/FBS|FETCHBUFFERSIZE] [/ENCRYPTED] [/CHARSET] [/UNICODE]
		[/DLF] [/DATABASE] [/OPTIONS] [/DRIVER] 
}}}
%BR%
Here is a description of each of the parameters: %BR%
%BR%
	* Hostname - Network Alias or IP address of machine that runs an <nop>OpenLink Request Broker instance. %BR%
	%BR%
	* Port Number - TCP port on which the Request Broker listens. %BR%
	%BR%
	* /UID - Sybase database username. %BR%
	%BR%
	* /PWD - Sybase database password. %BR%	
	%BR%
	* /READONLY - Read-write or read-only session mode. %BR%
	%BR%
	* /SVT - A valid domain alias from the [Domain Aliases] section of the <nop>OpenLink server component's oplrqb.ini file. The default domain alias is "Sybase". Custom aliases may take any form.%BR%
	%BR%
	* /APPLICATION - The Application name. Enables connectivity when restrictive server side rules screen by application name. %BR%
	%BR%
	* /FBS - (also FETCHBUFFERSIZE) The Fetch Buffer Size. The Fetch Buffer Size is an integer that represents the number of rows to return during one fetch operation.. %BR%
	%BR%
	* /ENCRYPTED - Sets the Encrypted flag for outgoing packets. /ENCRYPTED may pass '1', '0', 'Y', 'N', 'y', or 'n.' (This feature is disabled by default.) %BR%
	%BR%
	* /CHARSET - Specifies the charset of remote databases. The default value is read from System.getProperty("file.encoding"). %BR%
	%BR%
	* /UNICODE - Instantiates unicode. The unicode connection isn't used by default. The value may be '1', '0', 'Y', 'N', 'y', 'n'(This feature is disabled by default.)  %BR%
	%BR%
	* /DLF - Pushes large, binary objects to the end of the resultset. Smaller data types are retrieved first. This enhances performance. /DLF may be set to '1', '0', 'Y', 'N', 'y', or 'n.' (This feature is disabled by default.) %BR%
	%BR%
	* /DATABASE - Actual Sybase database name within a particular database environment. %BR%
	%BR%
	* /OPTIONS - Passes -S <i>Sybase instance name</i> -H <i>IP address or hostname of database server</i> -P <i>Sybase TCP port</i> -V <i>TDS version which defaults to 5.0</i>. For example: -S SYBASE -H 192.75.12.213 -P 1433 -V 8.0%BR%
	%BR%
	* /DRIVER - The Driver name contained in curly brackets ({}). Used for DSN-Less connections to remote ODBC Drivers. %BR%
%BR%
Here are some sample Sybase Type 3 connection URLs: %BR%
%BR%
{{{

jdbc:openlink://localhost:5000/SVT=Sybase/DATABASE=pubs/OPTIONS=-S SYBASE -H 192.75.12.213 -P 4100 -V 5.0/UID=sa/PWD=sa

jdbc:openlink://192.75.12.213:5000/SVT=Sybase/DATABASE=pubs2/OPTIONS=-S SYBASE -H 192.75.12.213 -P 4200 -V 5.0/UID=sa/PWD=dba

jdbc:openlink://saturn/SVT=Sybase/DATABASE=master/OPTIONS=-S SYBASE -H 192.75.12.213 -P 4100 -V 5.0/UID=sa/PWD=
)))