first suggestion is dont use the SA login for coldfusion data sources. Only give the access that the app needs to a login for that app. AS far as the password special character issue not sure what to do there.
Daniel D. -----Original Message----- From: David Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 5:22 PM To: CF-Server Subject: CFMX will not accept special characters for password When creating DSN I am not sure if this is a bug but in my MS-SQL server the password for my sa account is 'password�'. To create this password I type in p-a-s-s-w-o-r-d-alt142. I then proceed to create my DSN via MDAC. I then test it, which is successful. The problem then occurs when I go to CFMX admin and setup the DSN using 'sa' for username and 'password�' for the password. When I then submit this configuration I get the nasty and well known error of "Connection verification failed for data source: data_source_name []java.sql.SQLException: SQLException occurred in JDBCPool...." To correct the problem I had to replace my sa's password with something more basic such as 'password' and then CFMX accepted the DSN without a problem. By the way, I am using wacky passwords with �,�,�, etc because this was a recommedation in Eweeks OpenHack contest. It appears that Microsoft products don't have a problem with this password regime by CFMX certainly does. Give it a try if you don't believe me. Dave Adams CFUG Ottawa ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
