Hi I was just wondering if it is possible to use dns less connections
with coldfusion in the DMX enviroment, I was always able to with asp
but now with the coldfusion MX administrator it seems it just set up
to work with dsn's is there a way to do it it seems to work so much
better for when you got to put the site on a hosting server.
any comments would be greatly appreasiated

Haven't used cold fusion in DMX but try just hand writing your connection object like in asp:

Dim conn
Dim SQL
Dim RS

Set conn = Server.CreateObject("ADODB.Connection"
conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=username;Password=password;Initial Catalog=dbname;Data Source=servname"

SQL = ""

Not sure though