Re: CFMX DSN woes
The diagnostic jar file can be found here: http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602Method=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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX DSN woes
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 HTHif 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=23602Method=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=subscribeforumid=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
RE: CFMX DSN woes
CFMX will only connect to SQLServer databases setup for SQL Server logins... What happens if you try to set the DB up through the sa account? -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, March 3, 2003 15:36 To: CF-Talk 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=subscribeforumid=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
RE: CFMX DSN woes
I am using the following settings: DSN: cm database: cm (this is a database in my local instance of SQL Server) server: (local) Try the IP address or FQDN - I don't think JDBC recognizes (local). port: 1433 username: system OR cm (system with only windows security set, cm with SQL Server auth set) password: [none] or password You can't use Windows security, only SQL Server logins. You might want to test the account from the ODBC control panel, by setting up an ODBC datasource for testing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX DSN woes
That, and changing the server name to my machine name in all caps did the trick. Thanks! The Oracle issue persists, but I would prefer to prototype with SQL Server anyway... Pete - Original Message - From: Mike Townend [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:38 AM Subject: RE: CFMX DSN woes CFMX will only connect to SQLServer databases setup for SQL Server logins... What happens if you try to set the DB up through the sa account? -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, March 3, 2003 15:36 To: CF-Talk 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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX DSN woes
Actually, you can use trusted connections (Windows Authentication) with SQL Server, however CFMX will only connect using the account that it is running as. We have Domain level service accounts for all our CFMX installations. If you want to use a Trusted Connection you have to run CFMX as a named user. System (which is the Default for CFMX) cannot participate in a domain or any network sharing for that matter... Otherwise Mike is correct. You have to enable SQL Server logins. As for Oracle... ??? Don't work with it. Jeff - Original Message - From: Mike Townend [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 8:38 AM Subject: RE: CFMX DSN woes CFMX will only connect to SQLServer databases setup for SQL Server logins... What happens if you try to set the DB up through the sa account? -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, March 3, 2003 15:36 To: CF-Talk 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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX DSN woes
ACK... my bad, the only way to do Trusted connections is by using the JDBC:ODBC Bridge in CFMX. (You have to set up a SQL Server ODBC connection on the server). Sorry for the confusion... need more coffee... Jeff - Original Message - From: Jeff Garza [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 03, 2003 8:54 AM Subject: Re: CFMX DSN woes Actually, you can use trusted connections (Windows Authentication) with SQL Server, however CFMX will only connect using the account that it is running as. We have Domain level service accounts for all our CFMX installations. If you want to use a Trusted Connection you have to run CFMX as a named user. System (which is the Default for CFMX) cannot participate in a domain or any network sharing for that matter... Otherwise Mike is correct. You have to enable SQL Server logins. As for Oracle... ??? Don't work with it. Jeff - Original Message - From: Mike Townend [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 03, 2003 8:38 AM Subject: RE: CFMX DSN woes CFMX will only connect to SQLServer databases setup for SQL Server logins... What happens if you try to set the DB up through the sa account? -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, March 3, 2003 15:36 To: CF-Talk 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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX DSN woes
Pete, There is a patch floating around somewhere for CF's administrator which gives you more meaningful error messages when connecting to data sources other than the generic JDBC pool error. Search macromedia.com For SQL Server: 1) Make sure you are using Mixed Mode Authentication (not Windows only). 2) Make sure your password is not more than 16 chars. 3) Do not use (local) as the server. Hope this helps. Setting up a SQL data source should be a snap. Thanks, André -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 15:36 To: CF-Talk 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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4