How Do I Create A ColdFusion DSN For My Access Database?

To use ColdFusion to connect to an Access database, you must create a ColdFusion DSN.

To Create a ColdFusion DSN for an Access Database

Log in to your Account Manager.
Under the Hosting & Email section, select Hosting Account List.
Next to the hosting account you want to modify, click Open.
Under the Databases section of your Hosting Manager, click on the Access icon.
NOTE: You may need to enable Access support for your Windows hosting account before you can create a ColdFusion DSN.
Click Create New DSN.
Under the Database File Information section, type in the name of your Access database.
For the DSN type, select ColdFusion.
Under the Connection Information section, enter your User Name and Password for your Access database.
Click Continue
If everything looks OK, click Create DSN to create a ColdFusion DSN for your Access database.

Rated:NR/0 Votes 303 Views	More Articles From ColdFusion	Print
	Share \|

Comments, Questions & Reviews

Comments is currently disabled for this article!

Setting Up an Access Database for Your Web Site

Our Windows hosting accounts allow you to set up Access database support. Using the Hosting Manager, you can automatically create ...

What is an Access Database?

An Access database is a relational database contained in a single file that you can upload to a directory on ...

Connecting to an Access Database Using ASP or ADO

This example describes using ASP/ADO to connect to an Access Database. <%Dim oConn, oRsDim qry, connectstrDim db_pathDim db_dirdb_dir = Server.MapPath("access_db")db_path = ...

Connecting to an Access Database Using File DSN and ASP or ADO

This example describes using File DSN and ASP/ADO to connect to an Access Database. <%Dim oConn, oRsDim qry, connectstr, sDSNDirDim db_name, ...

Importing Data From MS Access to MS SQL

Currently, this procedure is not supported. However, there are methods to migrate Access information to an SQL database. Please consult ...

The information provided in this article is for general information and/or the comments is the sole responsibility of their respective authors and does not necessarily reflect the opinion of zeronese.net does not endorse any article and/or comments published by our web users unless otherwise noted.