Sharepoint Acess Database connection

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.

Then inorder to add the provider executed :
stsadm.exe -o setproperty -pn data-retrieval-services-oledb-providers -pv
DB2OLEDB;IBMDADB2;MSDAORA;OraOLEDB.Oracle;SQLOLEDB;Microsoft.Jet.OLEDB.4.0


Still getting security error.
"server error: An error occured while retrieving the list of databases from
"Db Name" 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 you web site is behind a proxy server or firewall.

If your web site is behind a proxy server or firewall, verify that your
server administrator has configured the Data Retrieval Services HTTP proxy
server setting for microsoft windows sharepoint services."

Could anyone help on this??

Thanks
Hemaserver error: An error occured while retrieving the list of databases
from "Db Name" 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 you web site is behind a proxy server or firewall.

If your web site is behind a proxy server or firewall, verify that your
server administrator has configured the Data Retrieval Services HTTP proxy
server setting for microsoft windows sharepoint services.


.

Relevant Pages

  • Re: How do I display data from an SQL server in SharePoint?
    ... I wanted to use Windows authentication because the database allows all Domain ... The Configure Database Connection dialog has 4 options. ... SharePoint Portal Server). ... >> create a database connection in the Data Source Catalog, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Changing ODBC datasource for a Pivot Table
    ... Connection is the connection string and will show the table you are using. ... > the name of our server, and since the Pivot tables weren't created ... I can't simply update the DSN with the new server name ... > Select External Data Source, ...
    (microsoft.public.excel.programming)
  • Re: Changing ODBC datasource for a Pivot Table
    ... Connection is the connection string and will show the table you are using. ... > the name of our server, and since the Pivot tables weren't created ... I can't simply update the DSN with the new server name ... > Select External Data Source, ...
    (microsoft.public.excel.misc)
  • Re: MailMerge
    ... need to consider modifying any ODBC DSNs and other ... .udl and .odc) that refer to the server name. ... data source is not there, Word will display an error message. ... mind is that if you try to get existing connection details using ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Sharepoint Acess Database connection
    ... Server) so that might help. ... | setting up a Data Source connection in Frontpage to connect to a Access ... If your web site is behind a proxy server or firewall, ...
    (microsoft.public.sharepoint.windowsservices)
Quantcast