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 command....not 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
