Results 1 to 4 of 4

Thread: Can't Open connection

  1. Jul 28th, 2004, 01:48 PM #1
    NANC
    NANC is offline

    Thread Starter
    Addicted Member
    Join Date
    Jan 2004
    Posts
    252

    Can't Open connection

    hi all,
    my prob. seems simple,

    Dim connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data_Source=G:\POSdatabase\INVENTORY.mdb"

    Dim cnINVENTORY As New OleDb.OleDbConnection(connString)
    cnINVENTORY .Open()

    unhandelled error occures while .Open() method is compiled.

    what could be cause ?


    thank you for your time...
    Reply With Quote Reply With Quote
  2. Jul 28th, 2004, 02:18 PM #2
    Andy
    Andy is offline
    Frenzied Member
    Join Date
    Nov 2003
    Posts
    1,489
    i believe you need single quotes around your path.
    Reply With Quote Reply With Quote
  3. Jul 28th, 2004, 02:40 PM #3
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    I don't think the underscore in Data_Source is correct. Try just Data Source=
    Reply With Quote Reply With Quote
  4. Jul 28th, 2004, 02:57 PM #4
    NANC
    NANC is offline

    Thread Starter
    Addicted Member
    Join Date
    Jan 2004
    Posts
    252
    It worked,

    data_source is wrong,

    data source is right..


    got it, thank you thank you very very much,,,,

    DOING GOOD TO OTHERS IS THE BEST THING IN THE WORLD.

    -Nanc
    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