RE: CFMX Install Issue

[Schreck, Tom]

I’m getting this error message: Connection verification failed for data source: xmlContentSolutions []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.   I’ve tried assigning sa sql server account to the database and then use sa as the login/password for ODBC connection.  No Luck.  I’ve tried creating a new SQL Server account and use that as the login.  No Luck.  Any help would be appreciated.     Thanks -   Tom Schreck 817-252-4900 [EMAIL PROTECTED]   I have not failed.  I've found 10,000 ways that won't work.   - Thomas Edison   -----Original Message----- From: Dan Blackman [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 11:36 AM To: [EMAIL PROTECTED] Subject: RE: CFMX Install Issue   I believe if you use ODBC Socket connections, you can use the Trusted Connection option.  Otherwise you are required to specify the UID and Password.     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Schreck, Tom Sent: Thursday, June 13, 2002 11:23 AM To: [EMAIL PROTECTED] Subject: CFMX Install Issue I’ve installed CFMX, but am having difficulty with the ODBC connections.  Most of my ODBC connections rely upon Trusted Connection option.  I do not see this option in the administrator?  Does CFMX force a Username and Password?   Thanks -   Tom Schreck 817-252-4900 [EMAIL PROTECTED]   I have not failed.  I've found 10,000 ways that won't work.   - Thomas Edison