Click here to Skip to main content
16,012,223 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Replace cr/nl with Pin
jc.net1-Aug-07 1:48
jc.net1-Aug-07 1:48 
AnswerRe: Replace cr/nl with html break tag Pin
Jon Sagara1-Aug-07 3:22
Jon Sagara1-Aug-07 3:22 
Questionlooping in dates Pin
Sonia Gupta1-Aug-07 0:13
Sonia Gupta1-Aug-07 0:13 
AnswerRe: looping in dates Pin
Piyush Vardhan Singh1-Aug-07 0:22
Piyush Vardhan Singh1-Aug-07 0:22 
GeneralRe: looping in dates Pin
Sonia Gupta1-Aug-07 0:24
Sonia Gupta1-Aug-07 0:24 
AnswerRe: looping in dates Pin
Christian Graus1-Aug-07 0:37
protectorChristian Graus1-Aug-07 0:37 
GeneralRe: looping in dates Pin
Sonia Gupta1-Aug-07 0:38
Sonia Gupta1-Aug-07 0:38 
QuestionReading from an Excel file - ASP .net web application + win 2003 server + IIS6.0 Pin
sajithajose1-Aug-07 0:00
sajithajose1-Aug-07 0:00 
Hi All,

i am having some problems with reading data from an excel file (.xls) using my web application built using ASP .Net 1.0 (C#) . it works fine in windows XP (IIS 5.1). but when hosted in windows 2003 server (IIS 6.0) i am getting errors like "Could not find installable ISAM" , "Unspecified Error" etc. i am using C# OLEDB connection to establish a link with the excel file. i have tried almost all formats of connection strings. but the error occurs when Open() method of oledb connection is called.

some of the connection strings i used are :

"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data Source=" + excelFileName +"; Jet OLEDB:Engine Type=5;"+
"Extended Properties=\"Excel 5.0;HDR=Yes;ReadOnly=true \"";
-------------------------------------------------------------------------------------

"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data Source=" + excelFileName +";"+
"Extended Properties=" + (char)34 + "Excel 1.0;HDR=Yes;ReadOnly=true " + (char)34;
--------------------------------------------------------------------------------------
"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data Source=" + excelFileName + ";" + " Extended Properties=Excel 12.0;HDR=Yes; ReadOnly=true ";

------------------------------------------------------------------------------------------

"Provider=Microsoft.Jet.OLEDB.4.0;data source=" + excelFileName + ";" + " Extended Properties=\"Excel 2.0;HDR=Yes;ReadOnly=true \"";

----------------------------------------------------------------------------------------------

"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data Source=" + excelFileName +"; Jet OLEDB:Engine Type=5;"+
"Extended Properties=\"Excel 10.0;HDR=Yes;IMEX=1;ReadOnly= true \"";

----------------------------------------------------------------------------------------------


please help me to identify the cause of this error and a solution..

Thanks in advance
Sajitha Jose
QuestionExcel Cell formatting in Export to excel from datagrid Pin
Phanindra Kumar31-Jul-07 23:38
Phanindra Kumar31-Jul-07 23:38 
Questionhow to pass variable value to image control property Pin
harithadotnet31-Jul-07 23:14
harithadotnet31-Jul-07 23:14 
AnswerRe: how to pass variable value to image control property Pin
Christian Graus31-Jul-07 23:48
protectorChristian Graus31-Jul-07 23:48 
AnswerRe: how to pass variable value to image control property Pin
N a v a n e e t h31-Jul-07 23:50
N a v a n e e t h31-Jul-07 23:50 
AnswerRe: how to pass variable value to image control property Pin
Nand Kumar Das31-Jul-07 23:51
Nand Kumar Das31-Jul-07 23:51 
Questionhow to pass variable value to image control property Pin
vijaybhaskarmvbr31-Jul-07 23:08
vijaybhaskarmvbr31-Jul-07 23:08 
QuestionVS 2008 and .NET 3.5 Beta 2 Released Pin
kalyan_241631-Jul-07 23:07
kalyan_241631-Jul-07 23:07 
AnswerRe: VS 2008 and .NET 3.5 Beta 2 Released Pin
Mircea Grelus31-Jul-07 23:27
Mircea Grelus31-Jul-07 23:27 
GeneralRe: VS 2008 and .NET 3.5 Beta 2 Released Pin
kalyan_241631-Jul-07 23:44
kalyan_241631-Jul-07 23:44 
GeneralRe: VS 2008 and .NET 3.5 Beta 2 Released Pin
Mircea Grelus31-Jul-07 23:47
Mircea Grelus31-Jul-07 23:47 
QuestionCertificate Authentication Pin
Malayil alex31-Jul-07 22:52
Malayil alex31-Jul-07 22:52 
QuestionMultiline Text Box Pin
itzmevishu31-Jul-07 22:37
itzmevishu31-Jul-07 22:37 
AnswerRe: Multiline Text Box Pin
Piyush Vardhan Singh31-Jul-07 22:43
Piyush Vardhan Singh31-Jul-07 22:43 
GeneralRe: Multiline Text Box Pin
itzmevishu31-Jul-07 22:49
itzmevishu31-Jul-07 22:49 
GeneralRe: Multiline Text Box Pin
Piyush Vardhan Singh31-Jul-07 23:10
Piyush Vardhan Singh31-Jul-07 23:10 
GeneralRe: Multiline Text Box Pin
itzmevishu1-Aug-07 0:43
itzmevishu1-Aug-07 0:43 
Questionmoving hyperlink list Pin
Ahmad Adnan31-Jul-07 22:08
Ahmad Adnan31-Jul-07 22:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.