Aloha All, I have a development environment with Windows XP Pro, SQL Server Express (2005 and another 2008) installed locally. I configure the ODBC in Windows-->Administrative Tools-->ODBC. The bluedragon.xml picks up the connection string information and everything is good. I only specify the CFQUERY name and datasource and all connections work. (not the username and password).
Last night I tried to install on a SQL Server 2008 (not express) on a dedicated DB server (Win Server 2008) with the application/openBD/java on another server, Windows 2003 server. The openBD install went fine, the opneBD Administrator works, all is cool. I configure the ODBC pointing to the DB server using the windows admin tools, and test - passed. I go into the openBD administrator --> datasources and test, passed. When I run my app, I get an error that the login fails for user "". If I manually add the username and password to the CFQUERY tag, I pass. What gives? Any ideas? I do not want to have to modify all my CFQUERY tags to add the username and password (even as a site wide parameter), unless that is a best practice, is it? I played with a number of settings in the bluedragon.xml datasource, with no avail. I was restarting the service after each change, and also making changes via the openBD admin and then restarting the service to try to isolate a setting that might work. I have previously connected to remote DB servers using Cold Fusion, BlueDragon and I believe an earlier version of openBD, so it should work, but I'm guessing there is either a security setting, or some parameter in the bluedragon.xml that I am missing. Thanks in advance for any assistance, Rob -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
