I've been wrestling with a problem for a few days, and after trying to Google the answer, I need to pose the question.
I would like to create a new datasource for use by an application I'm working on. However, I do not have administrator access to my ColdFusion server, and working for a large institution, I have to go through various hoops to get a request to add a datasource at the server level through. The reason I need to do this is because I have one application on server A (the in-house one) and one on server B (a third-party host). The one on server A needs to pass some info to the one on server B. The way I am trying to go about it is by writing a simple query that runs when the page is called. However, simply pointing to the location of the db (ie. "dbname.db.0000000.thisdbhost.com") doesn't work. I've found info on setting up datasources in the Application.cfc file, but this doesn't seem to work either. I have a feeling I may be going about this wrong, but in digging around I haven't found any good leads.
The other options would be to rewrite the application in server A in PHP and move it over to server B (which I don't have time to do), or pay my web host the extra amount for ColdFusion hosting (which will take approval I'm not sure I have time to wait for).