you'll all be no doubt delighted to know that the problem was because all of our dsn passwords are over 16 characters, and the CFMX administrator app truncates any password over 16 chars and helpfully doesn't tell you that its done so and what the problem was.
Which is nice. Completely ridiculous bug of the year, and just taken a day and a half of my time to solve. Not amused. > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 25 February 2003 11:08 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] dsn on cfmx - now interesting. > > > ok here's the current state of play: > > we have 2 cfmx machines on our network. > > NEITHER can connect to a sql server 2000 machine (of which we have 2 > separate machines) > BOTH can connect to sql server 7 machines (of which we have 2 also) > > we also have a couple of CF5 machines - these CAN connect to > SQL 7 and 2000 > without hitch (using the same DSN and SQL server details as > we used for the > CFMX machines). > > all machines have the same firewall configuration. > > in short, we have a definite problem with CFMX and SQL server 2000. > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > > Sent: 24 February 2003 16:08 > > To: [EMAIL PROTECTED] > > Subject: Re: [ cf-dev ] dsn on cfmx > > > > > > I have never solved this problem either. It drove me mad and > > I gave up and > > used ODBC connectors instead .... > > > > Regards - Paul > > > > > > > > > > ************************************************************* > > This email and any files transmitted with it are confidential > > and intended solely for the use of the individual or entity > > to whom they are addressed. If you have received this email > > in error please notify [EMAIL PROTECTED] > > > > The views expressed within this email are those of the > > individual, and not necessarily those of the organisation > > ************************************************************* > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
