What user is CFMX running as? I've found that I have to run CFMX as a named user (rather than the default which is SYSTEM) to get it to work with Trusted Connections using the JDBC:ODBC brigde driver. You still have to supply the username and password (make sure you preface it with DOMAIN\username). Caveat is that this is the only account that CF will be able to connect as. The username/password fields in CFQUERY are worthless at this point.
All in all, you are much better off using SQL Server logins over trusted connections for CFMX... If you need more help, drop me a line off-list and I'll see what I can do. HTH, Jeff Garza -----Original Message----- From: Robert Shaw [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:53 PM To: CF-Talk Subject: sql datasource Yes, the datsource connects fine in Ctrl Panel, but not in CF. It works if I use the SQL server username and pass but not NT, I need to use NT. >>> have you tried using the odbc socket choice to make the dsn connection right to the system dsn already set up correctly? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
