How to configure SQL Server Connection
Posted on 2011-04-26
I am building a SharePoint site. In one page, I want to add a form which allows users to enter a part number into a text box and query my MS Access databases for all the info related.
I noticed that SharePoint Designer 2010 has External Content Type which allows you to connect to exteranl database. But I am running into problems setting it up.
First, I selected SQL Server from the External Data Source Type Selcetion box. Then in the SQL Server Connection box, I see fields for Database Server and Database Name. What am I suppoed to put in the Database Server field if what I have is an MS Access database and this database reside on a shared drive? What if my other MS Access database is on the C drive of my laptop? I am not trying to make things unnecessarily complcated. The situation is just that I need to connection to multiple external database which locate on difference places.
I am pretty new to SharePoint. Maybe a fundamental quetion I shall ask is whether the External Content Type is the right choice I shall use to connect to Access databases not residing on a server, but a drive?