Connection string for maxDB

Posted on 2004-11-19
Last Modified: 2008-02-01
Today, I am using MS Access database files but need to move to maxDB.
Can anyone provide connection string for maxDB 7.5. to replace the current one below ?
Thanks for your help.

        'Get the Database Path, to be used in DB Connection String
        Dim sDBPath As String = Request.MapPath(".") & "\db\bingo.mdb"

        'Define DB Connection String
        Dim sCnnString As String = "Provider=Microsoft.Jet.Oledb.4.0;" & _
                                   "Data Source=" & sDBPath

        'Populate Connection Object
        Dim conn As New OleDbConnection(sCnnString)
Question by:i003814
    1 Comment
    LVL 20

    Accepted Solution

    You need ODCB.NET data provider with this connection string

    Dim strConn As String = "DRIVER={MaxDB};SERVER=localhost;DATABASE=TEST;UID=DBA;PWD=DBA;"

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on could not pull conte…
    In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
    This video discusses moving either the default database or any database to a new volume.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now