ColdFusion ignoring Connection String set in CFAdmin?

i'm trying setup 3rd party jdbc driver datasource, appears not matter put in connection string field in cfadmin, doesn't seem use @ all.

user=user@account.com;password=!password;

errors out with login failed: must provide user , password login.

i tried putting random text connection string field expecting error out, nothing happened either.

i wondering if entering data wrong (i tried entire connection string jdbc:, did not work either) or if there way verify entire connection string coldfusion trying use.

i'm not trying special inside of cfquery tag: <cfquery name="output" datasource="mysource"> so should not issue. can around user/password issue hard-coding these values in cfquery tag, there 3rd key need provide connection value well.

the issue shouldn't connection string, because following worked pure java:

conn = drivermanager.getconnection("jdbc:mydriver:user=user;password=password;accesstoken=accesstoken;");

.

an interesting addition...coldfusion appears not care @ @ end of url long beginning correct...

jdbc:mydriverrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr:

gives username/password error. whereas:

jdbc:mydriveer:

gives me "unable find driver" error.

hi,

on cfadmin page, click database , check this.

jdbc  url : jdbc:oracle:thin:@#ip address of database#:#port#:#username#

 

there colon in between database , port , port , username.

also, driver class should oracle.jdbc.oracledriver

 

i m assuming using oracle.

More discussions in ColdFusion

adobe