Man, this is maddening. I have CFMX installed on a Win2K box that can make JDBC connections using the supplied drivers to several different SQL Server 2000 boxes. I cannot, however, make a connection to an instance of SQL Server 2000 Enterprise Edition.
A thread on the CF Forums had several posts from users with similar problems. Most just reinstalled their OS and CFMX, which I refuse to do at this point. With this being the only apparent fix, it would seem that the problem lies within CFMX, despite the fact that my server can connect to non-Enterprise instances of SQL Server 2000. I could not find anything that would lead me to believe that SQL 2K Enterprise needs special configuration or prep for JDBC connections. I also tried to get the MSFT JDBC Drivers working (with info from this list) and I could not get it to work either. The exact error message: "The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info." All of the connection info is correct. Judging by the sheer number of posts in the forumn at macromedia.com, I assume that this is not a "1 user" configuration problem. Any ideas or similar problems??!?! Thanks, ---------------------------------- Alex Sherwood PHS Collection Agency THE COLLECTORS 301.215.4200 T 301.664.6834 F www.phs-net.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
