As a temporary fix, you could always try an ODBC Socket connection. Here's what you do: set the DEN in the Windows ODBC Admin, then go to the admin panel in MX and select the ODBC Socket driver. Then select your DSN you set up in the ODBC Admin and there you go. Could be a performance hit, but at least it will get you going until you can tweak the other setup.
Ryan Kime -----Original Message----- From: Alexander Sherwood [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:12 PM To: CF-Talk Subject: CFMX JDBC Drivers 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 ______________________________________________________________________ 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 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
