Data Connection Wizard

[jez123456]

Hi experts

I have an adp project file that I’m attempting to connect to an external sql
server database which is a Linked Server.

I can connect to the host sql server with the data connection wizard but the
linked server is not listed.

Any ideas how I can do this or would I have to connect directly to the
linked server?

Thanks for your help

 

[Mary Chipman [MSFT]]

One way to work around this would be to create views or stored
procedures in the host SQLS that accessed data in the linked server
database.

--Mary

 

[Sylvain Lafontaine]

If you can access the host sql server and the host can access the external
server database, it's quite possible that you can also make a direct
connection to this external server database. Have you tried that?

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)