Results 1 to 8 of 8

Thread: "Enter MS JET OLE DB Initialization Information" ERROR VB6

  1. #1

    Thread Starter
    Member
    Join Date
    Jun 2012
    Posts
    41

    "Enter MS JET OLE DB Initialization Information" ERROR VB6

    Hi there.

    I developed a program that creates Data Reports using this way : http://www.vbtutor.net/vb6/lesson40.html
    But instead of using "Microsoft Jet 3.51 OLE DB Provider", I used "Microsoft Jet 4.0 OLE DB Provider" because when I used "Microsoft Jet 3.51 OLE DB Provider" it couldn't connect to the database when testing the connection. But when I used "Microsoft Jet 4.0 OLE DB Provider" it worked perfectly.
    It worked fine until recently I tried to run the application and it gives this error :

    Name:  24b9g2d.png
Views: 6152
Size:  17.5 KB

    I enter all the data the way it is shown in the picture above, and when I click OK I get this error :

    Name:  1qlafr.png
Views: 4945
Size:  10.5 KB

    Please help me....

  2. #2
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    Re: "Enter MS JET OLE DB Initialization Information" ERROR VB6

    is your .mdb is password protected ? .and you have forget to select Provider string .it is very essential .because provider string is very importent .and without it cannot be work at any rate.
    Last edited by firoz.raj; Sep 6th, 2012 at 01:42 PM.

  3. #3
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    Re: "Enter MS JET OLE DB Initialization Information" ERROR VB6

    You haven't shown any code so there is not much there to even guess at

  4. #4

    Thread Starter
    Member
    Join Date
    Jun 2012
    Posts
    41

    Re: "Enter MS JET OLE DB Initialization Information" ERROR VB6


    is your .mdb is password protected ? .and you have forget to select Provider string .it is very essential .because because provider string it cannot be work at any rate.
    no. my .mdb is not password-protected. and what should I use as the Provider String (I mean, what should I enter to that textbox?)

  5. #5

    Thread Starter
    Member
    Join Date
    Jun 2012
    Posts
    41

    Re: "Enter MS JET OLE DB Initialization Information" ERROR VB6


    You haven't shown any code so there is not much there to even guess at
    I didn't use any code. I created the Data Reports using Data Environments and made all the settings and preferences from the Data Environment itself. (Refer to the first link given on original post)

  6. #6
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    Re: "Enter MS JET OLE DB Initialization Information" ERROR VB6

    Actually I have never used the data environment, I always write ADO code to do data access.

  7. #7
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    Re: "Enter MS JET OLE DB Initialization Information" ERROR VB6

    I didn't use any code. I created the Data Reports using Data Environments and made all the settings and preferences from the Data Environment itself. (Refer to the first link given on original post)
    if you are dong using wizard .there must be an option to fill connection string there .i am sure .

  8. #8

    Thread Starter
    Member
    Join Date
    Jun 2012
    Posts
    41

    Re: "Enter MS JET OLE DB Initialization Information" ERROR VB6

    never mind guys. my problem is solved. it was a error with the file location.
    big thank u to DataMiser and firoz.

Tags for this 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
  •  



Click Here to Expand Forum to Full Width