Dec 31
Something I am presently looking at is connecting to Db’s without a DSN. Not something i’d ever practice but it seems to come up on the Macromedia CF forums quite a bit, doing:
<CFQUERY Name =“queryname” DATASOURCE = ‘dynamic’>
SELECT username, password
FROM database
IN ‘\\dir\dir2\windows\DB.mdb’
WHERE username = ‘#form.username#’
AND password = ‘#form.password#’
</CFQUERY>
SELECT username, password
FROM database
IN ‘\\dir\dir2\windows\DB.mdb’
WHERE username = ‘#form.username#’
AND password = ‘#form.password#’
</CFQUERY>
I’m curious to hear reports from other people that have tried it. It seems like something the universities encourage so they don’t have to create DSNs on their app servers.
Recent Comments