To properly configure ODBC to connect to Sybase SQL Anywhere open Server

Specific steps:

A. On the server side to

dbsrv7.exe path\yyy.db -n
ServiceName -x tcpip -q

Start the database, you can also specify the port, detailed parameters, please use Dbsrv7.exe/? get.

-N ServiceName: Starts the database service named ServiceName to mark the Network database service unique token;

-X TCPIP: Using the TCP/IP protocol, default port 3362, be careful not to be occupied;

-Q background operation, no database running interface, can only see the process;

Two. After the successful start-up, another machine operation:odbc-> a new adaptive SQL Anywhere7.0 data source, configured as follows:

1.odbc->dns Name: Data source Names

2.login-> Login User/password

3.database-> ServerName Enter the servicename specified in step one

4.Network-> The TCP/IP in the hook, the parameter enters the IP of the machine in which the server is started, the format is as follows: host=192.168.0.1 Other protocols can be selected.

Repeat the 3rd step, you can configure multiple clients, of course, the server can also configure an ODBC to connect to their own.