Hello,

I'm attempting to create my first SF BO Project and am not seeing how I can select a linked server from within the SQL Server Connection String Builder. When I browse to my local SQL instance, the list of databases only show the native SQL databases. The list of linked server objects is not shown.

Can a linked server database be entered manually within the connection string?

Can someone give me an example?


UPDATE:

After creating a data connection in VS2010 to ANY of the native SQL databases on my server instance, I can create queries against the linked server like so:

SELECT * FROM MyLinkedServerName...TableName

So, now I'm just up against how to make this linked server work from within the SF BOM.


Any suggestions?

Thanks.

Sweet.  Thanks Michel. That makes a lot of sense.

After my post, I had started to think about setting up sprocs in the SQL server which queried the linked server tables, but I think views will be a little easier for me to implement.