DSNless Connections

• You can specify a connection string for odbc datasources

<CFQUERY NAME="getpeople"

DATASOURCE="__DYNAMIC__"

DBTYPE="dynamic"

blockfactor="100"

connectstring="DRIVER={SQL SERVER};

SERVER=(local);

UID = sa;

PWD= ;

DATABASE=uikitdevsample">

select firstname,lastname

from empemployees

</CFQUERY>

Previous slide

Next slide

Back to first slide

View graphic version