2 Attachment(s)
"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 :
Attachment 90983
I enter all the data the way it is shown in the picture above, and when I click OK I get this error :
Attachment 90985
Please help me....
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.
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
Re: "Enter MS JET OLE DB Initialization Information" ERROR VB6
Quote:
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?)
Re: "Enter MS JET OLE DB Initialization Information" ERROR VB6
Quote:
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)
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.
Re: "Enter MS JET OLE DB Initialization Information" ERROR VB6
Quote:
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 .
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.
Re: "Enter MS JET OLE DB Initialization Information" ERROR VB6
I had this problem and I resolved it by following the path on the datasource, you have find the .mdb flat file and place it at the end of that path.
Leave the user name: Admin
Leave password :blank
Leave the provide string: blank
Leave the Open Mode: DB MODE READWRITE
Once you place the .mdb file close everything and relaunch the APP and the software should open normally.
Good luck hope this helps resolve the issue.
DJB
Re: "Enter MS JET OLE DB Initialization Information" ERROR VB6
djb0602, welcome to VBForums, but you're 14 years late in answering the question. Hopefully, they have it figured out by now.