Integrate Custom Web Service and Connection String

[seharmks]

Hello,

I'm trying to integrate custom webservice to SalesLogix 7.5 server. But I'm unable to connect to the database. Can some one please let me know the correct connection string. I'm using something like below

<add name="ConnectionInUse" connectionString="Data Source=SLX;Initial Catalog=SLX_7.5;Persist Security Info=True;User ID=sysdata; Password=Ma$t3rk3y" providerName="System.Data.SqlClient" />

The above credentials (server, db, user, pwd) works just fine when I connect through SQL Managemetn Studio. But don't work through web.config. It gave error "Login failed". Even I tried with

<add name="ConnectionInUse" connectionString="Data Source=SLX;Initial Catalog=SLX_7.5;Persist Security Info=True;providerName="System.Data.SqlClient" />

Please help me resolving that issue.

Thank you

[seharmks]

Hi,

I'm able to find the solution and see that following code works

Sage.Platform.Data.IDataService service = Sage.Platform.Application.ApplicationContext.Current.Services.Get();
IDbConnection myConnection = service.GetConnection();

but I'm unable to find the reference (.dll) of Sage.Platform.Data.IDataService

Please help. Thank you

[ChrisGrant]

I believe that Namespace is in Sage.Platform.dll

Hope this Helps

Chris Grant