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.

Fig. 2


Fig. 3
 

Next: Drivers in ColdFusion >>
 

More ColdFusion Articles
More By Jayaram Krishnaswamy

Comments On: How to Access a SQL Anywhere Database with ColdFusion

· Whether to land a new job, or even to find a suitable girl friend what matters most...   >>> Post your comment now!