Hi Carl, If that's it then someone at Citrix should be kind of embarassed ;-). Surely they'd deal with something that obvious ..... regards, Rick Ulrich Mack Volante Systems Level 2, 30 Little Cribb Street Coronation Drive Office Park Milton Qld 4064 tel: +61 7 32431847 fax: +61 7 32431992 rmack@xxxxxxxxxxxxxx <mailto:rmack@xxxxxxxxxxxxxx> -----Original Message----- From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Carl Stalhood Sent: Monday, 27 February 2006 3:18 PM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: Using oracle databse with PS4. Will oracle continue to be supported ? I found this at Microsoft. Maybe this is the culprit. http://support.microsoft.com/default.aspx?scid=kb;en-us;555568&sd=rss&sp id=3198 Programs connected to Oracle will fail to work if Oracle is installed in "Program Files (x86)" View products that this article applies to. <http://support.microsoft.com/default.aspx?scid=kb;en-us;555568&sd=rss&s pid=3198#appliesto#appliesto> Author: Jabez Ming-Teik Gan MVP Community Solutions Content Disclaimer <http://support.microsoft.com/default.aspx?scid=kb;en-us;555568&sd=rss&s pid=3198#csDisclaimer#csDisclaimer> Article ID : 555568 Last Review : February 25, 2006 Revision : 1.0 SUMMARY By default 32-bit software will be installed in the "Program Files (x86)" folder. However if Oracle is installed in the "Program Files (x86)" folder, programs connected to Oracle will fail to work. SYMPTOMS Custom programs will receive weird errors or errors that is suggesting that it can't connect to the Database. CAUSE Programs will not be able to connect to Oracle if Oracle is in a path with the brackets "(" or ")". By default, 32-bit programs will be installed in "Program Files (x86)" folder, thus causing this issue to happen. RESOLUTION Create a new folder "Program Files x86" under %systemdrive% (or C:\) and install Oracle in the folder "Program Files x86" instead of the default "Program Files (x86)". As following is the detailed steps: 1. Uninstall Oracle 2. In C:\ , create a new folder. Name it "Program Files x86" 3. Install Oracle to the folder "Program Files x86" Note: Do not install Oracle into "Program Files (x86)" ________________________________ From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Jeff Pitsch Sent: Sunday, February 26, 2006 5:20 PM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: Using oracle databse with PS4. Will oracle continue to be supported ? See I tried giving Citrix the benefit of the doubt. <sigh> Jeff On 2/26/06, Rick Mack <Rick.Mack@xxxxxxxxxxxxxx> wrote: Hi Jeff, The Oracle client runs fine on x64. Sounds like it's Citrix that dropped the ball, not Oracle. regards, Rick Ulrich Mack Volante Systems -----Original Message----- From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Jeff Pitsch Sent: Monday, 27 February 2006 2:05 AM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: Using oracle databse with PS4. Will oracle continue to be supported ? Wow, when Citrix decides to make a mistake they really grab the bull by the horns. what possible reason would they have for not support Citrix. Is it a case of Oracle not having windows 64-bit compatibility yet? Jeff On 2/26/06, Rick Mack <Rick.Mack@xxxxxxxxxxxxxx > wrote: Hi, Mathew Glenn posted the following on the Citrix support forum: Re: x64 with Oracle database Posted: Feb 6, 2006 9:33 PM I've done a bunch of testing on this before reading that little footnote in the readme (I feel dumb). What I found is basically, nothing Oracle works for a datastore using MPS x64. Here are my results: Note: Existing farm, other servers with mps 4 are connecting using Oracle 10.1 client just fine to the same datastore database. This server is being configured identically. Oracle 10.2 64 bit client: MPS 4 x64 install does not see the Oracle client as an option (because the IMA services in MPS x64 are actually 32 bit, and hence talk to 32 bit ODBC, so it can't see a 64 bit client). "DSMAINT config /user:blah /pwd:blah /dsn:blah" gives an error: "cannot connect to datastore". I had to manually create the DSN since the install didn't see Oracle. Oracle 10.2 32 bit client: MPS 4 x64 install allows you to configure for an Oracle datastore, but when starting the IMA service at the end of the install, you receive the error: "cannot connect to datastore".. "DSMAINT config /user:blah /pwd:blah /dsn:blah" gives an error: "cannot connect to datastore". Oracle 10.1 32 bit client: Same as "Oracle 10.2 32 bit client". Oracle 9.2 32 bit client: Same as "Oracle 10.2 32 bit client". So it appears that it indeed does not work. If I find a way to get around this, I'll post a reply. My guess is that Citrix will probably have a patch soon that enables this, since there are many customers using Oracle for a datastore. regards, Rick Ulrich Mack Volante Systems ________________________________ From: thin-bounce@xxxxxxxxxxxxx on behalf of Ruben Spruijt Sent: Sun 26/02/2006 18:39 To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: Using oracle databse with PS4. Will oracle continue to be supported ? Hi, It this question not in relation with Citrix PS 4.0 for Windows Server 2003 x64 ?. In the readme file is stated no Oracle support.. Ruben ________________________________ From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Jeff Pitsch Sent: Sunday, February 26, 2006 2:15 AM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: Using oracle databse with PS4. Will oracle continue to be supported ? First I've heard of Oracle being removed. I would find that highly suspect unless it came from summit solution last month. Oracle is one (if not the) largest database systems in the world. If anything, DB2 would be removed far sooner than Oracle. Jeff On 2/25/06, Andy <andysideas@xxxxxxxxx> wrote: I heard that Citrix are removing oracle support. I can't figure what to search for to validate this either way. Is anyone here using Oracle databse with PS4 ? Do you have Real Application Cluster ? Reason for asking, we already have the licences in place and the experts to hand for Oracle. We don't have the money or experts for MS SQL clustering. ######################################################################## ############# This e-mail, including all attachments, may be confidential or privileged. Confidentiality or privilege is not waived or lost because this e-mail has been sent to you in error. If you are not the intended recipient any use, disclosure or copying of this e-mail is prohibited. If you have received it in error please notify the sender immediately by reply e-mail and destroy all copies of this e-mail and any attachments. All liability for direct and indirect loss arising from this e-mail and any attachments is hereby disclaimed to the extent permitted by law. ######################################################################## ############# ________________________________ This e-mail, including all attachments, may be confidential or privileged. Confidentiality or privilege is not waived or lost because this e-mail has been sent to you in error. If you are not the intended recipient any use, disclosure or copying of this e-mail is prohibited. If you have received it in error please notify the sender immediately by reply e-mail and destroy all copies of this e-mail and any attachments. All liability for direct and indirect loss arising from this e-mail and any attachments is hereby disclaimed to the extent permitted by law. ________________________________ ##################################################################################### This e-mail, including all attachments, may be confidential or privileged. Confidentiality or privilege is not waived or lost because this e-mail has been sent to you in error. If you are not the intended recipient any use, disclosure or copying of this e-mail is prohibited. If you have received it in error please notify the sender immediately by reply e-mail and destroy all copies of this e-mail and any attachments. All liability for direct and indirect loss arising from this e-mail and any attachments is hereby disclaimed to the extent permitted by law. #####################################################################################