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
