Copyright: Version 7.0.1 Copyright © 2000 Sybase, Inc. All rights reserved.


SQL Anywhere Connections
Version 7.0.1

Document ID:  XXXXXX

June 2000


Copyright page
Copyright © 2000 Sybase, Inc. All rights reserved.

No part of this publication may be reproduced, transmitted, or translated in any form or by any means, electronic, mechanical, manual, optical, or otherwise, without the prior written permission of Sybase, Inc.

Sybase, SYBASE (logo), ADA Workbench, Adaptable Windowing Environment, Adaptive Component Architecture, Adaptive Server, Adaptive Server Anywhere, Adaptive Server Enterprise, Adaptive Server Enterprise Monitor, Adaptive Server Enterprise Replication, Adaptive Server Everywhere, Adaptive Server IQ, Adaptive Warehouse, AnswerBase, Anywhere Studio, Application Manager, AppModeler, APT-Build, APT-Edit, APT-Execute, APT-FORMS, APT-Library, APT-Translator, APT Workbench, ASEP, Backup Server, BayCam, Bit-Wise, Certified PowerBuilder Developer, Certified SYBASE Professional, Certified SYBASE Professional (logo), ClearConnect, Client Services, Client-Library, CodeBank, Cohesion, Column Design, ComponentPack, Connection Manager, CSP, Data Pipeline, Data Workbench, DataArchitect, Database Analyzer, DataExpress, DataServer, DataWindow, DB-Library, dbQueue, Developers Workbench, Direct Connect Anywhere, DirectConnect, Distribution Director, Dynamo, E-Anywhere, E-Whatever, Electronic Case Management, Embedded SQL, EMS, Enterprise Application Server, Enterprise Application Studio, Enterprise Client/Server, Enterprise Connect, Enterprise Data Studio, Enterprise Manager, Enterprise SQL Server Manager, Enterprise Work Architecture, Enterprise Work Designer, Enterprise Work Modeler, EWA, Financial Fusion, First Impression, Formula One, Gateway Manager, GeoPoint, ImpactNow, InfoMaker, Information Anywhere, Information Everywhere, InformationConnect, InstaHelp, Intellidex, InternetBuilder, iScript, Jaguar CTS, jConnect for JDBC, KnowledgeBase, Logical Memory Manager, MainframeConnect, Maintenance Express, MAP, MDI Access Server, MDI Database Gateway, media.splash, MetaWorks, MethodSet, MobiCATS, MySupport, Net-Gateway, Net-Library, NetImpact, Next Generation Learning, Next Generation Learning Studio, O DEVICE, OASiS, OASiS (logo), ObjectConnect, ObjectCycle, OmniConnect, OmniSQL Access Module, OmniSQL Toolkit, Open Client, Open Client/Server, Open Client/Server Interfaces, Open ClientConnect, Open Gateway, Open Server, Open ServerConnect, Open Solutions, Optima++, Partnerships that Work, PB-Gen, PC APT Execute, PC DB-Net, PC Net Library, PhysicalArchitect, Power Through Knowledge, Power++, power.stop, PowerAMC, PowerBuilder, PowerBuilder Foundation Class Library, PowerDesigner, PowerDimensions, PowerDynamo, PowerJ, PowerScript, PowerSite, PowerSocket, Powersoft, Powersoft Portfolio, Powersoft Professional, PowerStage, PowerStudio, PowerTips, PowerWare Desktop, PowerWare Enterprise, ProcessAnalyst, Relational Beans, Replication Agent, Replication Driver, Replication Server, Replication Server Manager, Replication Toolkit, Report Workbench, Report-Execute, Resource Manager, RW-DisplayLib, RW-Library, S-Designor, S Designor, SAFE, SAFE/PRO, SDF, Secure SQL Server, Secure SQL Toolset, Security Guardian, SKILS, smart.partners, smart.parts, smart.script, SQL Advantage, SQL Anywhere, SQL Anywhere Studio, SQL Code Checker, SQL Debug, SQL Edit, SQL Edit/TPU, SQL Everywhere, SQL Modeler, SQL Remote, SQL Server, SQL Server Manager, SQL Server SNMP SubAgent, SQL Server/CFT, SQL Server/DBM, SQL SMART, SQL Station, SQL Toolset, SQLJ, Startup.Com, STEP, SupportNow, Sybase Central, Sybase Client/Server Interfaces, Sybase Development Framework, Sybase Financial Server, Sybase Gateways, Sybase Learning Connection, Sybase SQL Desktop, Sybase SQL Lifecycle, Sybase SQL Workgroup, Sybase Synergy Program, Sybase User Workbench, Sybase Virtual Server Architecture, Sybase MPP, SybaseWare, Syber Financial, SyberAssist, SyBooks, System XI (logo), System 10, System 11, SystemTools, Tabular Data Stream, The Enterprise Client/Server Company, The Extensible Software Platform, The Future Is Wide Open, The Learning Connection, The Model For Client/Server Solutions, The Online Information Center, Transact-SQL, Translation Toolkit, Turning Imagination Into Reality, UltraLite, UNIBOM, Unilib, Uninull, Unisep, Unistring, URK Runtime Kit for UniCode, Viewer, Visual Components, VisualSpeller, VisualWriter, VQL, Warehouse Control Center, Warehouse Studio, Warehouse WORKS, WarehouseArchitect, Watcom, Watcom SQL Server, Watcom SQL, Web.PB, Web.SQL, Web Deployment Kit, WebSights, WebViewer, WorkGroup SQL Server, XA-Library, XA-Server, and XP Server are trademarks of Sybase, Inc. or its subsidiaries.

