Home arrow ColdFusion arrow Querying SQL 2000 Server from ColdFusion

Querying SQL 2000 Server from ColdFusion

Following a brief explanation about the database drivers and the application environment in which the ColdFusion MX Server is installed, this tutorial describes a step-by-step method of creating a ColdFusion data source from the administrative panel of a ColdFusion MX 6.1 Server which derives its data from a MS SQL 2000 server. The tutorial then describes a ColdFusion application for running a database query against this data source.

Author Info:
By: Jayaram Krishnaswamy
Rating: 5 stars5 stars5 stars5 stars5 stars / 4
February 07, 2006
  1. · Querying SQL 2000 Server from ColdFusion
  2. · Using ColdFusion data sources to connect to SQL Server 2000
  3. · Querying pubs database with a ColdFusion query
  4. · Modifying the query and improving the display

print this article

Querying SQL 2000 Server from ColdFusion
(Page 1 of 4 )

Database Connectivity

If queries to a database on the SQL2000 server have to be run, the very first thing that is needed is database connectivity. The environment in which the application is run is also very important. Most of the previous tutorials on ColdFusion by this author were run on the Windows platform (specifically Windows XP Professional) and the database tutorials assume you are using the Windows XP Professional Operating System and IIS.  ColdFusion uses JDBC drivers to interact with databases. Additionally it uses the DataDirect SequeLink Software (instead of DataDirect Connect) to connect databases, possibly because it allows interaction with a larger number of database products.

When ColdFusion MX 6.1 is implemented for Internet Information Server by installing it on a Windows platform, basically three services are added. These are shown in the next picture.  The application server is needed to run any ColdFusion application. The ODBC Server and Agent are needed for database connectivity. These can be set to start automatically, or they can be started manually by accessing the start link from Start -> Control Panel->Administrative Tools->Services. The ODBC server is used for ColdFusion MX DataDirect drivers for Microsoft Access and ODBC Socket, and the Agent is used for ColdFusion MX ODBC Server. The MS SQL 2000 Server connects through a Type4 JDBC Driver similar to Oracle, DB2 and Informix.


blog comments powered by Disqus

- 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 

Developer Shed Affiliates


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