Skip to main content
T
trojnfn
Inspiring
August 1, 2006
Question

Stored Procedures

  • August 1, 2006
  • 2 replies
  • 351 views
I was provided the following stored procedure :

<add key="MTRAKConnectionString" value="Data Source=mtrakdb.mck.us.ray.com, 2426;Initial Catalog=MTRAK;User ID=Dashboard; Password=T34p!rZy;"/>

I know I need to use it in my CF query to access data. But I have no idea what it means and what it does, and do not know where it should go within CF.

I currently connect to the remote db with an odbc connection.

Any help will be greatly appreciated.

Thanks
    This topic has been closed for replies.

    2 replies

    P
    philh
    Inspiring
    August 2, 2006
    What we have here is not a stored procedure, but an app settings entry from a .NET web.config file. This is the connection string used by the application to communicate with the data source. You need to set up a ColdFusion data source that will connect to mtrakdb.mck.us.ray.com and have MTRAK as the database. It sounds like you already have this set up, so no further action is necessary. Use the CFSTOREDPROC syntax that the Scarecrow provided to run SPs in the database.

    HTH,
    T
    The_ScareCrow
    Inspiring
    August 2, 2006
    You use

    <cfstoredproc procedure="stored procedure id"
    datasource="dsn"
    username="username"
    password="password"
    dbserver="server"
    dbname="dbname"
    provider="provider">
    </cfstoredproc>

    The online docs will have examples.

    Ken
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices