I am attempting to create a Custom Connection string in Sharepoint Designer to access a Lotus Notes database. I am running the SP Designer on my workstation (vs the server) and I have the Lotus Notes SQL driver installed on my PC (vs the server). I know the Lotus Notes SQL driver works, but can’t get it to work with SharePoint.
Here is how I configured the Database Connection in SharePoint.
Provider Name :
Microsoft .NET Framework Dataprovider for ODBC
Connection string:
DRIVER={Lotus NotesSQL Driver (*.nsf)};Database=TestDB\TestPERLKUP2.NSF;Server=local;
Uid=ABC Admin;Pwd=ABCpassword;
Share Point error:
Server Error: An error occurred while retrieveint eh list of dDatabase from : THe server for the data source returned a non-specific error when trying to execute your qurey…
Has anyone had success doing this? Any tips? I’ve tried googling…but still no remedy.