Sql connection string SAP Business One

[Former Member]

Hi,

Is there any way to get the sql sonnection string programatically?

[former_member201110 · Accepted solution]

Hi,

There is no way to get the SQL connection string that the SBO client is using programmatically. If you are using Windows Authentication for connecting to your SQL server then you can use properties of the DI API company object to establish most of the connection settings (eg database name, SQL server name, SQL version etc) to make a connection. If you are using SQL Authentication then you will need to store user and password details separately.

Kind Regards,

Owen

[Former Member · Accepted solution]

Thanks for ur reply,

I adding a crystal report in my add-on, i am binding the records to the crystal report using dataset using sql connection. Here i want to provide the sql password to connect, but the db password which i amgetting is in asterisk.

So my problem is how to get the password to connect sql to show the report?

[former_member541807]

Hi,

Refer This......

Link: URL

Link: URL

Regards,

Fidel