Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners

MS SQL Data Sync online Help

Prev Return to chapter overview Next

SQL Anywhere

To connect to an SQL Anywhere database with MS SQL Data Sync, specify the following connection options:

 

Host

The host name of the SQL Anywhere server.

 

Engine name

The name of a running database server to which you want to connect. Click the ellipsis button to scan your network for available SQL Anywhere servers.

 

Port number

The TCP/IP port to use (default value is 2638).

 

MS SQL Data Sync allows you to use integrated login (only for database servers running on Windows).  Otherwise, set the following server security options.

 

User name

The username used to connect to SQL Anywhere.

 

Password

The password for the user account on server.

 

Start database before connection

Starts a local database server (if available).

 

Stop database after last disconnect

Stops local database server when there are no more open non-HTTP connections.

 

 



Prev Return to chapter overview Next