Home arrow ColdFusion arrow Page 2 - How to Access a SQL Anywhere Database with ColdFusion
COLDFUSION

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.

Author Info:
By: Jayaram Krishnaswamy
Rating: 5 stars5 stars5 stars5 stars5 stars / 17
April 10, 2006
TABLE OF CONTENTS:
  1. · How to Access a SQL Anywhere Database with ColdFusion
  2. · Create a Data Source, a DSN
  3. · Drivers in ColdFusion
  4. · Create and verify a test query in SQL Anywhere

print this article
SEARCH DEVARTICLES

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
 


blog comments powered by Disqus
COLDFUSION ARTICLES

- Adobe ColdFusion Just Got More RAD
- How to Access a SQL Anywhere Database with C...
- CFXML: Probing XMLDOM in ColdFusion
- Creating a Web Service with ColdFusion: the ...
- CFAjax: What it is and How to Use it
- Querying SQL 2000 Server from ColdFusion
- Introduction to ColdFusion Markup Language, ...
- Introduction to ColdFusion Markup Language
- Databases and Dreamweaver MX 2004, concluded
- Databases and Dreamweaver MX 2004
- Welcome to Coldfusion MX 6.1, concluded
- Welcome to Coldfusion MX 6.1
- What You Must Know About ColdFusion Flow-Con...
- What You Must Know About Operators in ColdFu...
- Everything You Must Know About ColdFusion Va...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials