I'd like to create an Ado.net SqlClient connection for SAP Company DB and maintain my own UDT, I can not using SQL security authentication, becaust DBPassword property in SAP DI API company object is not a real password string, just a string of "******" (is there any way to get DBPassword?), So I change to use Integrated Windows authentication, below is my connectionstring:
Dim cn As New SqlClient.SqlConnection cn.ConnectionString ="data source=Test_Workstation;initial catalog = SBODemo_US; Integrated Security=SSPI;persist security info=False;"
but this connection string still have problem when connect to company DB server, if current windows user does not have right to login to the company DB server. it shows Login failed error. but I can run SAP to the company DB Server. Who can give me some sugestion create a safe and Stable connection to SAP DB using ADO.Net.
Thanks in advance!