November 6, 2019
ColdFusion Builder 2018 – Datasource ‘XXX’ could not be found.
Like
(0)
Comments
(1)
0
1
I installed ColdFusion 2018 on our Windows 2012 sandbox server with SQL Server 2012 Express installed. I am able to configure several datasources using the CFAdmin which shows OK as the status. But when I try using the connection in a cf page from CFBuilder, I get the error,
Datasource AP2 could not be found.
The error occurred in D:/ColdFusionBuilder2018/ColdFusion/cfusion/wwwroot/CFTest1/TestDB.cfm: line 3 | |
1 : // script 2 : <cfscript> 3 : myquery = QueryExecute('SELECT * FROM artists', [], {datasource = 'AP2'}); 4 : </cfscript> 5 : |
The datasource does exist and shows valid, also SQL Server is configured to allow TCP/IP connections:
Can anyone suggest what could be stopping the CF code from seeing the datasource? BTW, I am using a named server: “1029823-SANDBOXSQLEXPRESS” instead of the 127.0.0.1 as the Server in the configuration.
Thanks in advance for any help!