wep page "Could Not Find Installable ISAM"

[Steve]

I get a "Could Not Find Installable ISAM" error on my objConn.open()
statement. I suspect my connection string is bad. What I am trying to do is
write to an Excel file on my local computer from a aspx page on my web
server.

Where you see "MyComputerName" in the connection string I actually have the
name of my computer.

Dim objConn As New
System.Data.OleDb.OleDbConnection("server=MyComput erName;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp.xls;Extended Properties=Excel 8.0;")

Dim objCmd As New System.Data.OleDb.OleDbCommand

objConn.Open()

objCmd.Connection = objConn
objCmd.CommandText = "INSERT INTO [Sheet1$] (F1) values ('111')"
objCmd.ExecuteNonQuery()

objConn.Close()

Any ideas on how to correct this?

Thanks...Steve

[Paul Clement]

On Fri, 24 Sep 2004 12:43:05 -0700, "Steve" <St***@discussions.microsoft.com> wrote:

¤ I get a "Could Not Find Installable ISAM" error on my objConn.open()
¤ statement. I suspect my connection string is bad. What I am trying to do is
¤ write to an Excel file on my local computer from a aspx page on my web
¤ server.
¤
¤ Where you see "MyComputerName" in the connection string I actually have the
¤ name of my computer.
¤
¤ Dim objConn As New
¤ System.Data.OleDb.OleDbConnection("server=MyComput erName;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp.xls;Extended Properties=Excel 8.0;")
¤
¤ Dim objCmd As New System.Data.OleDb.OleDbCommand
¤
¤ objConn.Open()
¤
¤ objCmd.Connection = objConn
¤ objCmd.CommandText = "INSERT INTO [Sheet1$] (F1) values ('111')"
¤ objCmd.ExecuteNonQuery()
¤
¤ objConn.Close()
¤
¤ Any ideas on how to correct this?

I don't believe "server" is a legitimate parameter. Remove it and try the connection string again.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[sholliday]

If you run across this error thru googling (or whatever search engine).

The ISAM error could (and probably) is caused by a misformed connection
string.

String connectionString = @”Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=’C:\Sales.xls’;Extended Properties=’Excel 8.0′”;

Here is a C# version.
Notice the single quotes around the filename…AND around the Excel 8.0.

There is a space between Data and Source for “Data Source”

There is a space between Excel and 8.0 for “Excel 8.0″.

With VB.NET, experiment with the single quotes vs. the “”"” (to get one
double quote). (Where you use 4 quotes to get a double quote)

This code works in C#… (a very bad example for Data Access Code, but
good for the connection string info:

String connectionString = @”Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=’C:\Sales.xls’;Extended Properties=’Excel 8.0′”;

OleDbConnection newCon = new OleDbConnection(connectionString);

DataSet myDataSet = new DataSet();
OleDbCommand myCommand = new OleDbCommand();
myCommand.Connection = newCon;

OleDbDataAdapter myAdapter = new OleDbDataAdapter();
myAdapter.SelectCommand = myCommand;

myCommand.CommandText = “SELECT * FROM [Sheet1$]”;
try
{
newCon.Open();
myAdapter.Fill(myDataSet);
newCon.Close();
}
catch (Exception ex)
{
MessageBox.Show (ex.Message );

}
--
sholliday
------------------------------------------------------------------------
sholliday's Profile: http://www.hightechtalks.com/m375
View this thread: http://www.hightechtalks.com/t2021906