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:

%26lt;cfquery name=''[queryName]'' debug=''1'' username=''#User#'' password=''#Pass#'' dbserver=''[SQL Server IP]'' dbname=''[databaseName]''%26gt;

What are the attributes that I need in order to remotely access the database?

Thanks,

^_^

Accessing remote SQL server

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

server, using dbServer will not work.

Mack

cheap make up