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 tried changing from ODBC to OLEDB and it still didn't work. 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?
Many thanks!