Dave helped me offlist... I had to use SQL Server Authentication when setting up the datasource in Windows ODBC.
Thanks Dave and all that replied Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Dave Watts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 03, 2003 10:04 AM Subject: RE: CFMX Updater 2 to blame? > > I'm able to setup SQL2K datasources using Windows > > Datasource utility just fine, but they don't show > > in CF Admin. > > Are you using SQL Server logins, or Windows Authentication? You have to use > SQL Server logins. > > Are you using default or named SQL Server instances? If you're using named > instances, they'll be listening at non-default ports, and you'll have to > have installed SQL Server SP2 or higher. > > Did you specify the IP address and port of the server in the CF > Administrator? You can't use Windows machine names, unless they also resolve > via DNS. > > If you post your datasource information, it might help. The jrpatch.jar file > just gives you more verbose error information, but you can probably solve > your problem without it. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
