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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
