#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Kolkata, (West Bengal) India
    Posts
    129
    Rep Power
    0

    Unhappy ColdFusion Data Source


    Hi Fellow Coldfusionites !!

    I am very new to ColdFusion. I tested my Coldfusion app in my local server where I was using a datasource say xxx . Now after uploading the .CFM files to the hosting server I am in a great problem as I dont know how to access the Administrator panel to set up the data source. Please advise.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Location
    Norwich
    Posts
    53
    Rep Power
    11
    Hi,

    Coldfusion administrator should be in start > programs > macromedia > macromedia coldfusion mx > administrator.

    This should take you to the login of administrator.
  4. #3
  5. No Profile Picture
    Moderator

    Join Date
    Jun 2002
    Location
    Raleigh, NC
    Posts
    5,286
    Rep Power
    968
    If you are on a shared server you will almost certainly NOT have access to the CF administrator interface, for obvious security reasons. You'll have to go through your hosting provider's control panel or email their support people to have them set up a datasource for you.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Kolkata, (West Bengal) India
    Posts
    129
    Rep Power
    0

    Thanks


    Hi Kiteless,

    Thanks for your reply. I guessed the same also. We had to email the server admin to fix a datasource for us and I hope he does it quickly. But this is surely a time consuming and cumbersome process. I was thinking if there is an easy way. The control panel provided by the hosting company lets me create a ODBC connection to my MA SQL DB. Is it of any use with the ColdFusion App i.e. Can I use the ODBC connection with the coldfusion app the way we do in ASP ?
  8. #5
  9. No Profile Picture
    Moderator

    Join Date
    Jun 2002
    Location
    Raleigh, NC
    Posts
    5,286
    Rep Power
    968
    Yes I believe you should be able to use the same ODBC datasource name in CF.
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Kolkata, (West Bengal) India
    Posts
    129
    Rep Power
    0

    Odbc


    Hi kiteless !!

    when I am using CF datasource named say xyz while quering we write:

    <cfquery name="abc" datasource="xyz">
    select * from dummy_table
    </cfquery>

    How do you do the same query with ODBC connection?
  12. #7
  13. No Profile Picture
    Moderator

    Join Date
    Jun 2002
    Location
    Raleigh, NC
    Posts
    5,286
    Rep Power
    968
    As far as I know, any ODBC connection you create in the CF administrator is actually created as a system ODBC datasource. So if you have an ODBC datasource named "xyz" I think you should be able to use "xyz" and the dsn name in your cfquery tag.
  14. #8
  15. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    14
    Rep Power
    0
    Try to access : http://<yourwebsite.com or IP>/cfide/administrator/index.cfm or ask your ISP to create a datasource for you....

IMN logo majestic logo threadwatch logo seochat tools logo