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.Ole Db.OleDbConnect ion("server=MyC omputerName;Pro vider=Microsoft .Jet.OLEDB.4.0; Data Source=c:\temp. xls;Extended Properties=Exce l 8.0;")

Dim objCmd As New System.Data.Ole Db.OleDbCommand

objConn.Open()

objCmd.Connecti on = objConn
objCmd.CommandT ext = "INSERT INTO [Sheet1$] (F1) values ('111')"
objCmd.ExecuteN onQuery()

objConn.Close()

Any ideas on how to correct this?

Thanks...Steve

[Paul Clement]

On Fri, 24 Sep 2004 12:43:05 -0700, "Steve" <St***@discussi ons.microsoft.c om> 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.Ole Db.OleDbConnect ion("server=MyC omputerName;Pro vider=Microsoft .Jet.OLEDB.4.0; Data Source=c:\temp. xls;Extended Properties=Exce l 8.0;")
¤
¤ Dim objCmd As New System.Data.Ole Db.OleDbCommand
¤
¤ objConn.Open()
¤
¤ objCmd.Connecti on = objConn
¤ objCmd.CommandT ext = "INSERT INTO [Sheet1$] (F1) values ('111')"
¤ objCmd.ExecuteN onQuery()
¤
¤ 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******@amerit ech.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 connectionStrin g = @”Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source=’C:\Sale s.xls’;Extended Properties=’Exc el 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 connectionStrin g = @”Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source=’C:\Sale s.xls’;Extended Properties=’Exc el 8.0′”;

OleDbConnection newCon = new OleDbConnection (connectionStri ng);

DataSet myDataSet = new DataSet();
OleDbCommand myCommand = new OleDbCommand();
myCommand.Conne ction = newCon;

OleDbDataAdapte r myAdapter = new OleDbDataAdapte r();
myAdapter.Selec tCommand = myCommand;

myCommand.Comma ndText = “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