VB & Database, VB6 ADO, Jet "Error initializing provider"

VB6 ADO, Jet "Error initializing provider"

Author	Message
Christi #1 / 6	VB6 ADO, Jet "Error initializing provider" Added Microsoft ADO Data Control to form in VB6. I want to use a connection string, and I can either use Build or put in the connection string manually and I still get the error message. When using the pick "Build" method, I choose Microsoft Jet 3.51 OLE DB from the list. Connection string: Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\biblio.mdb or Provider=Microsoft.Jet.OLEDB.3.51;Data Source=C:\biblio.mdb;USER ID=admin;Password= With user name either Admin or left blank, and Blank password checked or unchecked. Then I choose my Access database file (I'm using the test database file, biblio.mdb, which installed locally on my H/D). When I test it ("Test Connection"), I get the error message "Test connection failed because of an error initializing provider. Unspecified error." I had a lot of trouble installing VB6. It was trying to write to the same drive that some of my other MS Apps are on, a locked network drive. I have had some other problems for example, getting the VB6 Data Form Wizard to show up in the Add-Ins menu. The DAO controls seem to work. Do I maybe need to install something? I hate to try and reinstall VB6 completely, as it was such a bear to install i the first place (because, as I mentioned before, I couldn't override some of the paths it wanted to install files into). Thanks Christie
Fri, 20 Jul 2001 03:00:00 GMT

Rob #2 / 6	VB6 ADO, Jet "Error initializing provider" I've had trouble with the MS Jet 3.51 Provider. I would try this line strCnn = "Provider=MSDASQL;DSN=dsnname;DATABASE=dbname.mdb;UID=;PWD=" Quote: >Added Microsoft ADO Data Control to form in VB6. I want to use a connection >string, and I can either use Build or put in the connection string manually >and I still get the error message. >When using the pick "Build" method, I choose Microsoft Jet 3.51 OLE DB from >the list. Connection string: >Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data >Source=C:\biblio.mdb >or >Provider=Microsoft.Jet.OLEDB.3.51;Data Source=C:\biblio.mdb;USER >ID=admin;Password= >With user name either Admin or left blank, and Blank password checked or >unchecked. >Then I choose my Access database file (I'm using the test database file, >biblio.mdb, which installed locally on my H/D). >When I test it ("Test Connection"), I get the error message "Test connection >failed because of an error initializing provider. Unspecified error." >I had a lot of trouble installing VB6. It was trying to write to the same >drive that some of my other MS Apps are on, a locked network drive. I have >had some other problems for example, getting the VB6 Data Form Wizard to >show up in the Add-Ins menu. >The DAO controls seem to work. >Do I maybe need to install something? I hate to try and reinstall VB6 >completely, as it was such a bear to install i the first place (because, as >I mentioned before, I couldn't override some of the paths it wanted to >install files into). >Thanks >Christie
Sun, 22 Jul 2001 03:00:00 GMT

Christi #3 / 6	VB6 ADO, Jet "Error initializing provider" Thanks for your response. Now I'm looking all over for the syntax of the data source name. Without it or with the one that doesn't seem to work, (see below) I get: "Test connection failed because of an error initializing provider. [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" strings tried: Provider=MSDASQL;DSN=MS Access 97;DATABASE=C:\biblio.mdb;USERID=admin;Password= or Provider=MSDASQL;DATABASE=C:\biblio.mdb;USERID=admin;Password= Quote: >strCnn = "Provider=MSDASQL;DSN=dsnname;DATABASE=dbname.mdb;UID=;PWD=" >>Provider=Microsoft.Jet.OLEDB.3.51;
Sun, 22 Jul 2001 03:00:00 GMT

Christi #4 / 6	VB6 ADO, Jet "Error initializing provider" Actually, I moved one step closer with a DSN that worked: Provider=MSDASQL;DSN=MS Access 97 Database;DATABASE=C:\biblio.mdb;USERID=admin;Password= Got the message: "Test connection failed because of an error initializing provider. Operation Canceled." But still that failure to initialize provider message.
Sun, 22 Jul 2001 03:00:00 GMT

M. Frederica Fr #5 / 6	VB6 ADO, Jet "Error initializing provider" says... Quote: > Added Microsoft ADO Data Control to form in VB6. I want to use a connection > string, and I can either use Build or put in the connection string manually > and I still get the error message. > When using the pick "Build" method, I choose Microsoft Jet 3.51 OLE DB from > the list. Connection string: > Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data > Source=C:\biblio.mdb > or > Provider=Microsoft.Jet.OLEDB.3.51;Data Source=C:\biblio.mdb;USER > ID=admin;Password= > With user name either Admin or left blank, and Blank password checked or > unchecked. > Then I choose my Access database file (I'm using the test database file, > biblio.mdb, which installed locally on my H/D). > When I test it ("Test Connection"), I get the error message "Test connection > failed because of an error initializing provider. Unspecified error." > I had a lot of trouble installing VB6. It was trying to write to the same > drive that some of my other MS Apps are on, a locked network drive. I have > had some other problems for example, getting the VB6 Data Form Wizard to > show up in the Add-Ins menu. > The DAO controls seem to work. > Do I maybe need to install something? I hate to try and reinstall VB6 > completely, as it was such a bear to install i the first place (because, as > I mentioned before, I couldn't override some of the paths it wanted to > install files into). > Thanks > Christie Source="C:\biblio.mdb" -- Frix Consultants Inc.
Mon, 23 Jul 2001 03:00:00 GMT

Christi #6 / 6	VB6 ADO, Jet "Error initializing provider" Thanks. I tried this in the several variations of broken connection strings and still can't initialize provider.
Mon, 23 Jul 2001 03:00:00 GMT

Page 1 of 1

[ 6 post ]