All other trademarks are property of their respective owners.

Last modified: June 2000. Part Number: XXXXXX.


About This Manual


About This Help File
Subject

This help file provides context-sensitive information for ODBC data sources, connections, and the dbmlsync utility for MobiLink clients.

Audience

This help file is for anybody connecting to an Adaptive Server Anywhere database.


CHAPTER 1.  Connections and the ODBC Administrator
About this help file

This help file provides context sensitive help for creating connections as well as the ODBC Administrator that is provided with Adaptive Server Anywhere. This context sensitive help will be used with Windows 95 and Windows NT applications.


ODBC tab
This tab is displayed only when creating or modifying ODBC data sources.

Delphi applications    Check this box to improve performance for Borland Delphi applications.

Prevent driver not capable errors    The Adaptive Server Anywhere ODBC driver returns a Driver not capable error code because it does not support qualifiers. Some ODBC applications do not handle this error properly. Check this box to disable this error code, allowing such applications to work.

Delay AutoCommit until statement close    Check this box if you wish the Adaptive Server Anywhere ODBC driver to delay the commit operation until a statement has been closed.

Describe cursor behavior    Select how often you wish a cursor to be re-described when a procedure is executed or resumed.

Test Connection    Tests if the information provided will result in a proper connection. In order for the test to work a user ID and password must have been specified.


Data source name
Enter a name to identify this ODBC data source.

You can use any descriptive name for the data source (spaces are allowed) but it is recommended that you keep the name short, as you may need to enter it in connection strings.


Data source description
You can enter a description of the Data Source. This description may help you or your end users to identify this data source from among their list of available data sources.

This is an optional field.


Translator
Click Select and choose the Adaptive Server Anywhere Translator if your database uses an OEM code page.

If your database uses an ANSI code page, which is the default, do not select a translator. A translator is not required for most English language databases.


Browse
Click the select button to choose the ODBC translator you require from a list of installed translators.


Isolation level
Enter a numerical value to specify the initial isolation level for this data source:

•	0    This is also called the read uncommited isolation level. This is the default isolation level. It provides the maximum level of concurrency, but dirty reads, non-repeatable reads and phantom rows may be observed in result sets.

•	1    This is also called the read committed level. This provides less concurrency than level 0, but eliminates some of the inconsistencies in result sets at level 0. Non-repeatable rows and phantom rows may occur, but dirty reads are prevented.

•	2    This is also called the repeatable read level. Phantom rows may occur. Dirty reads and non-repeatable rows are prevented.

•	3    This is also called the serializable level. This provides the least concurrency, and is the strictest level. Dirty reads, non-repeatable reads and phantom rows are prevented.

See the Adaptive Server Anywhere documentation for further details on isolation levels and transaction processing.


Microsoft applications
Check this box if you wish foreign keys to be returned by SQL statistics. The ODBC specification actually states that primary and foreign keys should not be returned by SQL statistics, however, some Microsoft applications (such as Visual Basic and Access) assume that primary and foreign keys are returned by SQL statistics.


Delphi applications
Check this box if you will be using the data source from applications developed with the Borland Delphi application development tool.

When this option is checked, one bookmark value is assigned to each row, instead of the two that are otherwise assigned (one for fetching forwards and a different one for fetching backwards).

Delphi cannot handle multiple bookmark values for a row. If the option is unchecked, scrollable cursor performance can suffer since scrolling must always take place from the beginning of the cursor to the row requested in order to get the correct bookmark value.


Prevent Driver Not Capable errors
The Adaptive Server Anywhere ODBC driver returns a Driver not capable error code because it does not support qualifiers. Some ODBC applications do not handle this error properly. Check this box to prevent this error code from being returned, allowing these applications to work.


Delay autocommit until statement close
Check this box to delay the commit operation until a statement has been closed.


Describe Cursor behavior
Select how often you wish a cursor to be re-described when a procedure is executed or resumed.


Test connection
Tests if the information provided will result in a proper connection. In order for the test to work a user User ID and password must have been specified.


odbc connection profile
The name of the connection profile the Data Source will use to connect with.


Login tab
This tab provides fields related to user authentication and login.


Use integrated login
Select this option to connect using an integrated login.

If you select this option, the user ID and password do not need to be specified: instead, their operating system user ID and password are supplied to the Adaptive Server Anywhere integrated login mechanism.

To use integrated logins users must have been granted integrated login permission. The database being connected to must also be set up to accept integrated logins. Only users with DBA access may administer integrated login permissions.


User ID
Enter the User ID for the connection.


Password
Enter the password for the connection.


Encrypt password
Check this box if you wish the password to be stored in encrypted form in the profile.


Select ODBC data source
Choose the ODBC Data Source to which you want to connect.

If you choose an ODBC data source, you cannot choose an ODBC data source file. Set the ODBC data source name to <NONE> if you wish to specify a data source file.


Select ODBC data source file
Enter the ODBC data source file you wish to use. ODBC data source name and ODBC data source file parameters are mutually exclusive. Consequently, you may only specify one or the other.


Database tab
This tab provides fields for identifying the database server and database to which you are connecting.


Server name
Enter the name of the Adaptive Server Anywhere personal or network server.


Database name
Enter the name of the Adaptive Server Anywhere database that you wish to connect to.


Database file
Enter the full path and name of the Adaptive Server Anywhere database file on the server PC.

You may also click Browse to locate the file.


Browse button
Click the browse button to choose the file from your file directory.


Starting agent
Select the agent that you would like to connect to. You may select network server, the network server or any of the above. The default setting is Any.


Automatically start the database
Select this to automatically start the database if it is not found at the time of connection. This option is only enabled when a database file or a start line has been provided.


Automatically shut down database
Check this box to shut down the database once this connection is terminated regardless of other connections.


connection profile starting connection name
The name of the connection that is being created.


Start line
Enter the path of the server. Only provide a Start Line parameter if a database server is being connected to that is not currently running. For example:

C:\Program Files\Sybase\SQL Anywhere 7\win32\dbeng7.exe -c 8m


