> 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.
I haven't run into this problem, myself. There's no difference between SQL Server 2000 Enterprise and other editions, from a connection perspective. Are there any other differences? (Named instances vs default instances, for example.) Can you connect via ODBC to your SQL Server 2000 Enterprise server using a username and password? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
