Sybase ASE 15.7.0 MSIX Package

%3CLINGO-SUB%20id%3D%22lingo-sub-1259395%22%20slang%3D%22en-US%22%3ESybase%20ASE%2015.7.0%20MSIX%20Package%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1259395%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe're%20doing%20a%20POC%20of%20MSIX%20at%20the%20moment%20in%20our%20company.%20We%20currently%20use%20a%20mixture%20of%20App-V%205.x%20and%20MSI%20and%20are%20looking%20at%20possibly%20implementing%20MSIX%20if%20it%20suits.%20At%20the%20moment%20we%20are%20having%20a%20number%20of%20issues%20relating%20to%20the%20Sybase%20ASE%2015.7.0%20database%20client.%20It%20is%20a%20pre-req%20to%20most%20of%20our%20in-house%20developed%20applications%20so%20it%20is%20critical%20that%20we%20get%20it%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20of%20the%20issues%20are%3B%3C%2FP%3E%3CP%3E1)%20Sybase%20uses%20multiple%20environment%20variables%20and%20the%20%25Path%25%20variable%20to%20locate%20its%20files.%20This%20is%20currently%20unsupported.%20Are%20there%20any%20plans%20to%20add%20this%20functionality%20for%20application%20specific%20Environment%20variables%3F%20e.g.%20from%20App-V%20package%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%3CENVIRONMENTVARIABLES%20enabled%3D%22%26quot%3Btrue%26quot%3B%22%3E%3C%2FENVIRONMENTVARIABLES%3E%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CINCLUDE%3E%3C%2FINCLUDE%3E%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CVARIABLE%20name%3D%22%26quot%3BSYBASE_JRE6_32%26quot%3B%22%20value%3D%22%26quot%3B%5B%7BAppVPackageRoot%7D%5D%5CVFS%5CAppVPackageDrive%5CSybase%5CShared%5CJRE-6_0_24_32BIT%26quot%3B%22%3E%3C%2FVARIABLE%3E%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CVARIABLE%20name%3D%22%26quot%3BLIB%26quot%3B%22%20value%3D%22%26quot%3B%5B%7BAppVPackageRoot%7D%5D%5CVFS%5CAppVPackageDrive%5CSybase%5COCS-15_0%5Clib%26quot%3B%22%3E%3C%2FVARIABLE%3E%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CVARIABLE%20name%3D%22%26quot%3BSYBASE_ASE%26quot%3B%22%20value%3D%22%26quot%3BASE-15_0%26quot%3B%22%3E%3C%2FVARIABLE%3E%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CVARIABLE%20name%3D%22%26quot%3BSCROOT%26quot%3B%22%20value%3D%22%26quot%3B%5B%7BAppVPackageRoot%7D%5D%5CVFS%5CAppVPackageDrive%5CSybase%5CShared%5CSybase%22%20central%3D%22%22%206.0.0%3D%22%22%3E%3C%2FVARIABLE%3E%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CVARIABLE%20name%3D%22%26quot%3BSYBASE%26quot%3B%22%20value%3D%22%26quot%3B%5B%7BAppVPackageRoot%7D%5D%5CVFS%5CAppVPackageDrive%5CSybase%26quot%3B%22%3E%3C%2FVARIABLE%3E%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CVARIABLE%20name%3D%22%26quot%3BSYBASE_OCS%26quot%3B%22%20value%3D%22%26quot%3BOCS-15_0%26quot%3B%22%3E%3C%2FVARIABLE%3E%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CVARIABLE%20name%3D%22%26quot%3BSYBASE_JRE6%26quot%3B%22%20value%3D%22%26quot%3B%5B%7BAppVPackageRoot%7D%5D%5CVFS%5CAppVPackageDrive%5CSybase%5CShared%5CJRE-6_0_24_32BIT%26quot%3B%22%3E%3C%2FVARIABLE%3E%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CVARIABLE%20name%3D%22%26quot%3BINCLUDE%26quot%3B%22%20value%3D%22%26quot%3B%5B%7BAppVPackageRoot%7D%5D%5CVFS%5CAppVPackageDrive%5CSybase%5COCS-15_0%5Cinclude%26quot%3B%22%3E%3C%2FVARIABLE%3E%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3CVARIABLE%20name%3D%22%26quot%3BSYBROOT%26quot%3B%22%20value%3D%22%26quot%3B%5B%7BAppVPackageRoot%7D%5D%5CVFS%5CAppVPackageDrive%5CSybase%26quot%3B%22%3E%3C%2FVARIABLE%3E%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CVARIABLE%20name%3D%22%26quot%3BPATH%26quot%3B%22%20value%3D%22%26quot%3B%25PATH%25%3B%5B%7BAppVPackageRoot%7D%5D%5CVFS%5CAppVPackageDrive%5CSybase%5Cini%3B%5B%7BAppVPackageRoot%7D%5D%5CVFS%5CAppVPackageDrive%5CSybase%5CDataAccess%5COLEDB%5Cdll%3B%5B%7BAppVPackageRoot%7D%5D%5CVFS%5CAppVPackageDrive%5CSybase%5COCS-15_0%5Clib3p%3B%5B%7BAppVPackageRoot%7D%5D%5CVFS%5CAppVPackageDrive%5CSybase%5COCS-15_0%5Cdll%3B%5B%7BAppVPackageRoot%7D%5D%5CVFS%5CAppVPackageDrive%5CSybase%5COCS-15_0%5Cbin%26quot%3B%22%3E%3C%2FVARIABLE%3E%3C%2FP%3E%3CP%20class%3D%22yiv3089843500MsoNormal%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20We%20are%20using%20SCCM%20Virtual%20Environments%20to%20link%20our%20Sybase%20package%20to%20our%20different%20In-House%20applications.%20Currently%20this%20is%20unsupported%20in%20MSIX%20but%20this%20functionality%20is%20being%20developed%20I%20believe.%20Does%20anyone%20have%20an%20update%20on%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%20%2C%3C%2FP%3E%3CP%3EPol.%3C%2FP%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1259814%22%20slang%3D%22en-US%22%3ERe%3A%20Sybase%20ASE%2015.7.0%20MSIX%20Package%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1259814%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F597667%22%20target%3D%22_blank%22%3E%40obreaslainp%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMSIX%20Flexible%20Containers%20(working%20name)%20is%20currently%20under%20development.%26nbsp%3B%20It%20will%20ship%20in%20an%20upcoming%20Windows%20release%2C%20but%20it%20is%20not%20part%20of%20the%20current%20spring%20release.%26nbsp%3B%20Watch%20the%20blog%20for%20an%20announcement%20when%20it%20is%20available%20in%20insider%20builds.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20the%20environment%20variables%2C%20please%20add%20an%20item%20to%20the%20ideas%20section%20and%20we%20can%20track%20it%20with%20our%20backlog.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJohn.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi Guys,

 

