Connection to Db without creating datasouce

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

  1. #1

    Default Connection to Db without creating datasouce

    I don't have access to the CF admin for a website I am creating some CF apps
    for. The cf server is Ver 4.5 and I can 't get access to the CF admin. Is
    there a way to set up a connection to the MySQL db without creating a
    datasource in the admin? Thanks.

    Frank

    frankpmjr2004 Guest

  2. Similar Questions and Discussions

    1. Backup CF datasouce
      Hi Friends Do you have any idea how I can backup my CF7 datasources and duplicate them on a diffrent server? I google it and I find one...
    2. MySQL datasouce error
      I have tried to get a datasource setup for MySQL but keep getting the dreaded 'are you sure there is a database at 127.0.0.1:3306' (sic) error. THe...
    3. How do I connect txt file using odbc datasouce ?
      Help! How can I create a datasouce on MX 6.1 linux to a txt file comma delimeter the old coldfusion it has MERANT Text Driver, but with this new...
    4. DataGrid & datasouce close
      Hello All, I have a webpage containing a DataGrid control. The datasource is a DataReader. The code is like so: AsaCommand Cmd = new...
    5. how to configure a informix datasouce in Websphere 5 with replication
      All, I'm trying to configure a datasource in Websphere 5 to a replicated infomix database .I'm using the JDBC Driver 2.21 JC4, But I can't find...
  3. #2

    Default Re: Connection to Db without creating datasouce

    <CFQUERY DBTYPE="dynamic" CONNECTSTRING="The connection string"
    NAME="QueryName">
    SELECT ..........
    </CFQUERY>

    Connection strings (use the proper depending your ODBC driver)

    ODBC 2.50 :

    "Driver={mySQL};Server=localhost;Option=16834;Data base=mydatabase;"


    ODBC 3.51 :

    "DRIVER={MySQL ODBC 3.51
    Driver};SERVER=localhost;DATABASE=myDatabase;USER= myUsername;PASSWORD=myPassword
    ;OPTION=3;"


    Sojovi Guest

  4. #3

    Default Re: Connection to Db without creating datasouce

    "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER= myUsername;PASSWORD=myPassword;OPTION=3;"
    Sojovi Guest

  5. #4

    Default Re: Connection to Db without creating datasouce

    "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER= myUsername;PASSWORD=myPassword;OPTION=3;"
    Sojovi Guest

  6. #5

    Default Re: Connection to Db without creating datasouce

    "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER= myUsername;
    PASSWORD=myPassword;OPTION=3;"
    Sojovi 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