Page 1 of 1
Web Service?
Posted: Mon Apr 12, 2010 1:13 pm
by 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.
Re: Web Service?
Posted: Tue Apr 13, 2010 9:26 pm
by 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?
Re: Web Service?
Posted: Tue Apr 27, 2010 6:20 pm
by jballamis
So I have set up the webservice exactly as described and am getting the following:

Re: Web Service?
Posted: Tue Apr 27, 2010 7:30 pm
by 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.
Re: Web Service?
Posted: Tue Apr 27, 2010 7:45 pm
by 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.
Re: Web Service?
Posted: Tue Apr 27, 2010 8:06 pm
by 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.
Re: Web Service?
Posted: Wed Apr 28, 2010 7:19 am
by jballamis
Jordan,
I get the same error when I connect both locally and remotely, both on IIS6 and IIS7.
Re: Web Service?
Posted: Wed Apr 28, 2010 8:49 am
by jordansparks
Do you have a web.config file in C:\Program Files\Open Dental ? If so, what does it look like?
Re: Web Service?
Posted: Wed Apr 28, 2010 10:03 am
by jballamis
File is missing on both servers.
Re: Web Service?
Posted: Wed Apr 28, 2010 12:36 pm
by 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?
Re: Web Service?
Posted: Wed Apr 28, 2010 12:46 pm
by 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
Re: Web Service?
Posted: Wed Apr 28, 2010 6:55 pm
by 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.
Re: Web Service?
Posted: Thu Apr 29, 2010 6:21 am
by 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.
Re: Web Service?
Posted: Thu Apr 29, 2010 2:40 pm
by 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.
Re: Web Service?
Posted: Mon May 03, 2010 7:45 am
by jballamis
This is what I get with the web.config

Re: Web Service?
Posted: Mon May 03, 2010 8:07 am
by 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.
Re: Web Service?
Posted: Mon May 03, 2010 8:16 am
by jordansparks
grahamde wrote: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.
Re: Web Service?
Posted: Mon May 03, 2010 8:54 am
by 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.
Re: Web Service?
Posted: Mon May 03, 2010 10:43 am
by 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?
Re: Web Service?
Posted: Mon May 03, 2010 10:53 am
by atd
Just tried connecting again and recevied the following error message:
The request failed with HTTP status 404: Not Found.
Re: Web Service?
Posted: Mon May 10, 2010 2:23 pm
by 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.
Re: Web Service?
Posted: Mon May 10, 2010 8:15 pm
by 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.
Re: Web Service?
Posted: Mon May 10, 2010 8:44 pm
by 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.
Re: Web Service?
Posted: Wed Jun 16, 2010 11:53 am
by 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?
Re: Web Service?
Posted: Wed Jun 16, 2010 2:12 pm
by jordansparks
Which version did you download and install?
Re: Web Service?
Posted: Wed Jun 16, 2010 2:32 pm
by jballamis
I downloaded the version that's on the Free Trial link at opendental.com
Re: Web Service?
Posted: Sat Jun 19, 2010 1:50 pm
by 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