Web Service?

[atd]

Is anyone using the Web Service successfully? I'm on my second attempt to get it running (following the instructions on opendental.com) with no luck.

[jordansparks]

Yes, some offices are using it successfully. Can you give any further information on what step is failing? Did step 3 work? Did the bin folder show up? Any trouble with step 4 user login? Or is it step 9? Maybe the URI is simply wrong?

[jballamis]

So I have set up the webservice exactly as described and am getting the following:

[jordansparks]

Someone should be calling you tomorrow to help you with this. I think it's a missing web.config file that we need to post in the instructions, but someone needs to get on your computer and take a look at the web.config file that's there already.

[atd]

Yes, that's exactly what I'm getting also. Sorry I haven't had time to call into support to follow-up on this since my original post. I'm on vacation the rest of this week but will be in touch when I'm back next week.

[jordansparks]

Oh. Whoops. I thought that screenshot was from atd. So we won't be calling you, jballamis, because we don't have your phone number. But we will do a little research into the web.config file and try to alter the instructions even without a test computer. But that error says that you are connecting from a remote machine. Wouldn't you first connect from the local machine? And if you did so, I think it would show the error message which is now being blocked by security.

[jballamis]

Jordan,

I get the same error when I connect both locally and remotely, both on IIS6 and IIS7.

[jordansparks]

Do you have a web.config file in C:\Program Files\Open Dental ? If so, what does it look like?

[jballamis]

File is missing on both servers.

[grahamde]

Actually, our web service is working without a Web.config file. Does the C:\Program Files\Open Dental\bin\ directory exist? If so, what files do you see and what are their versions?

[jballamis]

CDT.DLL --> 1.0.0.0
CodeBase.DLL --> 6.4.0.0
MySQL.DLL --> 1.0.9.0
OpenDentalServer.DLL --> 6.8.0.0
OpenDentalServerConfig.xml
OpenDentBusiness.DLL --> 6.9.22.0

[jordansparks]

But adding a web.config file will allow us to see the actual error instead of that generic message. Once we know what the error is, we can address it.

[grahamde]

Our server has the following files and versions:

CDT.dll 7.0.1.0
CodeBase.dll 6.4.0.0
Mysql.data.dll 1.0.9.0
OpenDentalServer.dll 7.0.1.0
OpenDentBusiness.dll 7.0.23.0

It looks like your CDT.dll file is either way out of date, or we were not tracking the CDT version back in the release of 6.9.
I also find it strange that your OpenDentalServer.dll and OpenDentBusiness.dll are for differing versions of the software.
We do not have a copy of the OpenDentalServerConfig.xml within our bin directory, but this doesn't matter.
Are you currently upgraded to the latest version of 6.9?
Perhaps the web service will function better for you if you upgraded to version 7.0, as we are using. I know it is a beta
version but it has been around for a while and the number of bugs is starting to get small.

[jordansparks]

6.9 should be every bit as functional as 7.0. As for the CDT, that may be because it's a foreign version. I think we need to add a Web.config file in order to debug. Here's what the Web.config file looks like on my computer:

Code: Select all

<?xml version="1.0"?>
<configuration>
	<appSettings/>
	<connectionStrings/>
	<system.web>
		<!-- 
            Set compilation debug="true" to insert debugging 
            symbols into the compiled page. Because this 
            affects performance, set this value to true only 
            during development.
        -->
		<compilation debug="true">
		</compilation>
		<!--
            The <authentication> section enables configuration 
            of the security authentication mode used by 
            ASP.NET to identify an incoming user. 
        -->
		<authentication mode="Windows"/>
		<!--
            The <customErrors> section enables configuration 
            of what to do if/when an unhandled error occurs 
            during the execution of a request. Specifically, 
            it enables developers to configure html error pages 
            to be displayed in place of a error stack trace.

        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
        -->
	</system.web>
</configuration>

But according the the previous html page, this line
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
should be changed to
<customErrors mode="Off" defaultRedirect="GenericErrorPage.htm">
so that you can see what the error is.

[jballamis]

This is what I get with the web.config

[jordansparks]

That was so helpful. One of us will have to remotely connect to someone having this problem and just start plugging away at it. Once we find the solution, we'll post it for everyone else.

[jordansparks]

Our server has the following files and versions:
OpenDentalServer.dll 7.0.1.0
OpenDentBusiness.dll 7.0.23.0

That's wrong. Both of those files should have the exact same file version. 7.0.23.0.

[jordansparks]

OK, I found out why the versions are different. Our installer will be fixed in the next few hours so that those two files have the same version. So that might be the problem. However, that doesn't explain why the web service works fine at our office and some other offices in spite of the file version mismatch.

[atd]

No, I don't have a web.config file - can you tell me what this should look like and where I can get it?

[atd]

Just tried connecting again and recevied the following error message:
The request failed with HTTP status 404: Not Found.

[atd]

Just wanted to give an update on this. With the help of OD support I was able to get the web service running. The two issues were:
1) Needed to specify a port number for the server (80 was being used for something else) in the URI.
2) Needed to change "localhost" to the servername in the OpenDentalServerConfig.xml file.
Unfortunately I found the web service to be too slow and buggy to use at our remote offices. Lots of unhandled exceptions (i.e. could not create a claim). Some modules worked fast (family and account), but switching to the treatment plan and chart modules took a good 30 seconds. Hopefully future releases will improve on this - we'll give it another try down the road.

[jordansparks]

Wow. I'm surprised that it was slow. We can introduce some stress testing to try to duplicate what you experienced.

Any errors are very easy to fix on our end once we know about them. I'll look into the problem creating a claim.

[atd]

Thank you.
I also got an error opening the Manage->Send Claims window.
Another when switching from a standard connection to the web service (when a patient record was loaded) - although just clicking Continue worked there.
The slowest part was definitely opening the treatment plan module, 2nd slowest was the Chart and of course Images. The appointment module performed much better than I expected. Family and Account were pretty good. The main benefit of the web service (over terminal server) was printing reports, treatment plans, letters, etc. That was much faster.

[jballamis]

I revisited this issue today and am getting the same error after redownloading and reinstalling.

Is there an alternate download location with the revisions that were made in a previous post?

[jordansparks]

Which version did you download and install?

[jballamis]

I downloaded the version that's on the Free Trial link at opendental.com

[jordansparks]

That is version 6.9.22. Version 6.9 is acceptable, but a more recent build would be required. Version 6.9 is currently at about 6.9.42. The trial version is not acceptable to use for evaluating the web service. To see the bug fixes that were released between 6.9.22 and 6.9.42, see http://opendentalsoft.com:1942/ODBugTra ... sions.aspx