How to Access a SQL Anywhere Database with ColdFusion
In this article, you will learn about connecting from the ColdFusion MX 6.1 Server to a SQL Anywhere 9 database. This technique can be useful in a variety of applications, for example when a traveling salesman keeps some data from a database on a PDA or a laptop computer and periodically reconnects to the main database for updates.
How to Access a SQL Anywhere Database with ColdFusion - Create a Data Source, a DSN (Page 2 of 4 )
In this step you will create a ODBC datasource, more specifically a System DSN. Adaptive Server Anywhere 9.0 has drivers that install on your hard drive when you install SQL Anywhere 9. These will be available through the windows ODBC Data Source Administrator wizard shown in Fig.2 that can be accessed from Start-->Control Panel-->Administrative Tools-->Data Sources (ODBC). You may also use the menu item in SQL Anywhere studio to create this data source which is shown in Fig.3 that follows. This will in turn kick up the windows ODBC Data Source Administrator (the same one shown in Fig.2). The ColdAny ODBC connection is shown in the administrative panel in Fig.2.