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...)
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)
Catch ex As OleDb.OleDbException