Tom, I don't know if this is your problem, but Dan struck an idea. Your DSN's must exist in the CF admin. due to the use of JDBC drivers. Check out this document:
http://download.macromedia.com/pub/coldfusion/documentation/cfmx_adv_admin.p df and read the guidelines at the bottom of page 35. I hope this helps. Regards, Dennis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Blackman Sent: Thursday, June 13, 2002 1:41 PM To: [EMAIL PROTECTED] Subject: RE: CFMX Install Issue Using CFMX, I have only created the connections using the admin. If everything is up and running, then the sa and password (native SQLServer) should work. Are you sure that no one change the sa password on you!? You may want to check the setting on your SQL Server databases and see what the Registration Properties specifiy....Trusted Connection or UID and Password Just some thoughts.... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Schreck, Tom Sent: Thursday, June 13, 2002 12:25 PM To: [EMAIL PROTECTED] Subject: RE: CFMX Install Issue Native SQL Server. I know SQL Server is running. Should I be using a SQL Server account or NT Authenticated account for the username/password for the ODBC connection. It looks like the ODBC Socket connection has to select a odbc name. If I cannot get the ODBC connection to work, then how will the ODBC Socket work? 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 12:04 PM To: [EMAIL PROTECTED] Subject: RE: CFMX Install Issue I get this error when either SQL Server is ShutDown OR The username and password are incorrect. What kind of connection are trying to establish? Native Sql Server, ODBC Socket?! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Schreck, Tom Sent: Thursday, June 13, 2002 12:01 PM To: [EMAIL PROTECTED] Subject: RE: CFMX Install Issue 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 ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
