Results 1 to 4 of 4

Thread: connection string to access database failing (ado.net)

  1. Nov 27th, 2003, 08:32 PM #1
    bnathvbdotnet
    bnathvbdotnet is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2003
    Posts
    436

    connection string to access database failing (ado.net)

    I am trying to connect to the MS access database...using the following connection string

    connString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\Northwind.mdb"

    and the error it displays is
    Unknown connection option in connection string....

    I think it should be simple and straight forward..Am I doing any mistake?

    Pls suggest...
    nath
    Reply With Quote Reply With Quote
  2. Nov 27th, 2003, 09:00 PM #2
    lianwk
    lianwk is offline
    Lively Member
    Join Date
    Jul 2003
    Location
    Kuala Lumpur (Malaysia)
    Posts
    92

    Smile

    Hi,

    try look at this site:

    http://www.able-consulting.com/ADO_Conn.htm
    Reply With Quote Reply With Quote
  3. Nov 27th, 2003, 09:38 PM #3
    bnathvbdotnet
    bnathvbdotnet is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2003
    Posts
    436

    thank you so much...but I still get the error 'unknown connection option in connecti

    unknown connection option in connection string provider...

    The connection string is ...

    "Provider=Microsoft.Jet.OLEDB.4.0;Data
    Source=C:\Northwind.mdb;User ID=Admin;Password="

    Private idbConn As SqlConnection = Nothing
    idbConn = New SqlConnection(connString)
    Reply With Quote Reply With Quote
  4. Nov 27th, 2003, 11:25 PM #4
    lianwk
    lianwk is offline
    Lively Member
    Join Date
    Jul 2003
    Location
    Kuala Lumpur (Malaysia)
    Posts
    92

    Smile

    Can you show more code of the connection part.
    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