Reputation: 22242
This is new to me: I am looking into a ColdFusion website.
The problem is I cannot even find the connection string. In some qryXXX.cfm files, I find
<cfquery name="GetXXX" datasource="xxxx">
But I just cannot find where this datasource is stored.
Upvotes: 6
Views: 13798
Reputation: 126
in coldfusion 7 this file is called neo-query.xml and is stored, in a jrun install, at
C:\Apps\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib
the path may differ slightly depending on your install
Upvotes: 1
Reputation: 465
The datasource is defined in the ColdFusion Administrator.
On a default developer install the CF Administrator is available at:
http://localhost:8500/CFIDE/administrator/index.cfm
(On a server, it may or not be configured differently to this.)
Once logged in, on the left hand menu, go to section "Data & Services", and the first entry is "Data Sources", which is the area you want to go in.
Within this area, you will find a list of all defined datasources - the first icon in the Actions column lets you edit/view the details.
The actual data which the CF Administrator works with is stored in {coldfusion-dir}/lib/neo-datasource.xml
Upvotes: 27