I have been trying since 10am on MONDAY to have a datasource created on my account by jodohost's support staff. First it was pointed at the wrong database, then after various delays, it was supposedly created, but yet any attempt to access it results in the following error:
---
Error Executing Database Query.
ERROR: Could not locate datasourcename. This usually means that the jrun-resources file does not contain configuration data for this database or pool
---
Currently the support team is trying to convince me that the problem is in the code, which I know for a fact it is not. To begin with, the code and database are a direct copy of a client's site, also hosted on Jodohost, that work perfectly on his account. Furthermore, I've created a test file, which includes nothing but the follow code:
<CFQUERY NAME="getCategories" DATASOURCE="datasourcename">
SELECT *
FROM ProductCategories
</CFQUERY>
<CFOUTPUT QUERY="getCategories">
#getCategories.CatName#<br>
</CFOUTPUT>
This code results in the same exact error described above.
I am at a loss. As I said, I've been trying to get this datasource set up since Monday morning. It's now almost Friday.
Trouble ticket number is 33724.
-laurie
---
Error Executing Database Query.
ERROR: Could not locate datasourcename. This usually means that the jrun-resources file does not contain configuration data for this database or pool
---
Currently the support team is trying to convince me that the problem is in the code, which I know for a fact it is not. To begin with, the code and database are a direct copy of a client's site, also hosted on Jodohost, that work perfectly on his account. Furthermore, I've created a test file, which includes nothing but the follow code:
<CFQUERY NAME="getCategories" DATASOURCE="datasourcename">
SELECT *
FROM ProductCategories
</CFQUERY>
<CFOUTPUT QUERY="getCategories">
#getCategories.CatName#<br>
</CFOUTPUT>
This code results in the same exact error described above.
I am at a loss. As I said, I've been trying to get this datasource set up since Monday morning. It's now almost Friday.
Trouble ticket number is 33724.
-laurie