Accessing remote SQL server

[WolfShade]

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:

<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?

Thanks,

^_^

[mack_ · Accepted solution]

You need to setup a datasource in the CF admin pointing to the remote

server, using dbServer will not work.

Mack