Kbase P27194: Progress Has Not Created an OLE DB Provider for ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/03/2005 |
|
Status: Unverified
GOAL:
Progress Has Not Created an OLE DB Provider for ODBC
GOAL:
Does Progress have an OLE DB Provider
FIX:
Using Visual Basic to access a Progress database requires ADO (ActiveX Data Objects). The ADO in turn, uses a connection string that references a Provider. The default Provider for ADO is Microsoft's OLE DB provider for ODBC (MSDASQL.1).
The Microsoft OLE DB Provider for ODBC (MSDASQL.1) can be included or not in the connection statement. Both of these connection strings are valid:
Visual Basic can not connect via OLE DB/ODBC without ADO because of their C-style API (Application Program Interface). This connectivity method requires a Provider; that is, a component that allows an application to deliver data through OLE DB. ADO is an application-level interface to OLE DB. Microsoft currently supplies ten OLE DB Providers with ADO.
Companies can and are encouraged to supply their own OLE DB Provider(s). Progress uses the default Microsoft OLE DB Provider for ODBC rather than creating their own. The default Provider, MSDASQL.1, allows ADO to access any data source that has an ODBC compliant driver.
-- "Provider=MSDASQL.1; Data Source=TestDSN; User ID=Test;Password=test;"
-- "Data Source=TestDSN; User ID=Test; Password=test;"
The second connection string implies the default OLE DB Provider for ADO (MSDASQL.1).