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:326297 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
