Querying an External Database

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

  1. #1

    Default Querying an External Database

    I recently set up a website with a web host who supports Coldfusion. I created
    a backup of my MySQL database and they set up the database on their end, and
    sent me the database server name, database name, username, and password. Using
    the MySQL Administrator I was able to connect to the remote database. However,
    when I try to run my application on the site, it fails to find the database. I
    believe I need to define the Database Server (DBSERVER) and the other
    parameters needed to log onto the database server, but CFQUERY doesn't accept
    DBSERVER as an argument. Anyone have any ideas?

    bdewoody Guest

  2. Similar Questions and Discussions

    1. Querying available streams
      Hi, I was wondering if it is possible to programmatically query the streams that are available in a "streams/myInstance" folder. For example you...
    2. querying table names in a database
      Hey Gang - Anyone have a fast and easy CFQUERY that can query all the table names in an Access database? TIA
    3. Querying a Db Using a List Box
      Hello Everyone, My Boss and I are stuck. This seems like a rather simple thing to do, but cannot get it to work. Basically, we have a list box of...
    4. Exception error querying Access database from ASP page... Memo field type?
      Hi! Working with an MS Access database from an ASP webpage and I'm getting an Exception error... Error Type: (0x80020009) Exception...
    5. Update a Project with an external database
      Hi!! I´ve a serious doubt. Is the fileXtra4 useful to link a project with a database external? I mean, I´m working with a database, including and...
  3. #2

    Default Re: Querying an External Database

    Hi

    In the CF Admin create one DSN and use that dsn name in the cfquery.
    when you creating the dsn give all those details.

    vkunirs 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