excel error using .NET web application

S

sheetjo

Hi,
I am accesing a excel file from .NET web application. This excel file is a
used as a template with macro written inside.Following program code calls the
excel file .
ConnExcel = server.CreateObject("ADODB.Connection")
ConnExcel.ConnectionString = "Driver={Microsoft Excel Driver (*.xls)};DBQ="
& strExcelReportPath & "; ReadOnly=False;"
ConnExcel.Open

Everything works fine.But this excel gets corrupted over time and gives
error when you try to call it.

Error is "[ODBC Excel Driver]General error unable to open the registry key
'Temporary(volatile)jet DSN for process thread Excel.
By replacing the corrupted excel with a backup copy,things work fine.

Please can anyone help me as to know what makes this excel template
corrupted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel error with .NET web application 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Error msg when sending data from Excel to Access table 1
Like operator in SQL with Excel Driver 3
asp having problem accessing excel 2002 0
Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN 0
Excel Save problem from C# application 0
2147467259 Unexpected Error from external database driver [Non admin user] 2

Top