Everyone has the same permissions, so I ruled that out as well. However something HOSED CFADMIN cause I removed and re-installed CF Application Server and then it was back in business with executing the query as written.
Strange cause I was able to run other queries to other datasources and everything was fine. Just with this particular one. >>> [EMAIL PROTECTED] 01/28/03 12:35PM >>> The Administrator just verifies it can connect to the datasource. It's not until you actually try querying something that the user tries to access any schema. So, if your CF user only has (I think) CREATE SESSION privileges, it can connect to Oracle, but without permission to schema objects, it can't do anything. Verify the cfuser that you're connecting to the DB as has the privileges it needs to do what you're attempting. Conversely, using username & password defined in the cfquery tag will override any DSN settings, and connect as the user specified in the username attribute. FWIW -----Original Message----- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 10:58 AM To: CF-Talk Subject: RE: Oracle and CF5 If I add that it works. But that is not an option. Other workstations are NOT using the parameters on the queries. In CFADMIN, the paramters are on the Datasource Connection and verifies without hesitation. If CF login did not have access to the schema, why would the ADMINISTRATOR be able to verify the connection? Suggestions ??? >>> [EMAIL PROTECTED] 01/28/03 10:56AM >>> Are you sure the cf login has access to the schema? Just to make sure add username="username here" and password="password here" to the cfquery. -----Original Message----- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 10:29 AM To: CF-Talk Subject: Oracle and CF5 I have on my localbox the oracle client and running pages locally. In CFADMIN I have the Native Datasource set for a DSN of: MyDevData Then it will verify w/o a problem. Yes in CFADMIN there is a username and password to the datasource. When I try to run a page in CF that has a query similar to the one shown below, I get the error: [Oracle][ODBC][Ora]ORA-01005: null password given; logon denied <CFQUERY NAME="qGetAppName" DATASOURCE="MyDevData"> SELECT Dev_Application_Name FROM tblDev_Applications </CFQUERY> Why does it verify perfectly in CFADMIN and not when it is ran on a normal CFM page? Other users within my development team can run the same items without a problem. Suggestions????? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
