I can't use connection type "Application Server" instead of Oracle with application Designer :
PeopleTools release (8.50) for web server 'PSTOOLS' is not the same as Application Server PeopleTools release (8.50.02). Access denied.
I suspect that your Application Designer (PSIDE) is just a bare bones PeopleTools installation. It sounds like you will need to download patch 02 for 8.50 and apply it on top of your Tools installation containing PSIDE.
PeopleTools is pretty strict about versioning. It typically makes it hard for you to mix and match versions even at a minor patch level.
You may want to use direct connection within Oracle client instead of Application WSL port. It looks there is no such restriction, it could hit some issues though.
Eventhough, that's interesting, I was able to start an application server 8.50.03 onto the database delivered within the template (8.50.02) whereas I was not able to connect within AppDesigner 8.50.03 through the WSL port.
This is the poepletools versions in my environment :
1- Server side :
1-1 appserver :
- PeopleTools Application Server 8.50.02
1-2 paiserver :
- PeopleTools PIA 8.50.02
2- Client side :
Peopletools 8.50.01 ( application designer )
Nicolas you think that i should update the peopletools in the client side ? because appserver and piaserver have the same peopletools version
That's what I would have expected. PSIDE and AppServer are built off the same set of libraries. This means that a strict version (down to the patch) rule needs to be applied. This is primarily due to things like the structure of the request buffer that is exchanged between the client and server. When connecting to the DB it uses a straight ODBC connection and therefore doesn't need to worry about serialization / deserialization nuances that can affect PSIDE-AppServer connections.
As already explained by Mark, and more generally speaking, it is always better to use same version, same release and same patch level on every component, included the client. So, if you can, upgrade your client to PT8.50.02 - it is only the client anyway, it should be fast.