This guy changed "client configuration for one DSN"? I'm not sure what he means by that. Changing one setting in one DSN does not change any other DSN settings other than the one you are editing. Unless there is some kind of MX bug involved that is...
To answer the second part, just use a different user account for each DSN... -- jon mailto:[EMAIL PROTECTED] Tuesday, March 11, 2003, 12:11:05 PM, you wrote: MR> Here is an excerpt from an email or DBA sent. Can someone help point me in the right direction. MR> Thanks MR> �-------------- MR> how does Cold Fusion decide on wheather to use Named Pipe or Tcpip? MR> Last week when I changed client configuration for one DSN, it chagned all the others. Is this the way it supposed to be? MR> Is there a way to trace more information about SQL Server Connection from Cold fusion. For example, if we want to look at all the connections that are opened by one DSN, can we take a look at MR> it? This would help us with monitoring why we are having connection problem to SQL Server. MR> Yi ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

