there were some other recommendations: > 1) Make sure you are using Mixed Mode authentication (not > Windows only) > on your SQL server DBMS. > > 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.
> -----Original Message----- > From: Garry Mills [mailto:[EMAIL PROTECTED] > Sent: 25 February 2003 15:01 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] dsn on cfmx - SOLVED > > > Arse. That doesn't solve our problem but it isn't an issue at > the moment > > Garry > > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 25 February 2003 14:52 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] dsn on cfmx - SOLVED > > > 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] > > -- > ** 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]
