asked on

Web service and database connection

We have a SharePoint 2010 webservice that is used to make calls to a database basically Microsoft Dynamics Navision.

The link for it is http://navdatas/Nav_Data.asmx in SharePoint.

It has various GETPO GETORDER commands that it is calling. We are moving the database of where these are talking to and I need to know how to repoint these to the new servername and database of the NAVISION DB.

I have had no luck finding a connection string anywhere to talk to this DB. Any ideas?

SOLUTION

Rainer Jeschor

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

scusack

ASKER

<?xml version="1.0"?>
<configuration>
<system.web>
<compilation debug="true" targetFramework="4.0" />
</system.web>
<system.serviceModel>
<behaviors>
<serviceBehaviors>
<behavior>
<serviceMetadata httpGetEnabled="true"/>
<serviceDebug includeExceptionDetailInFaults="false"/>
</behavior>
</serviceBehaviors>
</behaviors>
<serviceHostingEnvironment multipleSiteBindingsEnabled="true" />
</system.serviceModel>
<system.webServer>
<modules runAllManagedModulesForAllRequests="true"/>
</system.webServer>
</configuration>

scusack

ASKER

I believe it was a custom application.

Rainer Jeschor

Hm,
Looks not as usual/expected.
What's in the ASMX file?

scusack

ASKER

<%@ WebService Language="C#" CodeBehind="NAV_Data.asmx.cs" Class="NAV_DATA.Service1" %>

scusack

ASKER

Rainer,

There is a dll in the BIN file called Nava_data.dll. I think this is a compiled application where maybe the settings are that point to the DB. installed a hex editor and took a look and I do see references to our Navision database. Any idea how I would do this?

ASKER CERTIFIED SOLUTION

scusack

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rainer Jeschor

Hi,
that are not really good News, but just in case: there is a really useful tool where you can patch .NET dlls - and It could be really good in your Situation.
The tool is called ReflexIL - http://reflexil.net/

HTH
Rainer

scusack

ASKER

Once I installed .Net Reflector and decompiled the dll file I was able to see the connection string to the DB.