Data connection on Sharepoint using Frontpage 2003

[marlene.kotze]

Hi, I'm struggling setting up a data connection on a Sharepoint page
using Frontpage 2003.

I've tried to connect to the Database from the UDL file on the client
as suggested by
http://groups.google.com/group/micr...c7d02fc678784b1?sa=X&oi=groupsr&start=2&num=3
and the connection works successfully. When I copy the connection
string to Configure Database Connection wizard in Frontpage, the
following error appears:

Server Error: An error occurred while retrieving the list of Databases
from <Server Name>: The data retrieval service encountered an error
during connection to the data source.

We use windows authentication

Will appreciate your help, tnx

 

[marlene.kotze]

Got it to work, just changed sql authentication mode to SQL Server and
Windows.