At 05:26 PM 7/22/2002 -0400, you wrote: >Connecting to an instance you have to do two things:
I apologize - maybe instance was the wrong word to use. The SQL Server 2K Enterprise install is only running one instance - on the default port of 1433. I am able to create an ODBC datasource on the CFMX box and connect to the SQL Server Enterprise box through the Control Panel applet. I also tried the ODBC socket setup using the valid OBDC System DSN, and it failed, too. The SQL Server 2K box did not, however, have SP2. I will try that and let you know. Thanks >1) Make sure the RDBMS is running SP2. >2) Specify not only the machine name/IP address, BUT ALSO THE PORT of the >SQL Server in the CF Admin. Machines running instances of SQL Server have >each one running on a port different to the default.... so you've got to >specify it. > >That's where I'd start. > >~Simon > >Simon Horwith >Macromedia Certified Instructor >Certified Advanced ColdFusion 5 Developer >Fig Leaf Software >1400 16th St NW, # 500 >Washington DC 20036 >202.797.6570 (direct line) >www.figleaf.com > > > >-----Original Message----- >From: Alexander Sherwood [mailto:[EMAIL PROTECTED]] >Sent: Monday, July 22, 2002 5: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 > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
