Ok folks, I'm bleary-eyed and burnt out on digging through all the links to try and find a (the??) solution to my OpenBD Datasource problem.
Anyway, here are the Server/App Server specifics: Server Environment - Open BlueDragon and Java Information - Open BlueDragon Product Version: 1.3 - Open BlueDragon Build Date: 2010-04-25 19:34:20 GMT - Operating System: Windows Server 2008 x86 (6.1) - Webserver: Windows IIS 7 - Application Server: Apache Tomcat/6.0.20 - Java Virtual Machine: Sun Microsystems Inc. 1.6.0_16 (JVM Properties) Open BlueDragon Admin Console and Admin API Information - Admin Console Version: 1.3 - Admin Console Build Date: Apr 25, 2010 8:07 AM - Admin API Version: 1.3 - Admin API Build Date: Apr 25, 2010 8:07 AM Just so you know, in the Admin Panel under Datasources, my database datasource verifies as fagancfdb without any problems. However, when I go to access my particular website/application I am developing in a web browser I get the following error: CFML Runtime Error General SQL Error Request /index.cfm File Trace C:/webwin/faganent/index.cfm | +-- C:/webwin/faganent/Application.cfc Type Database Function(s) OnApplicationStart (C:/webwin/faganent/Application.cfc, Line=25, Column=55) Detail The datasource fagancfbd could not be found or was invalid Extended Info javax.naming.NameNotFoundException: Name fagancfbd is not bound in this Context Tag Context CFFUNCTION (C:/webwin/faganent/Application.cfc, Line=25, Column=55) | +-- CFQUERY (C:/webwin/faganent/Application.cfc, Line=28, Column=9) Source 25: hint="Fires when the application is first created."> 26: <!--- Set Application Variables ---> 27: <cfset application.datasource = "fagancfbd"> 28: <cfquery name="getsitesettings" datasource="#application.datasource#"> 29: select sitesettings.keywords, ^ Snippet from underlying CFML source My issue is why is the datasource not being "found" in the application. As you can see, this in the Application.cfc where I have it. I've already looked at different websites trying to figure out what is going on from the OpenBD angle and even from the Tomcat/Java/ JNDI angle and my brain has hit its saturation point. So I am asking for a little help from some of the more experienced types who may have dealt with this error. I have a feeling that "not bound in this Context" may have something to do with it but I haven't found anything definitive enough to unscrew the problem. Oh yeah, once I figure it out or get the answer or suggestions from someone on here I will be blogging about it so someone else doesn't have to go down headache road when working with OpenBD in the same or similar environment as I am. Thanks, Tom -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon official manual: http://www.openbluedragon.org/manual/ Ready2Run CFML http://www.openbluedragon.org/openbdjam/ mailing list - http://groups.google.com/group/openbd?hl=en
