Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

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

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
rdillion
Asked:
rdillion
  • 2
  • 2
1 Solution
 
Dan McFaddenSystems EngineerCommented:
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
 
rdillionAuthor Commented:
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
 
rdillionAuthor Commented:
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
 
Dan McFaddenSystems EngineerCommented:
Glad to be of some assistance.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now