Could not find installable ISAM

  • Thread starter Thread starter Jason James
  • Start date Start date
J

Jason James

Hi all,

I am creating an ASP web service and wish to connect
to an MS Access 2003 database. However, when I
attempt to access the database I get the following
error

"Could not find installable ISAM"

I found this on a Microsoft web site.

"Although you cannot link a database object to either
Microsoft Internet Information Services (.htx, .idc) or
Microsoft Active Server Pages (.asp) output formats,
you can export (export: To output data and database
objects to another database, spreadsheet, or file
format so another database or program can use the
data or database objects. You can export data to a
variety of supported databases, programs, and file
formats.) the object to the desired output format and
then attach the file in a mail program, such as
Microsoft Office Outlook 2003. "

Is it true? Do I have to use SQL server for my webservices?

If I can use MS Access 2003 database files, how do
I connect to them?

Thanks,

Jason.
 
On Fri, 15 Apr 2005 08:28:07 GMT, (e-mail address removed) (Jason James) wrote:

¤ Hi all,
¤
¤ I am creating an ASP web service and wish to connect
¤ to an MS Access 2003 database. However, when I
¤ attempt to access the database I get the following
¤ error
¤
¤ "Could not find installable ISAM"
¤
¤ I found this on a Microsoft web site.
¤
¤ "Although you cannot link a database object to either
¤ Microsoft Internet Information Services (.htx, .idc) or
¤ Microsoft Active Server Pages (.asp) output formats,
¤ you can export (export: To output data and database
¤ objects to another database, spreadsheet, or file
¤ format so another database or program can use the
¤ data or database objects. You can export data to a
¤ variety of supported databases, programs, and file
¤ formats.) the object to the desired output format and
¤ then attach the file in a mail program, such as
¤ Microsoft Office Outlook 2003. "
¤
¤ Is it true? Do I have to use SQL server for my webservices?
¤
¤ If I can use MS Access 2003 database files, how do
¤ I connect to them?


You may have a syntax problem with your connection string which will cause this particular error to
occur.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Paul,

Thanks for the info.

I tried the same connection, command, dataadapter and
dataset settings in a windows app (not windows service) and
all worked fine.

If I change to use a SQL connection to a SQL DB, change
everything that needs to be and add ASPNET as a
user of the database then all works great through
my service.


Any other thoughts?

Thanks,

Jason.
 
On Fri, 15 Apr 2005 15:07:11 GMT, (e-mail address removed) (Jason James) wrote:

¤ Paul,
¤
¤ Thanks for the info.
¤
¤ I tried the same connection, command, dataadapter and
¤ dataset settings in a windows app (not windows service) and
¤ all worked fine.
¤
¤ If I change to use a SQL connection to a SQL DB, change
¤ everything that needs to be and add ASPNET as a
¤ user of the database then all works great through
¤ my service.
¤
¤
¤ Any other thoughts?

I would have to see a connection string sample that isn't working for you.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top