tag:blogger.com,1999:blog-31216575.post8550688027150225814..comments2024-01-27T07:32:53.464+01:00Comments on On The Peoplesoft Road: Peoplesoft database connectivity part 2/3 : AppDesignerNicolas Gasparottohttp://www.blogger.com/profile/06634519580752248909noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-31216575.post-45615583376947024742014-03-10T11:56:08.075+01:002014-03-10T11:56:08.075+01:00mypeoplesoft is PeopleSoft peoplesoft internationa...mypeoplesoft is PeopleSoft <a href="http://www.mypeoplesoft.com/" rel="nofollow">peoplesoft international consultants<br /></a> is a world leading group of consultants connecting businesses with experienced and most deserving PeopleSoft developers.Anonymoushttps://www.blogger.com/profile/01369490159388220397noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-85680406563882779932010-09-10T21:08:58.451+02:002010-09-10T21:08:58.451+02:00when I run one aplication engine, it finishes inc...when I run one aplication engine, it finishes incorrect and takes a message 'Internal Error: invalid transaction handle instance passed from SamExec: 1325 vs 0<br />'<br /><br />The program do all things it have to do, but finisehes incorrect.<br /><br />¿What can I do to solve a problem?<br /><br />coud you help me please<br /><br />Somebody can help me please.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-10206043536241708592010-04-25T12:49:57.076+02:002010-04-25T12:49:57.076+02:00I was eager to know this!!Thanks a lot for providi...I was eager to know this!!Thanks a lot for providing an insight into this!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-77374354194638209792010-03-29T18:49:59.871+02:002010-03-29T18:49:59.871+02:00Thank you both of you for coming around.
Spamboy,...Thank you both of you for coming around.<br /><br />Spamboy,<br />You are absolutely right in your first remark, I should explained a little more why we need the 2tier connection.<br />In my article I only explained about the project build, and you pointed out rights others reasons. Let me try to explain what was my thought when I was writing this article. Whether all of the reasons you are talking about are very valid on development and test databases which are accessible by many people and especially by developers, they are probably much less use in more restrictive area like production environment where only the DBA team should have the need and have rights to access in 2tier mode. Furthermore, 2tier connection should not be allowed to the end users.<br />About your second remark, there is always something to be configured onto the client side, a profile (for 3tier) or database client and connectid (for the 2tier). <br />Whther database client should have been installed on developer workstation, again, I was thinking more about production environment and end users, they probably rarely need a database client, and if they need to query against the database, there is the Peoplesoft Query tool accessible in 3tier mode as well.<br />Lastly, I agree, assuming everybody can access to a central nfs point, the tnsnames.ora can be share on a network drive, but on an other hand a profile can be imported without much knowledge and we keep the users on Peoplesoft side, without adding a database layer to them.<br />I hope this clarify my article.<br /><br />Thanks again for your comments.<br /><br />Nicolas.Nicolas Gasparottohttps://www.blogger.com/profile/06634519580752248909noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-28809588996485659612010-03-29T15:51:47.024+02:002010-03-29T15:51:47.024+02:00You might wish to elaborate on the reasons one is ...You might wish to elaborate on the reasons one is forced to connect 2-Tier, which include: local running and debugging of Application Engine Programs, exporting/importing projects between environments or your local machine, and editing DDL on Records and Indexes.<br /><br />Also, configuring local clients to connect 3-Tier involves setting up connection information within the Configuration Manager, then maintaining such connection information between client installs. 2-Tier connections just leverage information within the TNSNAMES.ORA file, which can be stored on a commonly-accessed network location.Spamboyhttps://www.blogger.com/profile/06413137677121994702noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-44980039946191433382010-03-29T14:37:10.470+02:002010-03-29T14:37:10.470+02:00Thanks for the detailed explanation! Please keep t...Thanks for the detailed explanation! Please keep them coming.Roy Joslinhttp://www.pswisdom.comnoreply@blogger.com