Go 4 Sharepoint

Search:

Welcome: Guest!

MOSS Forum

Home » Forum » MOSS

Ask a question

RSS Feeds

Error connecting to Access database for use in a data view

Asked By: Dexter Mclaughlin Date: Feb 28, 2010 Category: MOSS Views: 504

I am trying to connect to an Access database for use in a data
view. I have MOSS 2007 and SharePoint Designer 2007.

In Designer, in the Data Source Library task pane under Database
Connections, I click "Connect to a database". I then
choose "Configure Database Connection". I check "Use custom
connection string". I select ODBC and enter my string. I've tried
probably 5 different strings.

Here's one I tried:

Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data
Source=\\aaa\bbb\ccc\Mark19b.mdb;Jet OLEDB:Database
Password=xxx;Mode=Read

(I've changed the real path and password for confidentiality.)

My error is "Server Error: An error occurred while retrieving the
list of Database from: \\aaa\bbb\ccc\Mark19b.mdb. The Web server
cannot connect to the specified data source because the query may
contain errors, the data source may be unavailable or ocnfigured
improperly, or your Web site is behind a proxy server or firewall..."

I then tried this string:

Driver={Microsoft Access Driver (*.mdb)};Dbq=\\aaa\bbb\ccc
\Mark19b.mdb;Uid=Admin;Pwd=xxx

This error is "Server Error: An error occurred while retrieving the
list of Databases from: The server for the data source returned a
non- specific error when trying to execute your query...."

I have searched the internet and am not getting any good hits.

Has someone figured out how to connect to Access database for use in
data views?

Tagged:error connecting to access database for use in data view

2 Answers Found

Answer #1 Answered By: Alexander Rocha Answered On: Feb 28, 2010

I'm not sure what the problem is here, but you should probably use OLEDB
rather than ODBC (better performance, etc). If you have any doubts about
your syntax, try the following resource:

http://www.connectionstrings.com/access

I'm not sure, but the fact that you're using a UNC might be causing a
problem; are there any permission restrictions on the directory structure of
this remote machine?

Answer #2 Answered By: Maggie Benson Answered On: Feb 28, 2010

I tried OLEDB and all connection string options for ODBC and OLEDB
from the site you sent.

I tried a drive letter instead of the UNC.

I've checked permissions on the share and everyone has full access
all the way down to the mdb file.

Didn't find what you were looking for? Find more on Error connecting to Access database for use in a data view Or get search suggestion and latest updates.