For the life of me, I can not get ColdFusion MX to create a new datasource or recognize a current datasource.  The ODBC system datasources on the server work fine in connecting and using the sqlserver username and password with admin rights.  But when I try to create and verify those exact same datasources on the CF Administration screens I get a login error.  Initially I received a generic can’t connect error, then I installed the new updater and now I receive a login error.  Does it have anything to do with the JDBC drivers?

 

Here is the exact error I am getting.

Connection verification failed for data source: connectvia

[]java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'aUser'.

The root cause was that: java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'aUser'.

 

Sincerely,

Ricardo M. Sanoja

Director of Software Development

Version 4 Technologies

[EMAIL PROTECTED]

972.267.1558 #219

 

<<image001.gif>>

Reply via email to