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
  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Posts
    676
    Thanks
    1
    Thanked 0 Times in 0 Posts

    connecting to just a ccess® db WITHOUT odbc connections???

    one of our 'clients' has said...

    "quote...I generally do not like to use ODBC DSN-based connections, simply because of the issues that arise if the site is moved to a new computer (need to recreate DSN). I have always used DSN-less connection strings for simplicity of maintenance.

    Not sure why we need to use an ODBC connection... I've never used them before, and I've developed a bunch of sites that read/write to MS Access databases...endquote"

    ummm...can this just a be® done with vb???
    The New JustaBuster Version 2.0 OR JustaBusta Lite V2.0
    ...just a special® thanx kinda hugs to jkd n' nex ...:O)))

    CommemorateWTC.com --Please lend your support

  • #2
    Regular Coder
    Join Date
    Jun 2002
    Posts
    344
    Thanks
    0
    Thanked 0 Times in 0 Posts
    QuackHead tries to understand what Justame means...

    hehe, I think I got it, but I may be wrong.

    Set conn = Server.CreateObject("ADODB.Connection")
    conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; data source=c:\path_to_database.mdb"
    conn.Open

    conn.Close

    a couple notes...
    [list=1][*]"conn" is just a variable name, you can change that to whatever you want.[*]the 4.0 in the connection string represents MS Access 2000. For an earlier version (such as 97) I think it's 3.1 or something.[/list=1]
    Now, If I understood the question properly, that should do you.

    If not, I'm messed.

    ~Quack

  • #3
    Regular Coder
    Join Date
    Jun 2002
    Posts
    676
    Thanks
    1
    Thanked 0 Times in 0 Posts
    qua...
    just a tas® for your understanding of the 'question'...hehehe.../me will pass it just a long® to the techies n' see ifin' it makes sense to them...lol...
    The New JustaBuster Version 2.0 OR JustaBusta Lite V2.0
    ...just a special® thanx kinda hugs to jkd n' nex ...:O)))

    CommemorateWTC.com --Please lend your support


  •  

    Posting Permissions

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