Microsoft Access with ASP.net

Ask a Question related to ASP.NET General, Design and Development.

  1. #1

    Default Microsoft Access with ASP.net

    Is it possible to use ASP.net with Microsoft Access. From
    what I can find ASP.net only works with SQL server.
    That's kind of step backward from being able to access
    any data source.
    Me Guest

  2. Similar Questions and Discussions

    1. [microsoft][odbc microsoft access driver] syntax error (missing operator) in query expression error
      I have a query I want to run using DBQwiksite siftware, which produces the syntax error (missing operator) in query expression error when...
    2. [Microsoft][ODBC Microsoft Access Driver] Could not start session.
      Does anyone know what this problem means??? Microsoft OLE DB Provider for ODBC Drivers error '80004005' Could not start session. ...
    3. [Microsoft][ODBC Microsoft Access Driver]'(unknown)' is not a valid path error
      This is probably an old problem that most of you know how to fix (I hope!). The scenario is that I have a web server running an ASP site that needs...
    4. ASP Microsoft Access
      I am writing an sites for mulitple languages, even though in the script I tell the encoding type to be for the language in Microsoft Access it...
    5. Microsoft Access
      go to webthang.co.uk, look in thier tutorial. good luck cheers vivian "Jonathan Fagan" <webforumsuser@macromedia.com> wrote in message...
  3. #2

    Default Re: Microsoft Access with ASP.net

    Yes, you can use Access with ASP.net.

    Instead of the Sql objects, you can use the Oledb objects.


    "Me" <me@me.com> wrote in message
    news:00d301c33c13$6e1d3940$a601280a@phx.gbl...
    > Is it possible to use ASP.net with Microsoft Access. From
    > what I can find ASP.net only works with SQL server.
    > That's kind of step backward from being able to access
    > any data source.

    dot365 Guest

  4. #3

    Default Re: Microsoft Access with ASP.net

    I'm new at ASP.net. I was playing with a dat grid but
    could not figure out how to point it to an Access
    database. I probably need to read more.

    Thanks
    >-----Original Message-----
    >Yes, you can use Access with ASP.net.
    >
    >Instead of the Sql objects, you can use the Oledb
    objects.
    >
    >
    >"Me" <me@me.com> wrote in message
    >news:00d301c33c13$6e1d3940$a601280a@phx.gbl...
    >> Is it possible to use ASP.net with Microsoft Access.
    From
    >> what I can find ASP.net only works with SQL server.
    >> That's kind of step backward from being able to access
    >> any data source.
    >
    >
    >.
    >
    Me Guest

  5. #4

    Default Microsoft Access with ASP.net

    I used this simple aspx page to get a used to interaction
    with a Access database.

    Hope it helps,

    <%@ Import Namespace="System.Data" %>
    <%@ Import Namespace="System.Data.OleDb" %>
    <script Language="c#" runat="server">
    void Page_Load()
    {
    //ESTABLISH AND OPEN CONNECTION WITH Selection.mdb
    string strConnection
    = "Provider=Microsoft.Jet.OleDb.4.0;";

    strConnection += @"Data Source=C:DB\Northwind.mdb";
    OleDbConnection objConnection;
    objConnection = new OleDbConnection(strConnection);


    try
    {
    objConnection.Open();
    con_open.Text="Connection opened
    successfully.<br />";
    objConnection.Close();
    con_close.Text="Connection closed.<br />";
    }
    catch (Exception e)
    {
    con_open.Text="Connection failed to open.<br />";
    con_close.Text=e.ToString();
    }
    }
    </script>
    <html>
    <body>
    <h4>Testing the data connection
    <asp:label id="data_src" runat="server"/></h4>
    <asp:label id="con_open" runat="server"/><br />
    <asp:label id="con_close" runat="server"/><br />
    </body>
    </html>

    >-----Original Message-----
    >Is it possible to use ASP.net with Microsoft Access. From
    >what I can find ASP.net only works with SQL server.
    >That's kind of step backward from being able to access
    >any data source.
    >.
    >
    Leif Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139