junaid_vengadan
Intrepid explorer

Is it possible to change fnmp database connector type in budiness adapter?

Dears ,

Is it possible to change the database connector type for connecting to FNMP database in business adapter studio ?

I can see it is connecting to DB using OLED Provider for SQL server by default, but I would like to change this to other types ( SQL OLED driver for example)

Note: the connector im referring here is not for external connecting to datasources , I want to change this for fnmp db connection itself .

Many thanks,
Junaid Vengadan
0 Kudos
2 Replies
mfranz
Shining star

Re: Is it possible to change fnmp database connector type in budiness adapter?

Hi,

You should be able to provide a "custom" connection string. With that you might be able to target a specific DSN (data source name), which you can configure in your local server ODBC settings.

Is there a specific reason you want to mess with the DB drivers?

Best regards,

Markward

Softline Group is Europe's leading independent expert in Software Asset Management.
junaid_vengadan
Intrepid explorer

Re: Is it possible to change fnmp database connector type in budiness adapter?

@mfranz 

Sorry for the delay in response 

 

Yeah we went custom string , without using the string builder (available in three dots ) as it supports only OLEDB Provider (for FNMP DB connection only) - i have reported the same to support for further action.

The reason for this approach was , the TLS connection issue was reported in the server when using OLEDB Provider (unfortunately we were not able fix the TLS issue after trying all required worksrounds)

 

Regards,

JV 

0 Kudos