Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default DSN-less code?

    I am new to CF and am doing some hands on exercises on accessing an Access mdb
    file using CFML. I have had to first set up a Datasource in the CF
    Administrator before I can use <cfquery datasournce="db name">. Is there a way
    to have a DSN-less coding in CF like what you have in ASP, without having to
    set up the datasource in the Administrator? If so how is this done in
    ColdFusion? Thanks.

    wins1 Guest

  2. Similar Questions and Discussions

    1. Why doesn't the Code Completion occur in FlexBuilder IDEwhen source code is in an external file?
      I am seperating my .as from the MXML by using the following in my file.mxml: <mx:Script source="file.as"> When I edit file.as, the code...
    2. How would I include the Open Browser code into this lineof code?
      Hello and thankyou in advance: I have an ASP page linked to my database and I want to apply the Open Browser behaviour to the code. I have tried...
    3. Custom control fires event but ignores some code in the code behind file
      I do not quite understand the question. I will merely point out that most programming problems happen for a reason. Code works the way it is...
    4. Custom tool warning: DiscoCodeGenerator unable to initialize code generator. No code generated.
      I created a brand new WebService (HelloWorld) and when I attempt to add this WebService to a WindowsForm project I get the following error message in...
    5. Security problem with Managed Code calling Unmanaged Code in a Web Page
      Hello, I have a web page which contains an ActiveX control (unmanaged) and a Windows Forms User Control (managed). Both reside on a web page and...
  3. #2

    Default Re: DSN-less code?

    Assuming MX7, short answer is no. Long answer is you can create one
    on-the-fly, but it's not DSN-less. The DSN actually exists and can be seen
    from the Administrator. For interrogating DB's I've attached some code I use
    to continually overlay one I call dynDB. I suppose you could figure out how to
    Delete it afterwards, but still strictly-speaking it's not DSN-less.

    <!--- The gyrations here are insane.
    When we login to the administrator the security cookie will be
    changed and stop working. We have to temporarily change to a
    fake session, let administrator do it's thing and then change
    back. Fortunately none of the original Session values or
    Session cookies are lost with this method.
    --->
    <cfset varAppName = Application.applicationname>
    <cfset varDBFreeForm = Session.DBFreeForm>
    <CFAPPLICATION NAME="retain_real_app"
    SESSIONMANAGEMENT="Yes"
    loginstorage="cookie">
    <cfinvoke component="CFIDE.adminapi.administrator" method="login">
    <cfinvokeargument name="adminPassword" value="sappi"/>
    </cfinvoke>
    <cfinvoke component="CFIDE.adminapi.datasource" method="setMSAccessUnicode">
    <cfinvokeargument name="name" value="DynDB"/>
    <cfinvokeargument name="DatabaseFile" value="#varDBFreeForm#"/>
    <cfinvokeargument name="driver" value="MSAccessJet"/>
    <cfinvokeargument name="class" value="com.inzoom.jdbcado.Driver"/>
    <cfinvokeargument name="pooling" value="no"/>
    <cfinvokeargument name="username" value=""/>
    <cfinvokeargument name="password" value="">
    </cfinvoke>
    <cfinvoke component="CFIDE.adminapi.administrator" method="logout">
    </cfinvoke>
    <CFAPPLICATION NAME="#varAppName#"
    SESSIONMANAGEMENT="Yes"
    loginstorage="cookie">


    <CFQUERY NAME="GetListEntries" datasource="DynDB">
    SELECT Type,
    Flags,
    Name,
    CStr(DateUpdate) as strDateUpdate
    FROM MSysObjects
    WHERE Type <> 2 AND
    Type <> 3 AND
    Type <> 8 AND
    Type <> -32757 AND
    Type <> -32758 AND
    Left(Name,1) <> '~' AND
    Left(Name,4) <> 'MSys'
    ORDER BY #varSortBy#
    </CFQUERY>

    JMGibson3 Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139