Web App Not Retrieving Data from Database


I have a web app.  The code is working fine.  I had the app on one server and the database on another.  I then moved the code to a different server.  The page renders, however, I am not viewing the same data.  Is there something I need to do specifically to connect to the server with db?  Not sure what to do and looking for guidance. I tried the dbserver tag in the cfquery, but it seems that it has been deprecated.  Any suggestions?
Who is Participating?
You need to configure the database connection in the Coldfusion Administrator.


In the "Data Sources" section - This is where you configure database connections for when you perform queries with the cfquery tag. You create a datasource and map it to a database. You can supply extra information if required such as username/passwords etc.
Not all hosts support remote database connectivity, meaning that the site files and database must be hosted by the same organization in order to communicate. If this is the case, then you need to recreate your database somewhere where you can connect to it and change your connection string to point to the new server.
   > The page renders, however, I am not viewing the same data

Are you seeing different data than you expected OR nothing at all? Are you getting an error message?
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

armanbenaAuthor Commented:
No, there's no error.  When I do a search, and originally data was being returned, now it shows no records found.
First I'd check whether the problem is the data OR the query.   Run a SELECT * FROM tableName (no WHERE filters) Does it return the data you were expecting to see? If yes, it might be a problem with the cfquery filters.
> No, there's no error.  

So what ended up being the problem? If there wasn't a datasource configured you'd definitely get an error.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.