How to use Sybase SQL Anywhere ODBC Driver

This article explains how Sybase SQL Anywhere ODBC driver is used
  • 3905

Introduction :

SQL Anywhere is initially created by Watcom as Watcom SQL. It is used in several contexts, including as an embbeded database, particularly as an application data store. It is used in Intuit QuickBooks , in network management products, and in backup products. Its ability to be used with minimal administration is a distinguishing feature in this role. It can be used as a database server for work groups or for small or medium-sized businesses. It can also function as a mobile database. It includes scalable data synchronization technology that provides change-based replication between separate databases, including large server-based RDBMS systems.

Connection used to connect with Sybase SQL Anywhere ODBC Driver is

ODBC;Driver=Sybase SQL Anywhere 5.0;DefaultDir=c:\dbfolder\;Dbf=c:\database_name.db; Uid=user_name;Pwd=password;Dsn="";

Note : An empty DSN parameter is needed if user is not included an empty DSN parameter this will result as a error 7778.

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.