Solved

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

Posted on 2014-09-15
4
259 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 28

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 28

Expert Comment

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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
WPF and Powershell button hover change text 5 63
Intermittent OleDbConnection Error 20 53
How do you think this website does searches? 5 34
CSS styling problem 3 28
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

738 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