 |
Site Admin |
Joined: Tue Mar 05, 2002 4:22 am Posts: 107
|
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>
|
|