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.

You may want to ask in a WSS support newsgroup
news://msnews.microsoft.com/microsof...indowsservices


--

_____________________________________________
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/FrontPa...3/Default.aspx
_____________________________________________


"Makor" <(E-Mail Removed)> wrote in message news:13E4399A-A270-4288-AC0F-(E-Mail Removed)...
| 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.
|
|

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

"Makor" <(E-Mail Removed)> wrote in message
news:13E4399A-A270-4288-AC0F-(E-Mail Removed)...
> 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.
>
>