Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Error connecting to Access database for use in a data view

  Asked By: Dexter    Date: Feb 28    Category: MOSS    Views: 1740

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?

Share: 

 

2 Answers Found

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

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

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.




Tagged: