|
 |
access thread: Could not find installable ISAM
Message #1 by laurasilver@c... on Tue, 22 Oct 2002 16:50:03
|
|
Please can somebody help me out - I can't get my dissertation project
application working... I've created a web app which is supposed to read
data into a datagrid when the user clicks a button in the GUI. I'm using
an Access database, C# and VS.NET. Trouble is, on clicking the button I
get the message "Could not find installable ISAM". Does anyone know what
this means or how to fix it?
Thank you so much in advance,
Laura :)
Code from the code-behind GeneralUser.aspx is below:
OleDbDataReader reader = res.queryResource(queryType);
dataGrid1.DataSource = reader;
dataGrid1.DataBind();
dataGrid1.Visible = true;
resultsLabel.Visible = true;
resultsLabel.Text = "Results for: "+ queryType;
The actual dataread method is contained within a separate class: Resource
try
{
String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;data
source=C:\\Documents and Settings\\laurasilver\\My
Documents\\Resource.mdb;";
myDbConnection = new OleDbConnection(connectionString);
String strSQL = "SELECT ResourceName, ResourceDescription,
ResourceAddress" + "FROM Resource.Resource WHERE
Restricted = false AND ResourceType ="+ queryType +" ORDER BY
ResourceName";
OleDbCommand objCommand = new OleDbCommand (strSQL,
myDbConnection);
objCommand.CommandType = CommandType.Text;
//open database connection
myDbConnection.Open();
return objCommand.ExecuteReader();
}
// if database cannot be located
catch (OleDbException e)
{
ResourceException resException1 = new ResourceException("There
is a problem loading the database. Please notify the Module Tutor.", e);
throw resException1;
}
//always close database connection
finally
{
myDbConnection.Close();
}
Message #2 by laurasilver@c... on Tue, 22 Oct 2002 16:51:40
|
|
Please can somebody help me out - I can't get my dissertation project
application working... I've created a web app which is supposed to read
data into a datagrid when the user clicks a button in the GUI. I'm using
an Access database. Trouble is, on clicking the button I get the
message "Could not find installable ISAM". Does anyone know what this
means or how to fix it?
Thank you so much in advance,
Laura :)
Code from the code-behind GeneralUser.aspx is below:
OleDbDataReader reader = res.queryResource(queryType);
dataGrid1.DataSource = reader;
dataGrid1.DataBind();
dataGrid1.Visible = true;
resultsLabel.Visible = true;
resultsLabel.Text = "Results for: "+ queryType;
The actual dataread method is contained within a separate class: Resource
try
{
String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;data
source=C:\\Documents and Settings\\laurasilver\\My
Documents\\Resource.mdb;";
myDbConnection = new OleDbConnection(connectionString);
String strSQL = "SELECT ResourceName, ResourceDescription,
ResourceAddress" + "FROM Resource.Resource WHERE
Restricted = false AND ResourceType ="+ queryType +" ORDER BY
ResourceName";
OleDbCommand objCommand = new OleDbCommand (strSQL,
myDbConnection);
objCommand.CommandType = CommandType.Text;
//open database connection
myDbConnection.Open();
return objCommand.ExecuteReader();
}
// if database cannot be located
catch (OleDbException e)
{
ResourceException resException1 = new ResourceException("There
is a problem loading the database. Please notify the Module Tutor.", e);
throw resException1;
}
//always close database connection
finally
{
myDbConnection.Close();
}
Message #3 by "Derrick Flores" <Derrick_Flores@s...> on Tue, 22 Oct 2002 13:46:41 -0500
|
|
What version of Access do you have 2000 or 2002?
Derrick
>>> laurasilver@c... 10/22/02 04:50PM >>>
Please can somebody help me out - I can't get my dissertation project
application working... I've created a web app which is supposed to
read
data into a datagrid when the user clicks a button in the GUI. I'm
using
an Access database, C# and VS.NET. Trouble is, on clicking the button
I
get the message "Could not find installable ISAM". Does anyone know
what
this means or how to fix it?
Thank you so much in advance,
Laura :)
Code from the code-behind GeneralUser.aspx is below:
OleDbDataReader reader =3D res.queryResource(queryType);
dataGrid1.DataSource =3D reader;
dataGrid1.DataBind();
dataGrid1.Visible =3D true;
resultsLabel.Visible =3D true;
resultsLabel.Text =3D "Results for: "+ queryType;
The actual dataread method is contained within a separate class: Resource
try
{
String connectionString =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;d
ata
source=3DC:\\Documents and Settings\\laurasilver\\My
Documents\\Resource.mdb;";
myDbConnection =3D new OleDbConnection(connectionString);
String strSQL =3D "SELECT ResourceName, ResourceDescription,=09
=09
ResourceAddress" + "FROM Resource.Resource WHERE
Restricted =3D false AND ResourceType =3D"+ queryType +" ORDER BY
ResourceName";
=09
OleDbCommand objCommand =3D new OleDbCommand (strSQL,
myDbConnection);
objCommand.CommandType =3D CommandType.Text;=09
=09
=09
//open database connection
myDbConnection.Open();
=09
return objCommand.ExecuteReader();
=09
}
// if database cannot be located
catch (OleDbException e)
{
ResourceException resException1 =3D new ResourceException("There
is a problem loading the database. Please notify the Module Tutor.", e);
throw resException1;
=09
}
=09
//always close database connection
=09
finally
{=09
myDbConnection.Close();
}
Message #4 by "Derrick Flores" <Derrick_Flores@s...> on Tue, 22 Oct 2002 13:50:22 -0500
|
|
Laura,
I had this problem before, "ISAM drivers are used by Access to update
file formats other than its own. If the path to the ISAM driver in your
Windows registry is invalid, or if the ISAM driver does not exist, you may
receive the following error messages" . You can go to Microsoft Knowledge
Base website and look up article Q283881. This will help you out on
solving your problem.
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;Q283881
Good Luck,
Derrick Flores
Sony Navigator
San Antonio
>>> laurasilver@c... 10/22/02 04:50PM >>>
Please can somebody help me out - I can't get my dissertation project
application working... I've created a web app which is supposed to
read
data into a datagrid when the user clicks a button in the GUI. I'm
using
an Access database, C# and VS.NET. Trouble is, on clicking the button
I
get the message "Could not find installable ISAM". Does anyone know
what
this means or how to fix it?
Thank you so much in advance,
Laura :)
Code from the code-behind GeneralUser.aspx is below:
OleDbDataReader reader =3D res.queryResource(queryType);
dataGrid1.DataSource =3D reader;
dataGrid1.DataBind();
dataGrid1.Visible =3D true;
resultsLabel.Visible =3D true;
resultsLabel.Text =3D "Results for: "+ queryType;
The actual dataread method is contained within a separate class: Resource
try
{
String connectionString =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;d
ata
source=3DC:\\Documents and Settings\\laurasilver\\My
Documents\\Resource.mdb;";
myDbConnection =3D new OleDbConnection(connectionString);
String strSQL =3D "SELECT ResourceName, ResourceDescription,=09
=09
ResourceAddress" + "FROM Resource.Resource WHERE
Restricted =3D false AND ResourceType =3D"+ queryType +" ORDER BY
ResourceName";
=09
OleDbCommand objCommand =3D new OleDbCommand (strSQL,
myDbConnection);
objCommand.CommandType =3D CommandType.Text;=09
=09
=09
//open database connection
myDbConnection.Open();
=09
return objCommand.ExecuteReader();
=09
}
// if database cannot be located
catch (OleDbException e)
{
ResourceException resException1 =3D new ResourceException("There
is a problem loading the database. Please notify the Module Tutor.", e);
throw resException1;
=09
}
=09
//always close database connection
=09
finally
{=09
myDbConnection.Close();
}
Message #5 by "Laura Bond" <laurasilver@c...> on Wed, 23 Oct 2002 12:16:10 +0100
|
|
Derrick,
Thank you so much for writing back. When I hadn't had a reply for a
while I did a search on Google. I'd tried before but this time came up
with something and I solved it - but I now have a different error
message! I'll post it on the site rather than bother you personally.
But in any case, I just wanted to thank you.
Laura :)
-----Original Message-----
From: Derrick Flores [mailto:Derrick_Flores@s...]
Sent: 22 October 2002 19:50
To: Access
Subject: [access] Re: Could not find installable ISAM
Laura,
I had this problem before, "ISAM drivers are used by Access to
update file formats other than its own. If the path to the ISAM driver
in your Windows registry is invalid, or if the ISAM driver does not
exist, you may receive the following error messages" . You can go to
Microsoft Knowledge Base website and look up article Q283881. This will
help you out on solving your problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283881
Good Luck,
Derrick Flores
Sony Navigator
San Antonio
>>> laurasilver@c... 10/22/02 04:50PM >>>
Please can somebody help me out - I can't get my dissertation project
application working... I've created a web app which is supposed to read
data into a datagrid when the user clicks a button in the GUI. I'm
using
an Access database, C# and VS.NET. Trouble is, on clicking the button I
get the message "Could not find installable ISAM". Does anyone know
what
this means or how to fix it?
Thank you so much in advance,
Laura :)
Code from the code-behind GeneralUser.aspx is below:
OleDbDataReader reader = res.queryResource(queryType);
dataGrid1.DataSource = reader;
dataGrid1.DataBind();
dataGrid1.Visible = true;
resultsLabel.Visible = true;
resultsLabel.Text = "Results for: "+ queryType;
The actual dataread method is contained within a separate class:
Resource
try
{
String connectionString
"Provider=Microsoft.Jet.OLEDB.4.0;data
source=C:\\Documents and Settings\\laurasilver\\My
Documents\\Resource.mdb;";
myDbConnection = new OleDbConnection(connectionString);
String strSQL = "SELECT ResourceName, ResourceDescription,
ResourceAddress" + "FROM Resource.Resource WHERE
Restricted = false AND ResourceType ="+ queryType +" ORDER BY
ResourceName";
OleDbCommand objCommand = new OleDbCommand (strSQL,
myDbConnection);
objCommand.CommandType = CommandType.Text;
//open database connection
myDbConnection.Open();
return objCommand.ExecuteReader();
}
// if database cannot be located
catch (OleDbException e)
{
ResourceException resException1 = new ResourceException("There
is a problem loading the database. Please notify the Module Tutor.",
e);
throw resException1;
}
//always close database connection
finally
{
myDbConnection.Close();
}
|
|
|
View Cart
