ADO


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: ADO

  1. #1
    Irfan Guest

    ADO


    What is the connectionstring to access MS ACCESS 97 database through ADO if
    databse is protected with password.



  2. #2
    poloart Guest

    Re: ADO


    Here is an Example:

    strConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
    "Persist Security Info=False;" & _
    "Data Source = " & strDataBase & _
    "User ID = " & strUserId & _
    "Password = " & strPassword

    or you can Open the Database like this:

    strConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
    "Persist Security Info=False;" & _
    "Data Source = " & strDataBase

    cnnConection.open strConnectionString, strUser, strPassword

    i will use the second.

    "Irfan" <s_irfanuddin@usa.net> wrote:
    >
    >What is the connectionstring to access MS ACCESS 97 database through ADO

    if
    >databse is protected with password.
    >
    >



  3. #3
    Andrew Grillage Guest

    Re: ADO

    Don't forget that you must specify the Workgroup Information File also. An
    example is given here
    http://www.able-consulting.com/ADO_C...orMicrosoftJet

    --
    Andrew Grillage
    http://vbdata.iwarp.com


    "poloart" <poloart@hotmail.com> wrote in message
    news:38ef81dc$1@news.devx.com...
    >
    > Here is an Example:
    >
    > strConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
    > "Persist Security Info=False;" & _
    > "Data Source = " & strDataBase & _
    > "User ID = " & strUserId & _
    > "Password = " & strPassword
    >
    > or you can Open the Database like this:
    >
    > strConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
    > "Persist Security Info=False;" & _
    > "Data Source = " & strDataBase
    >
    > cnnConection.open strConnectionString, strUser, strPassword
    >
    > i will use the second.
    >
    > "Irfan" <s_irfanuddin@usa.net> wrote:
    > >
    > >What is the connectionstring to access MS ACCESS 97 database through ADO

    > if
    > >databse is protected with password.
    > >
    > >

    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center