ADO Data Control - Error in initializing provider 
Author Message
 ADO Data Control - Error in initializing provider

I am working through an exercise given in Database Design and
Programming by John Carter - page 376.

On the form I have entered the tools:-
Microsoft ADO Control 6.0 (OLEDB)
Microsoft DataGrid Control 6.0 (OLEDB)

In trying to connect the ADO data control to the database I am working
through the Connecting String Property of Adodc1.
From the Build window I have selected
Microsoft Jet 3.51 OLE DB Provider
I have then selected the database file in question and clicked 'Test'.

This comes up with the message:-

'Test connection failed because of an error in initializing provider'

Can anyone please tell me what exactly this means and what I should to
correct it?

The database file has been created in Access 2000
I am using Visual Studio Pro 6.0 for the Visual Basic

Thanks in advance for any help

David

--

David Hewitt Pottery ,
7 Fairfield Road, Caerleon, Newport,
South Wales, NP18 3DQ, UK.      Tel:- +44 (0) 1633 420647
FAX:- +44 (0) 870 1617274
Web site http://www.*-*-*.com/



Tue, 25 May 2004 04:37:24 GMT  
 ADO Data Control - Error in initializing provider
Hi David,

For an Access 2000 database you should be using Jet 4.0 instead of 3.51

Richard



<snip>

Quote:
> From the Build window I have selected
> Microsoft Jet 3.51 OLE DB Provider

<snip>


Tue, 25 May 2004 06:04:11 GMT  
 ADO Data Control - Error in initializing provider
Thanks Richard, that works fine.

David


Quote:
>Hi David,

>For an Access 2000 database you should be using Jet 4.0 instead of 3.51

>Richard



><snip>

>> From the Build window I have selected
>> Microsoft Jet 3.51 OLE DB Provider

><snip>

--

David Hewitt Pottery ,
7 Fairfield Road, Caerleon, Newport,
South Wales, NP18 3DQ, UK.      Tel:- +44 (0) 1633 420647
FAX:- +44 (0) 870 1617274
Web site http://www.dhpot.demon.co.uk


Tue, 25 May 2004 23:42:39 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. VB6 ADO, Jet "Error initializing provider"

2. VB6 ADO, Jet "Error initializing provider"

3. VB6 ADO, Jet "Error initializing provider"

4. "...an error in initializing provider..."

5. Obtaining a list of Providers for use with ADO Data Control

6. ADO Data Control fails to refresh with Jet 4.0 provider

7. The source code control provider did not initialize properly

8. ole db provider,data control error

9. ole db provider,data control error

10. ???ADO Datagrid:Cannot initialize data bindings

11. Datagrid/ADO - Cannot initialize data bindings

12. ADO data control 6.0 and ADO data object 2.1 conflict

 

 
Powered by phpBB® Forum Software