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

A

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.
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top