Thanks Billy, it did work out. you are right, need to select ODBC Socket instead of MS SQL SERVER driver.
nagesh -----Original Message----- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 7:04 PM To: CF-Talk Subject: RE: CFMX - DSN There is no option to check "Trusted Connection". -----Original Message----- From: Cravens, Billy [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 June 2002 5:49 AM To: CF-Talk Subject: RE: CFMX - DSN Are you using SQL Server or Windows authentication? I don't think that it will work with Windows authentication if you're using the native SQL Server driver - either provide it a valid SQL Server account, or switch to the ODBC Socket (be sure to check Trusted Connection). --- Billy Cravens -----Original Message----- From: nagesh [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 2:05 PM To: CF-Talk Subject: CFMX - DSN Hi Can someone would help me out, I recently upgraded to CFMX from CF 5.0, and trying to add a datasource to SQL Server, but I always ended up with the same error: Connection verification failed for data source: MyDSN []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. Thanks nagesh Confidentiality Notice: This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. ______________________________________________________________________ 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
