I am having problems coding to an Access database (2000
format). I am using the Microsoft Development Enviroment
2003 and 1.1 .Net Framework.

Here is the code that I am trying:
string strConnect =
@"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\CSharp\Receipt\Test.MDB" ;
string strSQL = "SELECT * FROM Names";

try
{

OleDbDataAdapter adapter = new OleDbDataAdapter(strSQL,
strConnect);


DataSet ds = new DataSet("Names");
adapter.Fill(ds, "Names"); // never gets beyond here

string str = (string)ds.Tables["Names"].Rows[0]
["FirstName"];

DataRow newRow = ds.Tables["Names"].NewRow();
newRow["FirstName"] = "Teddy";
ds.Tables["Names"].Rows.Add(newRow);
ds.Tables["Names"].AcceptChanges();

}
catch (System.Data.OleDb.OleDbException ex)
{
MessageBox.Show(ex.Message);
Debug.WriteLine(ex.Message);
}

When this runs an exception is thrown at adapter.Fill
(...).
The message is: "IErrorInfo.GetDescription failed with
E_FAIL(0x80004005)."

I also can't open the database in the Data Connections
area of the IDE. I get an Unkown error message box.

Thanks for the help.

Paul, thanks for the input. I have tried putting the
double slashes in and the result is the same. Any other
ideas?

>-----Original Message-----
>On Tue, 15 Jul 2003 22:26:19 -0700, "sevenso"
<(E-Mail Removed)> wrote:
>
>¤ I am having problems coding to an Access database
(2000
>¤ format). I am using the Microsoft Development
Enviroment
>¤ 2003 and 1.1 .Net Framework.
>¤
>¤ Here is the code that I am trying:
>¤ string strConnect =
>¤ @"Provider=Microsoft.Jet.OLEDB.4.0;Data
>¤ Source=D:\CSharp\Receipt\Test.MDB" ;
>¤ string strSQL = "SELECT * FROM Names";
>¤
>
>In C# your file path must use double slashes instead of
a single slash:
>
>string ConnectionString;
>ConnectionString
= "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\\CSharp\Receipt\\Test.MDB";
>
>
>Paul ~~~ (E-Mail Removed)
>Microsoft MVP (Visual Basic)
>.
>

Do you have read/write permissions in the D:\Csharp\Receipt directory? You
would need this to open the database. Also have you opened the database
directly with Access? You may want to do a Compact/Repair on the database
if you have Access installed.

Ron Allen
"sevenso" <(E-Mail Removed)> wrote in message
news:08e501c34b5a$c99a2c50$(E-Mail Removed)...
> I am having problems coding to an Access database (2000
> format). I am using the Microsoft Development Enviroment
> 2003 and 1.1 .Net Framework.
>
> Here is the code that I am trying:
> string strConnect =
> @"Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=D:\CSharp\Receipt\Test.MDB" ;
> string strSQL = "SELECT * FROM Names";
>
> try
> {
>
> OleDbDataAdapter adapter = new OleDbDataAdapter(strSQL,
> strConnect);
>
>
> DataSet ds = new DataSet("Names");
> adapter.Fill(ds, "Names"); // never gets beyond here
>
> string str = (string)ds.Tables["Names"].Rows[0]
> ["FirstName"];
>
> DataRow newRow = ds.Tables["Names"].NewRow();
> newRow["FirstName"] = "Teddy";
> ds.Tables["Names"].Rows.Add(newRow);
> ds.Tables["Names"].AcceptChanges();
>
> }
> catch (System.Data.OleDb.OleDbException ex)
> {
> MessageBox.Show(ex.Message);
> Debug.WriteLine(ex.Message);
> }
>
> When this runs an exception is thrown at adapter.Fill
> (...).
> The message is: "IErrorInfo.GetDescription failed with
> E_FAIL(0x80004005)."
>
> I also can't open the database in the Data Connections
> area of the IDE. I get an Unkown error message box.
>
> Thanks for the help.
>
>

On Wed, 16 Jul 2003 06:43:39 -0700, "sevenso" <(E-Mail Removed)> wrote:

¤ Paul, thanks for the input. I have tried putting the
¤ double slashes in and the result is the same. Any other
¤ ideas?

Actually yes I do. Try enclosing the Names table with brackets - it is an ODBC reserved word:

string strSQL = "SELECT * FROM [Names]";


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)