Check the case of the FILENAME for Application.cfm - make sure it has a capital "A" - it apparently makes a difference on unix type machines.
Rick Jason T. Slack wrote: > I am evaluating Blue Dragon for OS X since I am invested in CF (new > to it, but making the investment) and CF 7 does not run on Intel macs. > > I moved over an application that works on CF Server to Blue Dragon > install on my Powerbook. > > I setup a DSN called webPOS using the Blue Dragon Administrator > (MySQL 5). I also downloaded and followed the instructions for > Connector/J and Blue Dragon to talk nicely. > > When I try to run a CFQUERY I get: > > application.dsn doesn't exist. > > 1: > 2: <!--- Check Locations table first to see if the location id and > password is right---> > 3: <cfquery name="ckCreds" datasource="#application.dsn#"> > 4: SELECT LocationID, LocationName FROM Locations > 5: WHERE LocationID = <Cfqueryparam cfsqltype="cf_sql_varchar" > > ^ Snippet from underlying CFML source > > even though in my application.cfc i have the following: > > <cffunction name="onApplicationStart" returnType="boolean" > output="false"> > <!--- When did the application start? ---> > <cfset APPLICATION.appStarted = now()> > > <cfset application.dsn = "webPOS"> > > <cfreturn true> > </cffunction> > > Can you help me work through these issues? > > Thanks, > > -Jason > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260494 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
