Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Could Not Find Installable ISAM

Reply
Thread Tools

Could Not Find Installable ISAM

 
 
Steve
Guest
Posts: n/a
 
      09-24-2004
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
open an Excel file on my local computer from my web server. Where you see
"MyComputerName" 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 connect to my local computer from my web server?

Thanks...Steve

 
Reply With Quote
 
 
 
 
Ray Costanzo [MVP]
Guest
Posts: n/a
 
      09-24-2004
http://www.google.com/search?q=Could...stallable+ISAM

Also, this group is for "classic" ASP. The ASP.NET groups have "aspnet" in
their names.

Ray at work

"Steve" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
> open an Excel file on my local computer from my web server. Where you see
> "MyComputerName" 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 connect to my local computer from my web server?
>
> Thanks...Steve
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Could not find installable ISAM Sandeep ASP .Net 1 05-13-2004 12:00 PM
Could not find installable ISAM. Brent ASP .Net 5 05-03-2004 03:51 PM
System.Data.OleDb.OleDbException: Could not find installable ISAM : Read Excel Spreadsheet in web-form Roger Twomey ASP .Net 1 04-27-2004 09:12 PM
Error message: Could not find installable ISAM =?Utf-8?B?SlAgTGFjYXNzZQ==?= ASP .Net 1 04-10-2004 08:08 AM
Could Not Find Installable ISAM Robert Lawson ASP .Net 6 08-29-2003 03:52 AM



Advertisments