Solved

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

Posted on 2014-09-15
4
252 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Running classic asp applications under Windows Server 2008 R2 (x64) and IIS 7 is not as easy as one may think. It took me a while to figure it out while getting error 8002801d a few times. After you install the OS you will need to install the fol…
Lync server 2013 or Skype for business Backup Service Error ID 4049 – After File Share Migration
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

930 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

10 Experts available now in Live!

Get 1:1 Help Now