Thank Ryan, That was a great idea. It works for me too... but yes I do expect a performance hit.
Brian At 02:23 PM 7/22/02, you wrote: >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 > ______________________________________________________________________ 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
