RE: Oracle and CF5
Exactly. -Original Message- From: Lincoln Milner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 12:35 PM To: CF-Talk Subject: RE: Oracle and CF5 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 FROMtblDev_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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Oracle and CF5
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 FROMtblDev_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=subscribeforumid=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
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 FROMtblDev_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=subscribeforumid=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
RE: Oracle and CF5
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 FROMtblDev_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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Oracle and CF5 - RESOLVED -
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 FROMtblDev_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=subscribeforumid=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
Re: Oracle and CF5
Stephenie, Oracle doesn't make anything real easy. There is no executable, what you need is the Oracle Universal Installer. If you have the Oracle Client installed, there should be a menu item called Oracle Installation Products. Click on the Universal Installer, and click Next... Then on the next screen for Source, click browse and find the products.jar file -- this should have been extraced from your driver download (in a Disk1\Stage\ directory in the location where you extracted the files) If you don't have that, then you would need to grab hold of an oracle product that has the installer on it -- the client is the best bet. There is a product for download on the Oracle site called Oracle Rdb ODBC Drivers that has the Installer included with the download -- these are not the drivers you need, most likely, but you it may be a quicker way to grab hold of the installer . HTH, Tim P. - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 5:36 PM Subject: RE: Oracle and CF5 Thanks, but did you have any troubles installing the drivers? I extracted them on the cf server, and read the readme.txt, it states that upon extraction of the zip file there will be an executable, which did not happen.. This is driver vs. 8.1.7.7 ~~ Stephenie |-Original Message- |From: Tim Painter [mailto:[EMAIL PROTECTED]] |Sent: Wednesday, September 04, 2002 5:10 PM |To: CF-Talk |Subject: Re: Oracle and CF5 | | |I've had a lot better luck using the Oracle ODBC driver |instead of the ms driver -- you'd have to download that |from oracle | |Tim P. | |- Original Message - |From: Stephenie Hamilton [EMAIL PROTECTED] |To: CF-Talk [EMAIL PROTECTED] |Sent: Wednesday, September 04, 2002 5:03 PM |Subject: Oracle and CF5 | | | I have a client who is running a dedicated CF5 server and |a dedicated | Oracle server. We can't get CF to talk to oracle. The |dsn's we setup | in the ODBC control panel verify, but not through CF and |CF tells me | ODBC Error Code = IM003 (Specified driver could not be loaded) | | | Specified driver could not be loaded due to system error |126 (MERANT | 3.70 ColdFusion OEM 32-BIT Oracle8). | | Neither the DSN with the merant driver nor the dsn with |the ms oracle | driver will verify through CF administrator... | | Anyone know anything about this? This is my first time |dealing with | oracle and it is driving me crazy! | | Oh yeah, this is a Win2k server | | ~~ | Stephenie | | | | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and CF5
Thanks! Ok, I have it installed, now lets see if I can get this to work! One thing I have been wondering, This is CF5 Pro.which does not have the native driver support...should I have the client upgrade to CF5 Enterprise, which does? ~~ Stephenie |-Original Message- |From: Tim Painter [mailto:[EMAIL PROTECTED]] |Sent: Thursday, September 05, 2002 6:33 AM |To: CF-Talk |Subject: Re: Oracle and CF5 | | |Stephenie, |Oracle doesn't make anything real easy. There is no |executable, what you need is the Oracle Universal Installer. | If you have the Oracle Client installed, there should be a |menu item called Oracle Installation Products. Click on the |Universal Installer, and click Next... Then on the next |screen for Source, click browse and find the products.jar |file -- this should have been extraced from your driver |download (in a Disk1\Stage\ directory in the location where |you extracted the files) | |If you don't have that, then you would need to grab hold of |an oracle product that has the installer on it -- the client |is the best bet. There is a product for download on the |Oracle site called Oracle Rdb ODBC Drivers that has the |Installer included with the download -- these are not the |drivers you need, most likely, but you it may be a quicker |way to grab hold of the installer . | |HTH, |Tim P. | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle and CF5
Honestly, I don't see much of a difference between using odbc and native , but the apps I am using with it have pretty small usage. If that is the only consideration for spending the extra money on enterprise, I'd probably stick with Pro. Others here may have some more real world experience that may dictate otherwise. HTH, Tim P. - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 10:08 AM Subject: RE: Oracle and CF5 Thanks! Ok, I have it installed, now lets see if I can get this to work! One thing I have been wondering, This is CF5 Pro.which does not have the native driver support...should I have the client upgrade to CF5 Enterprise, which does? ~~ __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and CF5
We have the oracle client installed, the DSN's will verify from the windows ODBC control panel, from sqlcon32.exe and from the oracle test utility. Just not inside CF This is CF5 Pro ~~ Stephenie |-Original Message- |From: David Hannum (Ohio University) [mailto:[EMAIL PROTECTED]] |Sent: Wednesday, September 04, 2002 5:57 PM |To: CF-Talk |Subject: Re: Oracle and CF5 | | |Have you installed the Oracle client on the server? We're |running CF 5 on Win2K against Oracle 7.x 8.x servers on |IBM, AIX and Sun boxes. Not a problem (except for one issue |on the IBM). But, you need the Oracle client installed on |the server and you need a properly written TNS Names file |(tnsnames.ora) that the Oracle drivers can find. If this |isn't enough info, I'll be glad to expound further. | |Dave | |= |David Hannum |Web Analyst/Programmer |Ohio University | | | |- Original Message - |From: Stephenie Hamilton [EMAIL PROTECTED] |To: CF-Talk [EMAIL PROTECTED] |Sent: Wednesday, September 04, 2002 5:03 PM |Subject: Oracle and CF5 | | | I have a client who is running a dedicated CF5 server and |a dedicated | Oracle server. We can't get CF to talk to oracle. The |dsn's we setup | in the ODBC control panel verify, but not through CF and |CF tells me | ODBC Error Code = IM003 (Specified driver could not be loaded) | | | Specified driver could not be loaded due to system error |126 (MERANT | 3.70 ColdFusion OEM 32-BIT Oracle8). | | Neither the DSN with the merant driver nor the dsn with |the ms oracle | driver will verify through CF administrator... | | Anyone know anything about this? This is my first time |dealing with | oracle and it is driving me crazy! | | Oh yeah, this is a Win2k server | | ~~ | Stephenie | | | | __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and CF5
Are you sure that the SQLNET.ORA and TNSNAMES.ORA files are valid and in the proper directory on the CF5 server? Normally, they are in oracle_directory/NET80/ADMIN. As a CF developer new to the Oracle way of things, I was totally confused by these files and finally had to ask the Oracle Admin to set them up for me, so if you don't know anything about these files, ask the DBA for help! Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 10:10 AM To: CF-Talk Subject: RE: Oracle and CF5 We have the oracle client installed, the DSN's will verify from the windows ODBC control panel, from sqlcon32.exe and from the oracle test utility. Just not inside CF This is CF5 Pro ~~ Stephenie |-Original Message- |From: David Hannum (Ohio University) [mailto:[EMAIL PROTECTED]] |Sent: Wednesday, September 04, 2002 5:57 PM |To: CF-Talk |Subject: Re: Oracle and CF5 | | |Have you installed the Oracle client on the server? We're |running CF 5 on Win2K against Oracle 7.x 8.x servers on |IBM, AIX and Sun boxes. Not a problem (except for one issue |on the IBM). But, you need the Oracle client installed on |the server and you need a properly written TNS Names file |(tnsnames.ora) that the Oracle drivers can find. If this |isn't enough info, I'll be glad to expound further. | |Dave | |= |David Hannum |Web Analyst/Programmer |Ohio University | | | |- Original Message - |From: Stephenie Hamilton [EMAIL PROTECTED] |To: CF-Talk [EMAIL PROTECTED] |Sent: Wednesday, September 04, 2002 5:03 PM |Subject: Oracle and CF5 | | | I have a client who is running a dedicated CF5 server and |a dedicated | Oracle server. We can't get CF to talk to oracle. The |dsn's we setup | in the ODBC control panel verify, but not through CF and |CF tells me | ODBC Error Code = IM003 (Specified driver could not be loaded) | | | Specified driver could not be loaded due to system error |126 (MERANT | 3.70 ColdFusion OEM 32-BIT Oracle8). | | Neither the DSN with the merant driver nor the dsn with |the ms oracle | driver will verify through CF administrator... | | Anyone know anything about this? This is my first time |dealing with | oracle and it is driving me crazy! | | Oh yeah, this is a Win2k server | | ~~ | Stephenie | | | | __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and CF5
I am working with the DBA...the files are correct or the DSN's wouldn't verify and connect from the MS ODBC control panel, the Oracle test connection utility and sqlcon32.exe...right? IT is just CF that cannot connect to the db's Gives me strange errors like cannot load driver or something to that effect... ~~ Stephenie |-Original Message- |From: Chris Lofback [mailto:[EMAIL PROTECTED]] |Sent: Thursday, September 05, 2002 11:17 AM |To: CF-Talk |Subject: RE: Oracle and CF5 | | |Are you sure that the SQLNET.ORA and TNSNAMES.ORA files are |valid and in the proper directory on the CF5 server? |Normally, they are in oracle_directory/NET80/ADMIN. As a |CF developer new to the Oracle way of things, I was |totally confused by these files and finally had to ask the |Oracle Admin to set them up for me, so if you don't know |anything about these files, ask the DBA for help! | |Chris Lofback |Sr. Web Developer | |TRX Integration |28051 US 19 N., Ste. C |Clearwater, FL 33761 |www.trxi.com | | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and CF5
Stephanie, This may be dumb but has the machine been rebooted? Some application rely on using the Oracle nvironment variables to locate the binary libraries etc. Sometime the system env vars don't kick in until the machine's rebooted. Users vars will kick in when they log off and back in but CF should run as the system user. A quick test might be to open a command prompt and enter the set command without any arguments. This will list the Oracle env variables if they're there. If they're not there you could try rebooting -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 11:34 AM To: CF-Talk Subject: RE: Oracle and CF5 I am working with the DBA...the files are correct or the DSN's wouldn't verify and connect from the MS ODBC control panel, the Oracle test connection utility and sqlcon32.exe...right? IT is just CF that cannot connect to the db's Gives me strange errors like cannot load driver or something to that effect... ~~ Stephenie |-Original Message- |From: Chris Lofback [mailto:[EMAIL PROTECTED]] |Sent: Thursday, September 05, 2002 11:17 AM |To: CF-Talk |Subject: RE: Oracle and CF5 | | |Are you sure that the SQLNET.ORA and TNSNAMES.ORA files are |valid and in the proper directory on the CF5 server? |Normally, they are in oracle_directory/NET80/ADMIN. As a |CF developer new to the Oracle way of things, I was |totally confused by these files and finally had to ask the |Oracle Admin to set them up for me, so if you don't know |anything about these files, ask the DBA for help! | |Chris Lofback |Sr. Web Developer | |TRX Integration |28051 US 19 N., Ste. C |Clearwater, FL 33761 |www.trxi.com | | __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and CF5
You know...i don't think it was rebooted... Let me ask the client... About this set commandnot familiar with it Thanks for the help, I really appreciate it..this is so easy with MS SQL, but Oracle is just driving me crazy!! ~~ Stephenie |-Original Message- |From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] |Sent: Thursday, September 05, 2002 11:38 AM |To: CF-Talk |Subject: RE: Oracle and CF5 | | |Stephanie, | |This may be dumb but has the machine been rebooted? Some |application rely on using the Oracle nvironment variables to |locate the binary libraries etc. Sometime the system env |vars don't kick in until the machine's rebooted. Users vars |will kick in when they log off and back in but CF should run |as the system user. | |A quick test might be to open a command prompt and enter the |set command without any arguments. This will list the |Oracle env variables if they're there. If they're not there |you could try rebooting | |-Original Message- |From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] |Sent: Thursday, September 05, 2002 11:34 AM |To: CF-Talk |Subject: RE: Oracle and CF5 | |I am working with the DBA...the files are correct or the |DSN's wouldn't verify and connect from the MS ODBC control |panel, the Oracle test connection utility and sqlcon32.exe...right? | |IT is just CF that cannot connect to the db's |Gives me strange errors like cannot load driver or |something to that effect... | | | |~~ |Stephenie | | | | |-Original Message- | |From: Chris Lofback [mailto:[EMAIL PROTECTED]] | |Sent: Thursday, September 05, 2002 11:17 AM | |To: CF-Talk | |Subject: RE: Oracle and CF5 | | | | | |Are you sure that the SQLNET.ORA and TNSNAMES.ORA files are | |valid and in the proper directory on the CF5 server? | |Normally, they are in oracle_directory/NET80/ADMIN. As a | |CF developer new to the Oracle way of things, I was | |totally confused by these files and finally had to ask the | |Oracle Admin to set them up for me, so if you don't know | |anything about these files, ask the DBA for help! | | | |Chris Lofback | |Sr. Web Developer | | | |TRX Integration | |28051 US 19 N., Ste. C | |Clearwater, FL 33761 | |www.trxi.com | | | | | | | __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and CF5
You're welcome, but only thank me if it fixes the problem! ;-) The set command is just a standard DOS command to set environment variables. Used just by itself it will just print out all the variables. One to looks for is the ORACLE_HOME variable. -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 11:51 AM To: CF-Talk Subject: RE: Oracle and CF5 You know...i don't think it was rebooted... Let me ask the client... About this set commandnot familiar with it Thanks for the help, I really appreciate it..this is so easy with MS SQL, but Oracle is just driving me crazy!! ~~ Stephenie |-Original Message- |From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] |Sent: Thursday, September 05, 2002 11:38 AM |To: CF-Talk |Subject: RE: Oracle and CF5 | | |Stephanie, | |This may be dumb but has the machine been rebooted? Some |application rely on using the Oracle nvironment variables to |locate the binary libraries etc. Sometime the system env |vars don't kick in until the machine's rebooted. Users vars |will kick in when they log off and back in but CF should run |as the system user. | |A quick test might be to open a command prompt and enter the |set command without any arguments. This will list the |Oracle env variables if they're there. If they're not there |you could try rebooting | |-Original Message- |From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] |Sent: Thursday, September 05, 2002 11:34 AM |To: CF-Talk |Subject: RE: Oracle and CF5 | |I am working with the DBA...the files are correct or the |DSN's wouldn't verify and connect from the MS ODBC control |panel, the Oracle test connection utility and sqlcon32.exe...right? | |IT is just CF that cannot connect to the db's |Gives me strange errors like cannot load driver or |something to that effect... | | | |~~ |Stephenie | | | | |-Original Message- | |From: Chris Lofback [mailto:[EMAIL PROTECTED]] | |Sent: Thursday, September 05, 2002 11:17 AM | |To: CF-Talk | |Subject: RE: Oracle and CF5 | | | | | |Are you sure that the SQLNET.ORA and TNSNAMES.ORA files are | |valid and in the proper directory on the CF5 server? | |Normally, they are in oracle_directory/NET80/ADMIN. As a | |CF developer new to the Oracle way of things, I was | |totally confused by these files and finally had to ask the | |Oracle Admin to set them up for me, so if you don't know | |anything about these files, ask the DBA for help! | | | |Chris Lofback | |Sr. Web Developer | | | |TRX Integration | |28051 US 19 N., Ste. C | |Clearwater, FL 33761 | |www.trxi.com | | | | | | | __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and CF5
Okwell I could just strangle the DBAbut I guess she didn't know... Reboot... - problem solved... Thanks again Kevin!! ** feeling stupid now ** ~~ Stephenie |-Original Message- |From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] |Sent: Thursday, September 05, 2002 11:38 AM |To: CF-Talk |Subject: RE: Oracle and CF5 | | |Stephanie, | |This may be dumb but has the machine been rebooted? Some |application rely on using the Oracle nvironment variables to |locate the binary libraries etc. Sometime the system env |vars don't kick in until the machine's rebooted. Users vars |will kick in when they log off and back in but CF should run |as the system user. | |A quick test might be to open a command prompt and enter the |set command without any arguments. This will list the |Oracle env variables if they're there. If they're not there |you could try rebooting | __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and CF5
Heh heh, glad to help! If in doubt - reboot ! (sometimes anyway) -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 12:00 PM To: CF-Talk Subject: RE: Oracle and CF5 Okwell I could just strangle the DBAbut I guess she didn't know... Reboot... - problem solved... Thanks again Kevin!! ** feeling stupid now ** ~~ Stephenie |-Original Message- |From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] |Sent: Thursday, September 05, 2002 11:38 AM |To: CF-Talk |Subject: RE: Oracle and CF5 | | |Stephanie, | |This may be dumb but has the machine been rebooted? Some |application rely on using the Oracle nvironment variables to |locate the binary libraries etc. Sometime the system env |vars don't kick in until the machine's rebooted. Users vars |will kick in when they log off and back in but CF should run |as the system user. | |A quick test might be to open a command prompt and enter the |set command without any arguments. This will list the |Oracle env variables if they're there. If they're not there |you could try rebooting | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle and CF5
I've had a lot better luck using the Oracle ODBC driver instead of the ms driver -- you'd have to download that from oracle Tim P. - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 5:03 PM Subject: Oracle and CF5 I have a client who is running a dedicated CF5 server and a dedicated Oracle server. We can't get CF to talk to oracle. The dsn's we setup in the ODBC control panel verify, but not through CF and CF tells me ODBC Error Code = IM003 (Specified driver could not be loaded) Specified driver could not be loaded due to system error 126 (MERANT 3.70 ColdFusion OEM 32-BIT Oracle8). Neither the DSN with the merant driver nor the dsn with the ms oracle driver will verify through CF administrator... Anyone know anything about this? This is my first time dealing with oracle and it is driving me crazy! Oh yeah, this is a Win2k server ~~ Stephenie __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and CF5
Thanks, but did you have any troubles installing the drivers? I extracted them on the cf server, and read the readme.txt, it states that upon extraction of the zip file there will be an executable, which did not happen.. This is driver vs. 8.1.7.7 ~~ Stephenie |-Original Message- |From: Tim Painter [mailto:[EMAIL PROTECTED]] |Sent: Wednesday, September 04, 2002 5:10 PM |To: CF-Talk |Subject: Re: Oracle and CF5 | | |I've had a lot better luck using the Oracle ODBC driver |instead of the ms driver -- you'd have to download that |from oracle | |Tim P. | |- Original Message - |From: Stephenie Hamilton [EMAIL PROTECTED] |To: CF-Talk [EMAIL PROTECTED] |Sent: Wednesday, September 04, 2002 5:03 PM |Subject: Oracle and CF5 | | | I have a client who is running a dedicated CF5 server and |a dedicated | Oracle server. We can't get CF to talk to oracle. The |dsn's we setup | in the ODBC control panel verify, but not through CF and |CF tells me | ODBC Error Code = IM003 (Specified driver could not be loaded) | | | Specified driver could not be loaded due to system error |126 (MERANT | 3.70 ColdFusion OEM 32-BIT Oracle8). | | Neither the DSN with the merant driver nor the dsn with |the ms oracle | driver will verify through CF administrator... | | Anyone know anything about this? This is my first time |dealing with | oracle and it is driving me crazy! | | Oh yeah, this is a Win2k server | | ~~ | Stephenie | | | | __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle and CF5
Have you installed the Oracle client on the server? We're running CF 5 on Win2K against Oracle 7.x 8.x servers on IBM, AIX and Sun boxes. Not a problem (except for one issue on the IBM). But, you need the Oracle client installed on the server and you need a properly written TNS Names file (tnsnames.ora) that the Oracle drivers can find. If this isn't enough info, I'll be glad to expound further. Dave = David Hannum Web Analyst/Programmer Ohio University - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 5:03 PM Subject: Oracle and CF5 I have a client who is running a dedicated CF5 server and a dedicated Oracle server. We can't get CF to talk to oracle. The dsn's we setup in the ODBC control panel verify, but not through CF and CF tells me ODBC Error Code = IM003 (Specified driver could not be loaded) Specified driver could not be loaded due to system error 126 (MERANT 3.70 ColdFusion OEM 32-BIT Oracle8). Neither the DSN with the merant driver nor the dsn with the ms oracle driver will verify through CF administrator... Anyone know anything about this? This is my first time dealing with oracle and it is driving me crazy! Oh yeah, this is a Win2k server ~~ Stephenie __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle and CF5
If you're running CF Enterprise go for the native drivers. (installing oracle client on cf app server) -Original Message- From: David Hannum (Ohio University) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 5:57 PM To: CF-Talk Subject: Re: Oracle and CF5 Have you installed the Oracle client on the server? We're running CF 5 on Win2K against Oracle 7.x 8.x servers on IBM, AIX and Sun boxes. Not a problem (except for one issue on the IBM). But, you need the Oracle client installed on the server and you need a properly written TNS Names file (tnsnames.ora) that the Oracle drivers can find. If this isn't enough info, I'll be glad to expound further. Dave = David Hannum Web Analyst/Programmer Ohio University - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 5:03 PM Subject: Oracle and CF5 I have a client who is running a dedicated CF5 server and a dedicated Oracle server. We can't get CF to talk to oracle. The dsn's we setup in the ODBC control panel verify, but not through CF and CF tells me ODBC Error Code = IM003 (Specified driver could not be loaded) Specified driver could not be loaded due to system error 126 (MERANT 3.70 ColdFusion OEM 32-BIT Oracle8). Neither the DSN with the merant driver nor the dsn with the ms oracle driver will verify through CF administrator... Anyone know anything about this? This is my first time dealing with oracle and it is driving me crazy! Oh yeah, this is a Win2k server ~~ Stephenie __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle ODBC CF5 Ent
We run Oracle 8 here with CF5 Ent. You have two choices. CF Enterprise comes with Native Oracle drivers. You can also use the MS odbc drivers for Oracle. They are very solid and very fast. I've read somewhere (can't remember where) that the latest MS ODBC drivers for Oracle are actually faster with CF than the Native. We have Oracle running on IBM and as a result, we have an issue with the Native drivers, so we use the Microsoft ODBC exclusively. Dave = David Hannum Web Analyst/Programmer Ohio University Athens, OH - Original Message - From: Ray Bujarski [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 5:03 PM Subject: Oracle ODBC CF5 Ent I have CF 5 Enterprise server, I am running oracle 8 for my data server. I see the drivers (Merant Oracle 8) for creating the odbc connection, but I am unable to connect. I tried via SQLSoft no problems, I can run queries as well. I found in the installation documentation to create an alias Using the Net8 Easy Config, well when I do that I get a message saying that my tnsnames file was updated, then I am unable to connect even through my SQLSoft. I am now able to connect again using SQLSoft, but still a no go on the ODBC Connection. Does anyone know what I may be doing wrong here? Your help is very much appreciated! Macromedia really needs to get their crap together as far as the ODBC connections with oracle. I am about to switch back to perl. Worked fine for me! Ray Bujarski 858-845-7669 858-636-9900 pgr [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle ODBC CF5 Ent
I think it would probably be better to use the Oracle ODBC connector rather than the MS one. I would put money that the MS driver isn't feature complete. Kevin [EMAIL PROTECTED] 03/19/02 02:46PM We run Oracle 8 here with CF5 Ent. You have two choices. CF Enterprise comes with Native Oracle drivers. You can also use the MS odbc drivers for Oracle. They are very solid and very fast. I've read somewhere (can't remember where) that the latest MS ODBC drivers for Oracle are actually faster with CF than the Native. We have Oracle running on IBM and as a result, we have an issue with the Native drivers, so we use the Microsoft ODBC exclusively. Dave = David Hannum Web Analyst/Programmer Ohio University Athens, OH - Original Message - From: Ray Bujarski [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 5:03 PM Subject: Oracle ODBC CF5 Ent I have CF 5 Enterprise server, I am running oracle 8 for my data server. I see the drivers (Merant Oracle 8) for creating the odbc connection, but I am unable to connect. I tried via SQLSoft no problems, I can run queries as well. I found in the installation documentation to create an alias Using the Net8 Easy Config, well when I do that I get a message saying that my tnsnames file was updated, then I am unable to connect even through my SQLSoft. I am now able to connect again using SQLSoft, but still a no go on the ODBC Connection. Does anyone know what I may be doing wrong here? Your help is very much appreciated! Macromedia really needs to get their crap together as far as the ODBC connections with oracle. I am about to switch back to perl. Worked fine for me! Ray Bujarski 858-845-7669 858-636-9900 pgr [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oracle ODBC CF5 Ent
We run Oracle 8 here with CF5 Ent. You have two choices. CF Enterprise comes with Native Oracle drivers. You can also use the MS odbc drivers for Oracle. They are very solid and very fast. I've read somewhere (can't remember where) that the latest MS ODBC drivers for Oracle are actually faster with CF than the Native. We have Oracle running on IBM and as a result, we have an issue with the Native drivers, so we use the Microsoft ODBC exclusively. Are you sure you're using the Microsoft ODBC driver for Oracle, or could you be referring to the Merant ODBC wire-protocol driver for Oracle provided in CF 5? We've had bad experiences with the Microsoft ODBC driver for Oracle, and of course that's not even an option for a lot of our Oracle work, which is on Solaris. I've heard very good things about the Merant wire-protocol drivers, and have implemented them successfully against Sybase on Solaris, but haven't been able to get them to work at all against Oracle (I haven't tried too hard, either, though). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle ODBC CF5 Ent
Okay, well I finally got the MS ODBC driver working, I had to go around my head to get to my A$$ doing it. So I would venture to guess I am still doing something wrong. Native drivers, I get an error with though. It is unable to verify the connection. I tried to go into the control panel to do it and got the message Specified driver could not be loaded due to system error odbc 126(Merant 3.70 ColdFusion OEM 32-bit Oracle8) Anyone have any suggestions? I can connect using my sql soft application just fine, and MS oracle 8. However I have stored procs and triggers and such, don't I have to use native for these? At 04:49 PM 3/19/2002 -0600, you wrote: I think it would probably be better to use the Oracle ODBC connector rather than the MS one. I would put money that the MS driver isn't feature complete. Kevin [EMAIL PROTECTED] 03/19/02 02:46PM We run Oracle 8 here with CF5 Ent. You have two choices. CF Enterprise comes with Native Oracle drivers. You can also use the MS odbc drivers for Oracle. They are very solid and very fast. I've read somewhere (can't remember where) that the latest MS ODBC drivers for Oracle are actually faster with CF than the Native. We have Oracle running on IBM and as a result, we have an issue with the Native drivers, so we use the Microsoft ODBC exclusively. Dave = David Hannum Web Analyst/Programmer Ohio University Athens, OH - Original Message - From: Ray Bujarski [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 5:03 PM Subject: Oracle ODBC CF5 Ent I have CF 5 Enterprise server, I am running oracle 8 for my data server. I see the drivers (Merant Oracle 8) for creating the odbc connection, but I am unable to connect. I tried via SQLSoft no problems, I can run queries as well. I found in the installation documentation to create an alias Using the Net8 Easy Config, well when I do that I get a message saying that my tnsnames file was updated, then I am unable to connect even through my SQLSoft. I am now able to connect again using SQLSoft, but still a no go on the ODBC Connection. Does anyone know what I may be doing wrong here? Your help is very much appreciated! Macromedia really needs to get their crap together as far as the ODBC connections with oracle. I am about to switch back to perl. Worked fine for me! Ray Bujarski 858-845-7669 858-636-9900 pgr [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists