We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

OleDbConnection just hangs..

pw911
pw911 asked
on
Medium Priority
478 Views
Last Modified: 2012-05-06
Hi - I have an asp.net app that reads an Excel workbook using Jet.OLEDB. The live environment is a hosted server (W2003). This has all worked fine for 2 years+. Now when I run it, the system variously hangs or goes in a cpu-intensive loop - it never gets beyond "conn.Open()". I can't get any error message, and there's nothing in the event-log.

My code is exactly the same as before, and it runs fine in my dev environment and on another (totally different) hosted server. So obviously, I'm figuring that there's something wrong with the environment on the live server.
Does anyone have any ideas on how I might get more information on what's going on and/or how to check the install of Jet/OLEDB? (obviously, I've rebooted...)

Thanks,
Paul.
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
               "Data Source=" & FullPath & ";" & _
               "Extended Properties=""Excel 8.0;HDR=NO;IMEX=1""" 
 Dim conn As New OleDb.OleDbConnection(connstr)
  WriteToMYLogFile("here22")
   Try
    conn.Open()
     WriteToMyLogFile(here23")
     ....
Catch ex As OleDb.OleDbException
   .......

Open in new window

Comment
Watch Question

Commented:
You don't suppose that they've upgrade to a 64-bit version of Windows 2003?
I think you'll have to ask the hosting company for more details....

Author

Commented:
It IS 64-bit W2003, but it always has been. Are you aware of any incompatibilities?

Paul.

Commented:
Yes... there is no 64-bit version of the OleDB driver, so your program can not run on any 64-bit version of windows.
This is a known issue, and Microsoft has publicly stated that they will NOT produce a 64-bit version of the OleDb driver

Author

Commented:
The hosting company has confirmed (as I pretty much knew) that the OS has always been W2003 64-bit. Also, of course, I KNOW that this used to work. Any thoughts on any simple 'test-bed', etc. I can create to get more information on what is going on? Thanks.

Commented:
Ask them if they've recently changed the IIS operating mode to 64 bits...   I bet that's what has changed that has broken your code.

Author

Commented:
Thanks for your help. I ran Cscript c:\inetpub\adminscripts\adsutil.vbs GET W3SVC/Apppools/enable32bitapponwin64
This gives the result "TRUE".  Does this indicate 32 or 64-bit?

When asp.net throws an error, it indicates "Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 "

In the metabase, the only reference is
<IISApplicationPools  Location="/LM/W3SVC/AppPools"
...
   Enable32BitAppOnWin64="TRUE"

In IIS Web Service Extensions, I see:
asp.net v1.1.4322               Allowed
asp.net v2.0.50727              Prohibited
asp.net v3.0.50727 (32-bit) Allowed
Commented:
OK...it does look like IIS is running in the 32-bit compatibillity mode.   So, that's not the problem.
What's the value of FullPath in your example?

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
unresolved.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.