ypdev 0 Light Poster

Hi,

I am trying to connec to .mdb database using web.config but for some reason I receive
an error "Path is invalid", can you please tell me what's wrong?

**I've tried in so many ways, one of them was comment out..

<%@ WebHandler Language="C#" Class="acData" %>
using System;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.Data.OleDb;
using System.Configuration;

public class acData : IHttpHandler {
public void ProcessRequest (HttpContext context) {
    string firstname = context.Request.QueryString["nString"];
    string sql = "select top 10 name from arts where name like '" + firstname + "%'";
using (OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=db.mdb; Jet OLEDB:Database Password=pass;"))
//using (SqlConnection connection = New OleDbConnection(ConfigurationManager.ConnectionStrings("dbString").ConnectionString))
//string connStr = ConfigurationManager.ConnectionStrings["dbString"].ToString();
//SqlConnection connection = new SqlConnection(dbString);
    
    using (OleDbCommand command = new OleDbCommand(sql, connection))
{
connection.Open();
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
context.Response.Write(reader.GetString(0) + Environment.NewLine);
}
}
}
}
public bool IsReusable {
get {
return false;
}
}
}

Thanks!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.