Data retrieval from an external source

[dietmarhannam]

I have a database stored on the server at the following location :
\\<servername>\Databases\<database name.mdb>

Because it is an Access 2003 database i have to use a custom connection
string. The string i use is:
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\<servername>\Databases\<database
name.mdb>;UserID=Admin;password="
I'm not sure if i should be using a UNC path but have also tried the
same method with a copy of the database on the c: drive but still had
no joy.

The error message i receive is:
"Server Error: an error occured while retrieving the list of databases
from \\<servername>\Databases\<database name.mdb>. The data retrieval
service encountered an error during connection to the data source,
Contact the server administrator for more information."

I've even tried to connect to our SQL Server but encountered a similar
error:
"Server Error: an error occured while retrieving the list of databases
from <SQL Server Name>The data retrieval service encountered an error
during connection to the data source, Contact the server administrator
for more information."

Any ideas of what i am doing wrong? Tried method of using a .udl file
to get the string and also set the SharePoint properties using
stsadm.exe (shouldn't make any difference anyway as i cannot connect to
the source).

Thanks in anticipation of your help,

Dietmar

 

[dietmarhannam]

Right, i've got a connection to an SQL server and can access the
Northwind database so Frontpage is working ok. Therefore, there must be
a problem with the connection string......somehow!

 

[dietmarhannam]

Got access to a db on the physical server, but the database i am
interested in is on another server under a share name.

From the WSS book by Jim Buyens, it says that (for Access Databases) a

UNC filename can be used e.g \\<servername>\<sharename>
I have tried this method and the share is accessible from the web
server but no 'luck' thus far. Can you access a share on another
server? Is there a workaround that anyone has found?

Hope you can help

Dietmar