wep page "Could Not Find Installable ISAM"

[Guest]

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=MyComputerName;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]

¤ 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=MyComputerName;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 ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)