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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
   > 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?
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ColdFusion Language

From novice to tech pro — start learning today.