I am trying to use Microsoft’s SharePoint Designer to create a database connection to our MAS200 database. I seem to be having problems creating the correct connection string.
The SharePoint web site is on a different server other than MAS200. On the SharePoint server I have an ODBC connection defended and it seems to be working, when I do a test of that connection it tells me that it sees all the tables. I have tried a wide verity of connection strings in SharePoint Designer, but have had no luck.
DSN=SOTAMAS90; UID=XXX; PWD=password; Directory=\\srvpra02\MAS200\Version4\MAS90; Company=P96; SERVER=NotTheServer
The error I receive in SharePoint Designer when I try and create the database connection is: Server Error: An error occurred while retrieving the list of databases. The server for the data source returned a non-specific error when trying to execute you query. Check the format and content of your query and try again/
The SharePoint web site is on a different server other than MAS200. On the SharePoint server I have an ODBC connection defended and it seems to be working, when I do a test of that connection it tells me that it sees all the tables. I have tried a wide verity of connection strings in SharePoint Designer, but have had no luck.
DSN=SOTAMAS90; UID=XXX; PWD=password; Directory=\\srvpra02\MAS200\Version4\MAS90; Company=P96; SERVER=NotTheServer
The error I receive in SharePoint Designer when I try and create the database connection is: Server Error: An error occurred while retrieving the list of databases. The server for the data source returned a non-specific error when trying to execute you query. Check the format and content of your query and try again/