Results 1 to 6 of 6

Thread: connectionString to MS-Access

  1. Sep 4th, 2002, 08:59 AM #1
    Cerebrate
    Cerebrate is offline

    Thread Starter
    Lively Member Cerebrate's Avatar
    Join Date
    May 2000
    Posts
    82

    Smile connectionString to MS-Access

    can anyone show me what's should be my connectionString if my data base is access?
    Reply With Quote Reply With Quote
  2. Sep 4th, 2002, 09:02 AM #2
    peet
    peet is offline
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    something like this

    Code:
    sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb"
    -= a peet post =-
    Reply With Quote Reply With Quote
  3. Sep 4th, 2002, 09:17 AM #3
    Cerebrate
    Cerebrate is offline

    Thread Starter
    Lively Member Cerebrate's Avatar
    Join Date
    May 2000
    Posts
    82
    Do i have to register my database on ODBC?
    Reply With Quote Reply With Quote
  4. Sep 4th, 2002, 09:29 AM #4
    Cerebrate
    Cerebrate is offline

    Thread Starter
    Lively Member Cerebrate's Avatar
    Join Date
    May 2000
    Posts
    82

    in addition

    the database requires password.
    so do i just add this:
    sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;password=xxxx"
    ??
    Reply With Quote Reply With Quote
  6. Sep 4th, 2002, 09:41 AM #5
    peet
    peet is offline
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    good link : http://www.able-consulting.com/ADO_Conn.htm
    -= a peet post =-
    Reply With Quote Reply With Quote
  7. Sep 4th, 2002, 09:42 AM #6
    peet
    peet is offline
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629

    Re: in addition

    Originally posted by Cerebrate
    the database requires password.
    so do i just add this:
    sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;password=xxxx"
    ??
    like this:

    Code:
    sConnString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test.mdb;Jet OLEDB:Database Password=secret
    -= a peet post =-
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width