ColdFusion 6.1 and MySQL 4.1 Database

[bob_mould]

Hello: I have a workstation running the developer edition of ColdFusion 6.1 and
MySQL 4.1, I also have a blade server running the Standard Edition of
ColdFusion 6.1 and MySQL 4.1. On the blade server I have a database with a few
tables populated with data. Via the ColdFusion Admin. on my workstation, I am
able to connect to the blade server and make a data connection to the MySQL
database. From Dreamweaver, I can see the datasource, make a record set, and
it tests just fine. I build the page test it, all the records show, so far so
good. I then upload the file to the blade server and preview it and I get the
following error: Error Executing Database Query. Data source not found. I am
a little puzzled considering the datasource I am using is on the blade server.
Any insights? Thanks

[cf_menace]

Your MySQL _database_ is on the Blade Server.

Your workstation's CF Admin has a datasource defined to connect to your MySQL
database.

Your Blade server's CF Admin _does not_ have that same datasource defined.

[bob_mould]

Thanks for the replay, cf_menace. I just checked, the datasources are both
defined through the admin on the workstation and the blade server. I am still
getting the same error. The blade server is running Windows 2003 server, is
there something that I have to tweak on that server? Is it a windows setting of
some kind? Maybe a firewall thing? Or could it be how I am developing the
site, what I mean is, I have ColdFusion 6.1 running on my workstation. I am
building the pages locally, testing locally, and then uploading to the
production (blade) server. Should I remove ColdFusion Server from the
workstation all together and work directly on the blade server? Just
reaching... The is no emoticon for what I am feeling.

[bob_mould]

Hi cf_menace: I solved the problem, turns out that I had a space in the
datasource name on the blade server, so the names were not exact. Everything is
working just fine. Thanks for your help, much appreciated.