Any chance of explaning how to get a mysql DB set up - I have been trying for ages and cant figure it out
By: Pablo Varando
Creating an ODBC Connection with ColdFusion Administrator.
This tutorial will guide you step by step on how to make an ODBC connection with your ColdFusion server administration area. Let's begin:
The first thing you need to do is to open the ColdFusion Administrator:
http://127.0.0.1/cfide/administrator/
That by default is the path, if you are running ColdFusion MX as stand alone, then in most cases by default it is:
http://127.0.0.1:8500/cfide/administrator/
OK, this will load the image you see below:
Once you have successfully logged in, you will
need to go into the Data Sources area of the administrator:
OK, to proceed you will have to know what type of database you will be using, in this example I will connect to an Access and to a SQL database, there are other types, for more information about those connection types, please refer to the documentation that came with the database you want to use. :)
The Access Way [If at all possible,
use SQL.. access is not a very good database to use on the web, but if you
cannot use SQL, then use Access :)].
Then click on the "Add" Button. This will bring you to the next
screen:
Now notice that you can also define other
settings, I've only showed you the bare minimum for you to successfully setup an
ODBC connection, for more information on the other settings, please ready he
help section of the ColdFusion Administrator Documentation.
Now let's see what you need to do to get a SQL
ODBC Connection going. You will need to know three things before proceeding:
1 - The IP/address to the SQL server.
2 - The database name in the SQL server you will be using.
3 - Your SQL username/password.
The SQL way. Let's begin:
Same as above, enter a desired datasource name and select Microsoft SQL server
from the drop down box. Then click on the "Add" button.
Then it will load this screen, click on the
"Show Advanced Settings" button first.
That will show the following screen:
Once again, notice that there are a lot of settings you can specify and I am just showing you the basics!
That's it, you now know how to create an ODBC Connection!
Questions? Comments? Email me.....
About This Tutorial
Author: Pablo Varando
Total Views: 68,493
Submission Date: January 06, 2003
Last Update Date: June 05, 2009
All Tutorials By This Autor: 47
Skill Level: Beginner
Platforms Tested: CF5Total Views: 68,493
Submission Date: January 06, 2003
Last Update Date: June 05, 2009
All Tutorials By This Autor: 47
Discuss This Tutorial
-
-
Is it possible to create a custom cfm page that's accessible via our intranet that allows you to create an ODBC connection to a SQL database outside of the administration panel? We run a CF MX 7 server on our production network (no outside connectivity) and it would be a great help if my DBA was able to pull up a page on the server (from his workstation) that would let him create ODBC's for new databases (saving me a lot of time, as we are constantly adding new DB servers). If you know of any way to pull this off, an email would be greatly appreciated. Thanks!
-
This excerpt of the Tutorial is informative enough, but more detailed instruction including that of beginners and the tutorials on how to write codes in Coldfusion is needed. Thanks a lot, Probe.
-
Hello, please help me in this issue i am suddenly having problem into my site and showing this error it was working fine before. I have created DSN and its mapped on that file. I dont know how to solve this issue. please help me i will be thankful. Error Diagnostic Information ODBC Error Code = IM002 (Data source not found and no default driver specified) [Microsoft][ODBC Driver Manager] Data source 'CFNUKE' not found and no default driver specified Hint: In order to use ODBC data sources with Cold Fusion you must create the data source using the Data Sources page of the Cold Fusion Administrator. In addition, if you are running under Windows NT you must make sure that the Data Source is created as a System DSN in order for it to be available to ColdFusion. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (39:3) to (39:53). Date/Time: 09/13/04 17:47:49 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
-
I have read and reviewed 4 different tutorials on the creation of a shopping cart with Macromedia and Cold Fusion but still found I didnt have a clue where to begin. Then I found this site and so far my confidence level is up because of the well laid out instructions. This tutorial is so far a 10 in my book. Thank You for being here. Sincerely, Brand New Developer Lisa
Advertisement
