www.webdeveloper.com
Results 1 to 2 of 2

Thread: [RESOLVED] Accessing remote SQL server

Hybrid View

  1. #1
    Join Date
    Dec 2002
    Location
    St. Louis, MO, USA
    Posts
    1,582

    resolved [RESOLVED] Accessing remote SQL server

    Hello, all.

    This is the first time I've ever needed to access a remote SQL server, and I'm getting an attribute validation error for the cfquery tag.

    The CFQUERY tag currently opens as:
    Code:
    <cfquery name="[queryName]" debug="1" username="#User#" password="#Pass#" dbserver="[SQL Server IP]" dbname="[databaseName]">
    What are the attributes that I need in order to remotely access the database? What am I missing?

    Thanks,

    ^_^

  2. #2
    Join Date
    Dec 2002
    Location
    St. Louis, MO, USA
    Posts
    1,582
    Can't be done with the dbserver and dbname parameters; have to have a DSN in CF Admin.

    ^_^

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles