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
