[THIN] Re: Using oracle databse with PS4. Will oracle continue to be supported ?

Now that we have decided that Oracle support does exist in PS4, anyone here
use it ?

Second question, anyone migrated from SQL/Access to Oracle. (I am sure
there's a guide somewhere)



On 2/27/06, Rick Mack <Rick.Mack@xxxxxxxxxxxxxx> wrote:
>
> 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
>
>  -----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&spid=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&spid=3198#appliesto%23appliesto>
>
> *Author:* Jabez Ming-Teik Gan MVP
>
> Community Solutions Content 
> Disclaimer<http://support.microsoft.com/default.aspx?scid=kb;en-us;555568&sd=rss&spid=3198#csDisclaimer%23csDisclaimer>
>
> 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.
> ------------------------------
>

Other related posts: