Rich, A couple of things that might help:
1) Make sure you are using Mixed Mode authentication (not Windows only) on your SQL server DBMS. 2) Make sure your password is not more than 16 chars otherwise it gets truncated by the CF Administrator App! 3) There is a patch for the CF Administrator (can't find it just now) which produces more accurate error messages when you are unable to verify data sources...without the patch you get a generic "JDBC Pool Exception" which although correct in some cases is not in others and can be misleading. You'll have to locate this "patch" yourself because I'm supposed to be working right now! (also, not sure if its included in the updaters) Thanks, André -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:27 To: CF-Talk Subject: dsn on cfmx - can't create I've checked the archive on this + the forums + the technotes, but haven't been able to resolve it. We cannot add a DSN to a SQL Server 2000 database through CFMX. we have 2 cfmx machines and 3 sql server machines. 2 of these machines are sql server 2000, and 1 is SQL 7. Each cfmx machine is win2000 with sp3 installed (mdac 2.7 etc). each install of cfmx is patched to updater 2. We can't add a DSN either via the type 4 drivers (SQL server) or via an ODBC socket to a DSN setup successfully to connect to the a database on a sql2000 machine. We *can* add type 4 and type 3 DSNs that connect to any SQL server 7 machine. Oddly, we also have some CF5 machines that can connect to the sql 2000 databases using exactly the same details that were used for the cfmx machines' DSNs. All machines have the same firewall configuration. We also tried adding the ODBC Server service in CFMX to a new security account in win2000, but this hasn't worked either. We've now run out of options. Can anyone help? Many thanks, ------------------------------------------------------- Rich Wild Senior Web Developer ------------------------------------------------------- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. ------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