connection profile starting auto stop
Selecting this will cause the server to shut down automatically after the last user has disconnected.


Network tab
This tab provides fields for controlling client/server communications over a network.


Buffer size
Set the maximum size of communication packets, in bytes. The default is 1024 bytes.


Buffer space
Indicates the amount of space to allocate on startup for network buffers, in kilobytes. The default value is 10.


Network protocol
Select the network protocol that you would like to use for the connection. In the adjacent boxes, you may enter communication parameters that establish and tune connections from your client application to a database.


Network liveness
A liveness packet is sent across a client/server to confirm that a connection is intact. If the client runs for the liveness timeout period without detecting a liveness packet, the communication will be severed.  This parameters will only work with network server and TCP/IP or IPX communication protocols. The default is 120 seconds.


Network encryption
Enables encryption of packets transmitted from the client machine over the network.


Advanced tab
This tab provides advanced fields that are for special purposes, and not required by the majority of users.


Connection name
Enter a name to identify the connection here.

This is an optional field.


Character set
Enter a character set name. The ANSI character set is used by Microsoft Windows. An OEM character set is any character set except the ANSI character set.


Connection parameters
Enter parameters to establish connections from your client application to a database. For more information see Chapter 3 (Connection and Communication Parameters) in the Adaptive Server Anywhere Reference Guide.

This is an optional field.


Record fetching
Check this box to enable multiple records to be retrieved at one time instead of individually for improved performance.


Debug
Check this box to provide diagnostic information on communications links.


Debug file name
The name of the file in which the debugging information is to be saved.


Additional switches
Enter any additional switches here. Parameters set throughout the remainder of this dialog take precedence over parameters typed here. See the Adaptive Server Anywhere documentation for information on available switches.


DBMLSync tab
This tab displays options for the dbmlsync Adaptive Server Anywhere client synchronization utility.


Publication
Enter the name of the synchronization definition that is to be synchronized.

If there is only one synchronization definition in your database, you do not need to enter anything in this field.


ML Password
Enter the MobiLink password for user authentication.

If you have not entered a password, you must enter one here. If you are being prompted for a password, this is likely to be the only field you need to complete.


Change password
Check this box to change the MobiLink password when synchronization occurs.

Unless you are changing the MobiLink password, leave this field blank.


New password
When changing MobiLink password, enter the new password.

Unless you are changing the MobiLink password, leave this field blank.


Verify password
When changing MobiLink password, enter the new password again for verification.

Unless you are changing the MobiLink password, leave this field blank.


Extended options
Supply extended options to customize synchronization. You can supply schedule specifications, stream compression values, and other extended options. For a complete list, see the MobiLink documentation.

This field is optional.


Site script
Enter the name of a script to be executed.

This field is optional.


Browse
Click this button to locate the site script.


Retry on remote progress
If the consolidated and client databases have different information about the last synchronization, you can select this option to retry the upload operation.

By default, uploads continue from the offset recorded by the consolidated database. If you select Retry on Remote Progress, the upload continues from the offset recorded in the client database as long as the offset recorded in the consolidated database is ahead of that at the client database.

If, in addition, you use Remote is Ahead, the upload is retried starting from the offset recorded in the client database even if the offset recorded in the client database is ahead of that recorded in the consolidated database. This option should be used with care. If the offset mismatch is the result of a restore of the consolidated database, changes that happened in the client database in the gap between the two recorded offsets are lost. The Remote is Ahead option may be useful when the client database transaction log has been truncated after the last successful synchronization.


Verbose operation
Provide debugging and other diagnostic information in a log file.

This field is optional.


Drop conflicting connections
Synchronization requires access to all rows on the tables to be synchronized. Choose this option to force connections with locks on these tables to be dropped.

This field is optional.


Cmdline help
Each of the options on the dbmlsync tab have an equivalent command-line option. This button displays the dbmlsync usage text, to provide further assistance.