We're doing a POC of MSIX at the moment in our company. We currently use a mixture of App-V 5.x and MSI and are looking at possibly implementing MSIX if it suits. At the moment we are having a number of issues relating to the Sybase ASE 15.7.0 database client. It is a pre-req to most of our in-house developed applications so it is critical that we get it working.

 

Some of the issues are;

1) Sybase uses multiple environment variables and the %Path% variable to locate its files. This is currently unsupported. Are there any plans to add this functionality for application specific Environment variables? e.g. from App-V package

 

<EnvironmentVariables Enabled="true">

        <Include>

          <Variable Name="SYBASE_JRE6_32" Value="[{AppVPackageRoot}]\VFS\AppVPackageDrive\Sybase\Shared\JRE-6_0_24_32BIT" />

          <Variable Name="LIB" Value="[{AppVPackageRoot}]\VFS\AppVPackageDrive\Sybase\OCS-15_0\lib" />

          <Variable Name="SYBASE_ASE" Value="ASE-15_0" />

          <Variable Name="SCROOT" Value="[{AppVPackageRoot}]\VFS\AppVPackageDrive\Sybase\Shared\Sybase Central 6.0.0" />

          <Variable Name="SYBASE" Value="[{AppVPackageRoot}]\VFS\AppVPackageDrive\Sybase" />

          <Variable Name="SYBASE_OCS" Value="OCS-15_0" />

          <Variable Name="SYBASE_JRE6" Value="[{AppVPackageRoot}]\VFS\AppVPackageDrive\Sybase\Shared\JRE-6_0_24_32BIT" />

          <Variable Name="INCLUDE" Value="[{AppVPackageRoot}]\VFS\AppVPackageDrive\Sybase\OCS-15_0\include" />

          <Variable Name="SYBROOT" Value="[{AppVPackageRoot}]\VFS\AppVPackageDrive\Sybase" />

          <Variable Name="PATH" Value="%PATH%;[{AppVPackageRoot}]\VFS\AppVPackageDrive\Sybase\ini;[{AppVPackageRoot}]\VFS\AppVPackageDrive\Sybase\DataAccess\OLEDB\dll;[{AppVPackageRoot}]\VFS\AppVPackageDrive\Sybase\OCS-15_0\lib3p;[{AppVPackageRoot}]\VFS\AppVPackageDrive\Sybase\OCS-15_0\dll;[{AppVPackageRoot}]\VFS\AppVPackageDrive\Sybase\OCS-15_0\bin" />

        </Include>

 

2) We are using SCCM Virtual Environments to link our Sybase package to our different In-House applications. Currently this is unsupported in MSIX but this functionality is being developed I believe. Does anyone have an update on this?

 

Thanks in advance.

 

Best regards ,

Pol.

1 Reply

@obreaslainp 

 

MSIX Flexible Containers (working name) is currently under development.  It will ship in an upcoming Windows release, but it is not part of the current spring release.  Watch the blog for an announcement when it is available in insider builds.

 

For the environment variables, please add an item to the ideas section and we can track it with our backlog.

 

John.