acces connection strings

Question

User-86436190 posted

Hello i want to connect with my acces database.

In my web.config file i use this code:

<connectionStrings>
  <add name="RandapparatuurConnectionString"
    connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
      Data Source=|DataDirectory|randapparatuur.mdb"
    providerName="System.Data.OleDb" />
</connectionStrings>

this is the code from my aspx file

// Ophalen van de connectiestring
            string connString = ConfigurationManager.ConnectionStrings["RandapparatuurConnectionString"].ToString();
            conn = new SqlConnection(connString);

            // Aanmaken commando

            string sql =
                "SELECT * FROM tblLector";

            SqlCommand cmd = new SqlCommand(sql, conn);

            conn.Open();

            SqlDataReader reader = cmd.ExecuteReader();

            // databinden!!

            gv.DataSource = reader;
            gv.DataBind();

            //sluiten connectie

            conn.Close();

        }

            catch(Exception ex)
        {
           lblFout.Text = ex.Message;
         }

but i get the folowwing error code: Keyword not supported: 'provider'.

when i try i with aan sql database it works.

cany somebody helps me please.

thx

Answer 1

User-60558687 posted

To connect to your access database Use OleDbConnection class not SqlConnection. SqlConnection is for Sql server database.

Similarly use OleDbCommand command instead of SqlCommand.

Answer 2

User-1199946673 posted

http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access 

Answer 3

User-1460196090 posted

Hi again.

You should have:

            // Ophalen van de connectiestring
            string connString = ConfigurationManager.ConnectionStrings["RandapparatuurConnectionString"].ToString();
            conn = new OleDbConnection(connString);

            // Aanmaken commando
            string sql = "SELECT * FROM tblLector";

            OleDbCommand cmd = new OleDbCommand(sql, conn);

            conn.Open();

            OleDbDataReader reader = cmd.ExecuteReader();

            // databinden!!

            gv.DataSource = reader;
            gv.DataBind();

            //sluiten connectie

            conn.Close();
            }
             catch (Exception ex)
            {
                 lblFout.Text = ex.Message;
            }

and don't forget to add:

using System.Data.OleDb; //instead of using System.Data.SqlClient
using System.Configuration;

Hope this helps,
Hajan

Answer 4

User1845091919 posted

Take a look at this site, you'll find plenty of settings for all sorts of databases:

http://www.connectionstrings.com/

You should find your settings there, Wolfgang

Answer 5

User-86436190 posted

thx

this problem is solved