Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
New Member
Posts: 2
Registered: ‎07-27-2012

Integrate Custom Web Service and Connection String

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

New Member
Posts: 2
Registered: ‎07-27-2012

Re: Integrate Custom Web Service and Connection String

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
Copper Super Contributor
Posts: 99
Registered: ‎07-04-2009

Re: Integrate Custom Web Service and Connection String

I believe that Namespace is in Sage.Platform.dll

 

Hope this Helps

Chris Grant


Cheers
Chris Grant
Plus Consulting