Solved

Web page that works in local development environment will not work on IIS 7.5

Posted on 2014-09-15
4
251 Views
Last Modified: 2014-09-18
Hello Experts,

I am hoping to get some assistance in determining why a vb.net web site I have written on my workstation will not work on an IIS 7.5 server.  Background:  I have Visual Web Developer 2010 Express installed on my system (Windows 7 Professional 64 bit).  I also have the client for our accounting package (Sage Timberline \ CRE 300) installed.  The installation of the Sage client also includes the installation of a Pervasive Workgroup Engine component in 32 bit.  My understanding from searching for support on this is that Sage has modified \ cutsomized the driver for the Pervasive engine for its use with the Sage client software.  The Sage client includes an ODBC connection driver, that we have licenses for.  Through this driver you can connect to the Timberline database through other applications (Excel, for example).

I am attempting to complete a web based application that will allow me to briefly connect to one of the Timberline tables to read the existing data from that table, and then copy two fields from that table to a local Access database, and then use the Access database for further querying and processing.  Please understand, I am not a developer by trade, and therefore may not be using what most would consider to be correct terminology and methods, apologies in advance.

I have been able to successfully complete the application on my workstation, and it is working exactly how I would like.  The problem is when I attempt to migrate it to a dedicated web server.  The server in question is Windows 2008 Standard 64 bit, with IIS 7.5 installed.  I have installed the Timberline client on the server, including the 32 bit Pervasive Workgroup engine, and have verified that the ODBC driver works when run locally on the server (ie: I created a DSN on the server to one of the test companies in the Timberline data folder and was able to successfully make a connection to the proper tables and fields using that DSN).  After creating the web site on the server, I also went into the Application Pool settings for that web site and set Enable 32-bit Applications to True.  I have tried setting Managed Pipeline Mode to both Integrated and Classic, but neither of those seem to make any difference.  

What is happening is when I attempt to make the ODBC connection from the web site, the connection fails, and often when I go back into the IIS management console, the Application Pool for the web site is stopped.  I have tried to turn on ODBC tracing to see if that yields any informaiton, but nothing is logged.  At face value, this may be a permissions \ security problem, but I have not been able to make any headway.  

Can anyone give me an idea of what the difference would be between the development environment on my system and the IIS 7.5 environment on the server with regard to running odbc connections?

Thanks very much,

Rus
0
Comment
Question by:rdillion
  • 2
  • 2
4 Comments
 
LVL 26

Accepted Solution

by:
Dan McFadden earned 500 total points
ID: 40327483
Since there is no easy way to directly answer this, I would recommend taking a look the Web Deployment Tool (http://www.iis.net/downloads/microsoft/web-deploy).  It can help you migrate the site from your DEV to PROD environment.

I would also looking into enabling Trace Failed Requests.  (http://www.iis.net/configreference/system.webserver/tracing/tracefailedrequests).  Info in the log may shed some light on the errors being generated.

Also, have you enabled general http logging on the site?  There may be useful info in the logs when looking at the 4xx and 5xx http error codes.

Other typical deployment recommendations:

1. do you have an inventory of required objects/dlls that the site uses?  are they installed on the new server?
2. are you using hard coded URLs in your code?
3. are you using absolute URLs in the application configs?
4. are the AppPools configured the same in your DEV and PROD environments?

I would start from here and go forward...

Dan
0
 

Author Comment

by:rdillion
ID: 40327857
Hey Dan,

Thanks very much for taking a look at this and your suggestions, I truly appreciate it!  Let me take a look at those and see what I can find, and will get back to you.

Respectfully,

Russ
0
 

Author Comment

by:rdillion
ID: 40330513
Hey Dan,

Thanks again very much for replying.  I am going to continue to work on your suggestions, I just have no idea how long this is going to take, and I don't want to drag this out.  I did work on some of these suggestions yesterday, but am hampered by my overall lack of familiarity with the (newer) development processes.  I've also found a few forum posts where others have run into the same problem with this particular third party product.  The fact that it does work from my local workstation makes me think that it CAN work from a dedicated web server, but I am also starting to wonder.  At any rate, thanks again.  I'll award points and close the question.

Russ
0
 
LVL 26

Expert Comment

by:Dan McFadden
ID: 40330640
Glad to be of some assistance.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now