I am trying to do a cfquery without setting up a DSN on the CF Admin. I am using CF 5. I pasted the code that I am using below. It works fine in most instances however, when using a query that uses the CreateODBCDateTime I get an error: Malformed GUID. in query expression. I am using Access 97 and 2000. This query works fine when I set up the DSN in the Admin.
This is my code: <CFQUERY NAME="qryGetUserName" DATASOURCE="#strConn#" providerdsn="#strConn#" dbtype="OLEDB" provider="Microsoft.Jet.OLEDB.4.0" username="Admin" password=""> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com