> 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 less are supported. > I also tried using a trusted connection, but that would > involve re-installing SQL Server in a mixed authentication > mode. That's even more work than just changing the passwords, > hehe.
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. However, if your SQL Server was installed using the mixed authentication mode option, that means it can do both Windows authentication (trusted connections) and native SQL logins (untrusted connections). You don't have to reinstall it to use trusted connections! > I thought for sure ODBC would work, given that it did in > previous versions. That was my fall-back position. As of this > second, my only remaining option is to reset all my database > passwords. Yikes. I think that resetting the database passwords is your best option, actually. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210907 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
