Jet Driver is p?*~ing me off!!

[Rob Brown]

Hi,

I've just got started with .NET and thought I'd throw myself in at the shallow end with a nice simple ASP page which read values from an Access 2000 database.

Imagine my surprise to be confronted with that old friend of mine 'Could Not Find Installable ISAM'.

This happened to me constantly under Visual Interdev 6.0 and it seems that Microsoft haven't bothered to fix it in .NET either ( perhaps I should go out and buy a SQL server for at home, I think not ).

I'm running .NET on Win XP (although I had the same problem on 2000 so it's not the XP beta), my guest user has modify / read / write permissions to my database and the directory in which it resides, my database is not an Access 97 conversion and I'm not running Italian software (what are you talking about Microsoft??!).

Does anyone know what really causes this error, it's been the bane of my life for a couple of weeks now and I'm starting to get annoyed, what's the point of a programming language that can't access data anyway?

If anyone can help me at all then I would be very grateful.

Best regards,

Rob Brown.

:mad: :mad: :mad: :mad: :mad: :mad: :mad: :mad: :mad: :mad:

Here's my source code by the way (C#):

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace home
{
/// <summary>
/// this page is used to log users into the site
/// </summary>
public class login : Page
{
protected TextBox UserID;
protected TextBox Password;
protected Button Submit;
protected Button Reset;
private OleDbConnection WebData;
private OleDbDataAdapter UsersAdapter;
protected DataSet UsersDataSet;

public login()
{
Page.Init += new EventHandler(Page_Init);
}

private void Page_Load(object sender, EventArgs e)
{
// retrieve user information and populate the data set
WebData = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='C:\\WebData\\WebData.mdb';Uid=Admin;Pwd='';");
UsersAdapter = new OleDbDataAdapter("SELECT * FROM Users ORDER BY UserID;", WebData);
UsersDataSet = new DataSet();
UsersAdapter.Fill(UsersDataSet);
}

private void Page_Init(object sender, EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
}

#region Web Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion
}
}

:mad: :mad: :mad: :mad: :mad: :mad: :mad: :mad: :mad: :mad: