Hi, Sandy, Thank you. I finally figured it out. It was because the user acct I used for datasource doesn't have enough rights.
Nathan -----Original Message----- From: Vohra, Sandeep Singh [mailto:[EMAIL PROTECTED] Sent: Thursday, December 14, 2006 4:50 PM To: CF-Newbie Subject: RE: really newbie question Nathan - You must confirm your dsn configured in Coldfusion Admin is pointing to correct Database which has this table USERS in it. Check the spellings and confirm the name of table from database. You should get results if you fire this query in database through SQLPLUS or TOAD. Thanks. -Sandy Vohra -----Original Message----- From: Nathan Chen [mailto:[EMAIL PROTECTED] Sent: Thursday, December 14, 2006 3:47 PM To: CF-Newbie Subject: RE: really newbie question Hi, Sandy, Here is my path. http://10.50.1.138/techexplorer/test.cfm Here is the content of my page, just a simple query. <cfquery name="getName" datasource="inteumcs"> select * from USERS order by Name </cfquery> <table> <cfoutput query="getName"> <tr> <td>#Name#</td> </tr> </cfoutput> </table> And her eis the error msg. It points to JDBC dirver. I am using Oracle 10g and I have Oracle 10g client installed on the server. I set up the ODBC using the drive Oracle client provides. Did I do it right? Error Executing Database Query. [Macromedia][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist Resources: * Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option. * Check the ColdFusion documentation <http://www.macromedia.com/go/proddoc_getdoc> to verify that you are using the correct syntax. * Search the Knowledge Base <http://www.macromedia.com/support/coldfusion/> to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; ...NET CLR 1.1.4322) Remote Address 10.50.1.138 Referrer Date/Time 14-Dec-06 01:45 PM ________________________________ From: Vohra, Sandeep Singh [mailto:[EMAIL PROTECTED] Sent: Thu 12/14/2006 12:39 PM To: CF-Newbie Subject: RE: really newbie question Nathan - It would be helpful if you could send me the test page and the path where it is located in your webroot or filesystem like D:\inetpub\wwwroot\... Also I am sure you would have verified the datasource connection through CF Admin? Thanks. -----Original Message----- From: Nathan Chen [mailto:[EMAIL PROTECTED] Sent: Thursday, December 14, 2006 2:00 PM To: CF-Newbie Subject: RE: really newbie question Hi, Sandy, Thank you. The server admin works now. I had to use my actual IP address in order to make it work. I was able to set up a datasource. But when I created a test page with a cf query in it and ran it, I got HTTP 500 internal server error, page not found. I checked the sever extensions and it says Macromedia Sever Extensions are allowed. Did I miss something again? Nathan -----Original Message----- From: Vohra, Sandeep Singh [mailto:[EMAIL PROTECTED] Sent: Thursday, December 14, 2006 11:00 AM To: CF-Newbie Subject: RE: really newbie question Hey Nathan - Did you complete the configuration of CF Admin after the installation as you have to do that before you can access it further? What type of install option did you select - Standalone CF Server or JRUN or J2ee ? Also check server extensions are enabled in IIS for Coldfusion? Please check this and forward the link - how you are trying to access CF Admin? The url .. I hope it should be something like http://localhost/cfide/administrator/index.cfm with no ports specified which means request goes to port 80 in IIS which forwards it to CF App Server.. Thanks. -Sandy Vohra -----Original Message----- From: Nathan Chen [mailto:[EMAIL PROTECTED] Sent: Thursday, December 14, 2006 12:51 PM To: CF-Newbie Subject: really newbie question Hi, All: I downloaded a developer version of CF MX7 from Adobe site and installed on a web server, which has IIS 6 running with an IP behind the firewall. After the installation, I went to the CF Admin page and it gives me HTTP 400, page not found. The installation seemed to run ok without giving me error messages. What did I miss here? Any pointer is appreciated. Nathan Chen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2350 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
