Since upgrading from OpenBD 2.0 to OpenBD 3.0 the username and password in
cfquery no longer override the username and password set in bluedragon.xml.
Is this a bug or do I need to alter my configuration in some way? Below are
my datasource and query (scrubbed for security). In 2.0 the query runs as
"anotheruser" but in 3.0 it runs as "testuser".
My datasource config:
<datasource name="foo">
<displayname>foo</displayname>
<password>bar</password>
<connectionretries>0</connectionretries>
<sqldelete>true</sqldelete>
<sqlupdate>true</sqlupdate>
<username>testuser</username>
<drivername>com.sybase.jdbc4.jdbc.SybDataSource</drivername>
<sqlstoredprocedures>true</sqlstoredprocedures>
<perrequestconnections>false</perrequestconnections>
<sqlinsert>true</sqlinsert>
<sqlselect>true</sqlselect>
<connectiontimeout>120</connectiontimeout>
<port></port>
<server></server>
<databasename></databasename>
<description></description>
<connectstring></connectstring>
<verificationquery>select srvname from sysservers</verificationquery>
<logintimeout>120</logintimeout>
<initstring></initstring>
<hoststring>jdbc:sybase:Tds:server.my.domain:5000/master?APPLICATIONNAME=OpenBlueDragon</hoststring>
<maxconnections>24</maxconnections>
<name>foo</name>
</datasource>
My query:
<cfquery name="Authenticate" DATASOURCE="foo" username="anotheruser"
password="password123" >
select * from foo_table
</cfquery>
--
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en
---
You received this message because you are subscribed to the Google Groups "Open
BlueDragon" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
