Blaise
Blaise

Reputation: 22242

Location of Coldfusion connection string settings

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

Answers (2)

Jock Mahon
Jock Mahon

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

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

Related Questions