Question

.Net access provider in IFS10

  • 15 December 2021
  • 2 replies
  • 307 views

Userlevel 1
Badge +4
  • Do Gooder
  • 5 replies

Hi All,

I want to deploy a very simple application that lists part numbers.

It talks to IFS10

To fulfill this task I wrote following code in VB.Net (written in blue below) - point is to fetch data from IFS10 and write it into data grid view on user form.

 

On execution I am getting error message: FndServerFaultException: Expectingto delimiter but found character code 69

Can you please help me to sort out the root cause or give me an advice what needs to be amended?

 

Private Sub Button_Click_1(sender As Object, e As RoutedEventArgs)

        Dim queryStr As String
        Dim IFSconn As New Global.Ifs.Fnd.AccessProvider.FndConnection
        Dim query As New Global.Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommand
        Dim response As New Global.Ifs.Fnd.Data.FndDataTable
        Dim dumy As New Global.Ifs.Fnd.Buffer.FndBuffer
        Dim dumyRows As New Global.Ifs.Fnd.Data.FndDataRowCollection
        Dim dumyRow As New Global.Ifs.Fnd.Data.FndDataRow


        IFSconn.ConnectionString = ("https://host:port")
        IFSconn.SetCredentials(userId_, psd_)
        IFSconn.CatchExceptions = False

        IFSconn.InteractiveMode = False
        IFSconn.UseCompression = False
        IFSconn.CompatibilityMode = True

 

        queryStr = " SELECT part_no FROM INVENTORY_PART "
        query.Connection = IFSconn
        query.CommandText = queryStr
        query.ExecuteReader()

 

    End Sub

 

Many thanks,

Piotr


This topic has been closed for comments

2 replies

Userlevel 1
Badge +4

Issue solved - I had to install relevant version of .Net (5.0 in this case)

Userlevel 5
Badge +17

@T2S I’m glad you were able to resolve your issue.

Considering that you are on IFSAPP10 I would highly recommend that you utilise the IFS Projections via their REST API Endpoints instead of using using the .NET Access Provider. The .NET Access provider has been removed in future releases (IFS Cloud 21R1 and later) and you will want to avoid putting in the effort into implementing a solution that will not work anymore on future upgrades. 

The REST Endpoint you will want to use is most likely this:

https://host:port/main/ifsapplications/projection/v1/InventoryPartHandling.svc/InventoryPartSet


You can also find the documentation for this particular Projection here:
https://host:port/main/ifsapplications/apidocs/?openApiUrl=https://host:port/main/ifsapplications/projection/v1/InventoryPartHandling.svc/$openapi?V3