Sounds like a question for the CrystalTech support guys. I've been
using CrystalTech for years and have never run into any problems with
datasources.
Thanks,
Eric Cobb
http://www.cfgears.com
Joshua Rowe wrote:
Hello there! I have a website that is being hosted through CrystalTech and
am running into an issue with assigning a datasource through their control
panel. From what I've seen in the past, you assign a datasource name with a
userid and password and then associate whatever MySQL database you have with
that datasource by it's userid. However, in the CrystalTech control panel,
you create a MySQL database with up to three userids and passwords, then
create a datasource (without inputting a userid and password) and link it to
the database you have created.
Once I have done this, I run a query on one of the tables with a cfquery
tag and input the datasource, username, and password attributes into that
tag. I get the following error message when I run the page:
Datasource datasource_name could not be found.
The connection string I receive for this datasource in the CrystalTech
control panel is this:
dsn=datasource_name;uid=;password=
the userid and password variables are empty. When I remove the username and
password attributes from the cfquery tag or assign them empty values
(example: username= password=), I receive the same error message as above.
If I run a query test in the CrystalTech control panel, the results from the
table return fine.
Is there a special way to call a datasource from CrystalTech in ColdFusion 8?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326310
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4