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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
