[RESOLVED] 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? What am I missing?

Thanks,

^_^

[WolfShade]

Can't be done with the dbserver and dbname parameters; have to have a DSN in CF Admin.

^_^