20 Replies Latest reply: Aug 15, 2012 8:40 AM by devdoyler RSS

    ColdFusion ignoring Connection String set in CFAdmin?


      I'm trying to setup a 3rd party JDBC driver as a datasource, but it appears to not matter what I put in the Connection String field in CFAdmin, it doesn't seem to use it at all.


      Errors out with Login failed: You must provide a user and password to login.

      I tried putting random text into the Connection String field expecting it to error out, but nothing happened either.

      I was wondering if I was entering the data wrong (I also tried the entire connection string with the jdbc:, but that did not work either) or if there was some way to verify the entire connection string that ColdFusion was trying to use.

      I'm not trying anything special inside of my cfquery tag: <cfquery name="output" datasource="mySource"> so that should not be the issue. I can get around the user/password issue by hard-coding these values in the cfquery tag, but there is a 3rd key that I need to provide as a connection value as well.

      The issue shouldn't be with my connection string, because the following worked with pure Java:

      conn = DriverManager.getConnection("jdbc:mydriver:User=user;Password=password;AccessToken=accessToken;");


      An interesting addition...ColdFusion appears to not care at ALL what is at the end of my URL as long as the beginning is correct...


      gives the username/password error. Whereas:


      gives me an "unable to find driver" error.