Connect to a Database Server, Use custom connection string not wor

[Adrian Moore]

I'm getting the following error message:

Server Error: An error occurred while retrieving the list of Databases from
<Data Source>: The Web Server cannot connect to the specified data source
because the query may contain errors, the data source may be unavailable or
configured improperly, or your Web Site is behind a proxy server or firewall.

It appears this feature only works for SQL-Server connection strings. I've
tried valid connection strings (creating using Data Link, Test Connection
confirms its valid) for an Access Database, MySQL Database and Polyhedra
database, but all return the above error. In the case of the MySQL and
Polyhedra OLE DB providers, what's interesting is that the OLE DB provider
DLL isn't even loaded by Frontpage.

There doesn't appear to be any errors in the Windows event log or IIS log.

Can anyone help?
Thanks
Ad.

 

[Adrian Moore]

Does anyone from Microsoft have an answer to this question?

Thanks
Ad.

 

[Adrian Moore]

Never mind, figure it out...

By default, the trusted OLE DB providers are
DB2OLEDB;IBMDADB2;MSDAORA;OraOLEDB.Oracle;SQLOLEDB;

The provider I was using needs to be added to the list trusted by Sharepoint
using the following command:

stsadm.exe -o setproperty -pn data-retrieval-services-oledb-providers -pv
DB2OLEDB;IBMDADB2;MSDAORA;OraOLEDB.Oracle;SQLOLEDB;PatOleD2.PatOleDb;

Hope this helps someone.

Adrian Moore
Microsoft MVP - Windows Networking