> 2) Make sure your password is not more than 16 chars otherwise it gets > truncated by the CF Administrator App!
I don't believe it!!! That was it. I couldn't see that anywhere in the archives or the forums etc. What a ridiculous bug. Thanks loads Andre. > -----Original Message----- > From: Andre Mohamed [mailto:[EMAIL PROTECTED] > Sent: 25 February 2003 14:34 > To: CF-Talk > Subject: RE: dsn on cfmx - can't create > > > 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
