RE: CF7 - 16 character limit on SQL passwords

2005-07-01 Thread Chase Seibert
Just following up on this issue, in case anyone cares. I ended up calling Macromedia support. They said that the only work-around they could find was specifying the password in the CFQUERY tag directly. I tested this out, and it does in fact get around the 16 character limit. Apparently the limi

Re: CF7 - 16 character limit on SQL passwords

2005-06-30 Thread Paul Hastings
Dave Watts wrote: > I know that the latest DataDirect drivers do support trusted connections. > However, there's no setting in the CF Admin to enable that instead of a > native SQL login. I'm too lazy right now to try to get it working, though. well if you're feeling a bit more energetic then mayb

RE: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Dave Watts
> if i'm not mistaken, i think the latest cf hotfix updated the > db drivers to support trusted connections. I know that the latest DataDirect drivers do support trusted connections. However, there's no setting in the CF Admin to enable that instead of a native SQL login. I'm too lazy right now t

Re: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Paul Hastings
Dave Watts wrote: > Well, CF doesn't directly support trusted connections, but the latest > DataDirect drivers do support them, so there may be a way to get them going > by manually writing your JDBC URL. if i'm not mistaken, i think the latest cf hotfix updated the db drivers to support trusted

RE: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Peter Farrell
>I think that resetting the database passwords is your best option, actually. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ I agree with Dave. Bad situations - but hard coded passwords/dsns/etc can cause that. Best, ...Peter

RE: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Dave Watts
> Ok, now I am really getting frustrated... may be time to call > in Macromedia support. I just tried ODBC; no dice. The same > exact 16 character password limitation exists. Again, I can > login as sa but not my regular user. Again, the dialog warns > you that only passwords 16 characters or l

RE: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Chase Seibert
lk" ; Sent: Jun 29, 2005 10:35:33 AM Subject: RE: CF7 - 16 character limit on SQL passwords Thanks for the good suggestion. I did indeed install the Microsoft JDBC driver, using the instructions at: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?event=view&id=KC.tn_18652&

RE: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Chase Seibert
x119 | www.bullhorn.com -Original Message- From:Jochem van Dieten [EMAIL PROTECTED] To: "CF-Talk" ; Sent: Jun 29, 2005 11:35:01 AM Subject: Re: CF7 - 16 character limit on SQL passwords Chase Seibert wrote: > > Looks like CF7 has a 16 character limit on SQL Server 2000 pas

Re: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Jochem van Dieten
Chase Seibert wrote: > > Looks like CF7 has a 16 character limit on SQL Server 2000 passwords. Does it? I remember running into the problem in the CF Admin when using a non-IE browser. It had to do something with the default settings for processing a form and the fact that passwords get longe

Re: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Marlon Moyer
ght into the official MM forums. > > > > > > > -Original Message- > From: Chase Seibert [mailto:[EMAIL PROTECTED] > Sent: 29 June 2005 15:35 > To: CF-Talk > Subject: RE: CF7 - 16 character limit on SQL passwords > > Thanks for the good suggestion. I di

RE: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Chase Seibert
-Chase Chase Seibert | Network and Systems Engineer | Bullhorn Inc. | 617.464.2440 x119 | www.bullhorn.com -Original Message- From:Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: "CF-Talk" ; Sent: Jun 29, 2005 10:47:47 AM Subject: RE: CF7 - 16 character limit on

RE: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Robertson-Ravo, Neil (RX)
Message- From: Chase Seibert [mailto:[EMAIL PROTECTED] Sent: 29 June 2005 15:35 To: CF-Talk Subject: RE: CF7 - 16 character limit on SQL passwords Thanks for the good suggestion. I did indeed install the Microsoft JDBC driver, using the instructions at: http://www.macromedia.com/cfusion

RE: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Robertson-Ravo, Neil (RX)
Dude, if it is a bug it, is a bug and no messingtry and log it or add your weight into the official MM forums. -Original Message- From: Chase Seibert [mailto:[EMAIL PROTECTED] Sent: 29 June 2005 15:35 To: CF-Talk Subject: RE: CF7 - 16 character limit on SQL passwords Thanks for

RE: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Chase Seibert
x27;s a bug. -Original Message----- From: Chase Seibert [mailto:[EMAIL PROTECTED] Sent: 29 June 2005 14:00 To: CF-Talk Subject: RE: CF7 - 16 character limit on SQL passwords lastMessage.Bump() & "#newContent#" Ok, no love on this question. If this is a "look in

RE: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Robertson-Ravo, Neil (RX)
ubject: RE: CF7 - 16 character limit on SQL passwords lastMessage.Bump() & "#newContent#" Ok, no love on this question. If this is a "look in the archives, you idiot" question, please let me know. I DID google the crap out of this to no avail. So here we are in round two...

RE: CF7 - 16 character limit on SQL passwords

2005-06-29 Thread Chase Seibert
lastMessage.Bump() & "#newContent#" Ok, no love on this question. If this is a "look in the archives, you idiot" question, please let me know. I DID google the crap out of this to no avail. So here we are in round two... 1. I assume this is part of the JDBC implementation, correct? Anyone kno