Sitephoria Knowledge Base

If the connection string in ASP is:

PROVIDER=SQLOLEDB;DATA SOURCE=mssql.megasqlservers.com;
DATABASE=db_domain_com; UID=dbm.domain.com; PWD=password;

In CFM it looks like this:

<cfquery
name="test"
datasource="ODBC"
dbtype="oledb"
dbserver="mssql.megasqlservers.com"
dbname="db_domain_com"
username="dbm.domain.com"
password="password"
provider="SQLOLEDB"
debug>
SELECT * FROM article_archives

</cfquery>

To output from the query:

<cfoutput query="test">
#article_id# #title#<br>
</cfoutput>