Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3

Thread: Access Problem

  1. #1
    Regular Coder Cipher's Avatar
    Join Date
    Dec 2004
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Problem

    I'm using Microsoft Access for first time with ASP.NET, i used the same code i use with SQL Server except i changed any Sql to OleDB,
    and here's the connection i used:
    Dim Conn As New OleDbConnection("Provider=Microsoft.OLEDB.Jet.4.0;Data Source=" & Request.MapPath("DB\forum.mdb"))

    but i got that error:
    'Microsoft.OLEDB.Jet.4.0' provider is not registered on the local machine
    and i'm installing Access ofcourse, so what is that for?!
    i need a creative atmosphere

  • #2
    $object->toCD-R(LP); vinyl-junkie's Avatar
    Join Date
    Jun 2003
    Posts
    3,073
    Thanks
    2
    Thanked 22 Times in 22 Posts
    Your connection syntax is incorrect. Here is what you need:

    Code:
    Dim Conn As New OleDbConnection( _
    "Provider=Microsoft.Jet.OleDb.4.0;" & _
    "Data Source=DB\forum.mdb")
    Music Around The World - Collecting tips, trade
    and want lists, album reviews, & more
    SNAP to it!

  • #3
    Regular Coder Cipher's Avatar
    Join Date
    Dec 2004
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I restarted my computer and it worked pretty fine,
    but i have another problem, when i try to read from the database it works pretty fine, but when i try to add any new values, it gives me this error:
    Operation must use an updateable query.
    i use ExecuteNonQuery to add values.
    i need a creative atmosphere


  •  

    Posting Permissions

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