ODBC/NETWORK CONNECTION PROTOTYPE FOR SQL ANYWHERE 16
- Download Sybase SQL Anywhere 16 from the link Sybase Sql Anywhere 16
- Install SQL Anywhere 16 with default settings, which installs Sybase Central
- Open Sybase Central from Start→ Programs → SQL Anywhere 16 → Sybase Central
- Connect to the SQL Anywhere server 16 Database from Sybase Central → Connections → Connect with SQL Anywhere 16 database
- Enter the Connection Details for the SQL Anywhere 16 database connection and click on Tools buttons Test connection
- The connection will open the connected database
- The default authentication details are user id:DBA Password:sql
- The Connection to the SQL Anywhere 16 is of different types
- Connect with an ODBC data source
- Download and install the SQL Anywhere 16 ODBC drivers and Create an ODBC connection with the database connection details
- Check the connection
- Connect to a Running Database on this computer
- Enter the Authentication details
- Select the Connect to a running database on this computer from Action list
- Run the Personal Server or Personal Server sample from the start→ SQL Anywhere 16 → SQL Anywhere → Personal Server / Personal Server sample
- Select the DB file path enter the server name and click on OK to start the local personal server with the selected database
- Now select the server Name and Database Name in the connect to SQL Anywhere 16 database window
- Check the connection
- Connect to a running database on another computer
- Enter the details of connection parameters
- The port is assigned by the Network server
- To connect to the database running on the another computer, we need to create and start the Network server like how personal server created with the selected database
- Connect to a running database in a cloud
- Enter the cloud connection details
- Open DPL/SSIS and create new connection with the ODBC connection to the SQL Anywhere 16
- Select the tables you want to import and export to SQL Server through export option.
FIREBIRD DATA CONNECTION PROTOTYPE