I had this problem yesterday with MS SQL Server 2000 datasources -if you set it up via Windows ODBC make sure you use the SQL Server Login info and not Windows Authentication -in CF Admin don't use the word "localhost"...use 127.0.0.1 instead
HTH....if not check yesterday's archives as there where other ideas regarding named instances of SQL Server that did not apply to my situation Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "David K" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 04, 2003 10:06 AM Subject: Re: CFMX DSN woes > The diagnostic jar file can be found here: > > http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602&Method=Full > > > > ----- Original Message ----- > From: "Pete Ruckelshaus" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, March 03, 2003 7:36 AM > Subject: CFMX DSN woes > > > > I cannot for the life of me configure a DSN in the CF MX Administrator. I > have tried to configure both an Oracle Native DSN (on a remote server) and > an MS SQL Server 2000 DSN (on localhost) and get this error: > > > > Connection verification failed for data source: cm > > []java.sql.SQLException: SQLException occurred in JDBCPool while > attempting to connect, please check your username, password, URL, and other > connectivity info. > > 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. > > > > Interestingly, I get the same error for both the Oracle DSN and the MS SQL > Server DSN. I have updated the JET and MDAC, and have run Updater 2. I am > running MX Enterprise on localhost running the built-in web server on port > 8500. > > > > Right now, I need to get the SQL Server DSN up and running. It gives me > this error whether I have the database set up for no security or for a DB > User with appropriate rights, and a userid/password assigned. > > > > I am using the following settings: > > DSN: cm > > database: cm (this is a database in my local instance of SQL Server) > > server: (local) > > port: 1433 > > username: system OR cm (system with only windows security set, cm with SQL > Server auth set) > > password: [none] or "password" > > > > Everything else is default except I have Unicode enabled in the "String > Format" checkbox and I have CLOB enabled. > > > > Can someone help me? Oddly, Access DSN's work fine. > > > > Thanks, > > > > Pete > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
