Skip to main content
Question

.Net access provider in IFS10

  • December 15, 2021
  • 2 replies
  • 344 views

Forum|alt.badge.img+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

Forum|alt.badge.img+4
  • Author
  • Do Gooder
  • 5 replies
  • December 15, 2021

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


Jonas Feigl
Superhero (Employee)
Forum|alt.badge.img+20
  • Superhero (Employee)
  • 261 replies
  • December 15, 2021

@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings