We help IT Professionals succeed at work.

Openrowset

rosieg
rosieg asked
on
Hi all,

I've been experimenting with the OPENSROWSET function.  What I'd like is more info on the 'provider_name' argument - in books on line it says a 'character string that represents the friendly name of the OLE DB provider as specified in the registry', but I don't know what the 'friendly names' of the OLE DB providers are.  Is there anywhere I can get a list?

Hope someone can help, Thanks.
Comment
Watch Question

Billing Engineer
GOLD EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
provided by M$:
MSDASQL     ODBC datasources
MSDAORA     Oracle databases
SQLOLEDB    SQL Server databases
Microsoft.Jet.OLEDB.4.0       Access, Excel etc
MSIDXS      Microsoft Index Service
DB2OLEDB    IBM DB2 database
DTSPackageDSO   provider to read DTS Packages
ADSDSOObject    Active Directory Access

provided by Oracle:
Oracle.OraOLEDB   Oracle 8

CHeers

Author

Commented:
Thanks Angellll !

Explore More ContentExplore courses, solutions, and other research materials related to this topic.