I tried your suggestion but the result is the same.
On Friday, June 7, 2013 2:42:37 PM UTC-7, Aaron J. White wrote:
>
> This may seem obvious or not helpful, but have you tried overwriting with
> *attributecollection*? Although it's not shown in the manual for cfquery
> (grrr) it should work.
> <cfset myParams = {
> datasource:#application.alternateDS#,
> username:#user#,
> password:#pass#
> } />
> <cfquery attributecollection="#myParams#" >
> Select etc...
> </cfquery>
>
> Let us know if attribute collection works for you!
>
> Thanks,
> Aaron J. White
> On Friday, June 7, 2013 12:51:18 PM UTC-5, [email protected] wrote:
>>
>> 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.
