Creating a SharePoint Data Connection to an Access DB in Frontpage

[Makor]

Could someone please assist us in describing the exact steps required for
setting up a Data Source connection in Frontpage to connect to a Access DB on
the same SharePoint server.

We assume the process is as follows:

1. Add DB Connection to catalog
2. Configure Database Connection
3. Use Custom Connection String as follows:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source="c:\JobDatabase.mdb"

We keep getting errors saying that a connection cvould not be established to
the access DB. We have set up security permissions for the IIS user.

Thank you.

 

[Stefan B Rusynko]

You may want to ask in a WSS support newsgroup
news://msnews.microsoft.com/microsoft.public.sharepoint.windowsservices


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Could someone please assist us in describing the exact steps required for
| setting up a Data Source connection in Frontpage to connect to a Access DB on
| the same SharePoint server.
|
| We assume the process is as follows:
|
| 1. Add DB Connection to catalog
| 2. Configure Database Connection
| 3. Use Custom Connection String as follows:
| Provider=Microsoft.Jet.OLEDB.4.0;Data Source="c:\JobDatabase.mdb"
|
| We keep getting errors saying that a connection cvould not be established to
| the access DB. We have set up security permissions for the IIS user.
|
| Thank you.
|
|

 

[Adrian Moore]

Makor,

Had the same problem with another database vendor. The Provider needs to be
added to the list trusted by Sharepoint. Try the following:

stsadm.exe -o setproperty -pn data-retrieval-services-oledb-providers -pv
DB2OLEDB;IBMDADB2;MSDAORA;OraOLEDB.Oracle;SQLOLEDB;Microsoft.Jet.OLEDB.4.0

Hope this helps

Adrian Moore
Microsoft MVP - Windows Networking