Data Connection Wizard

  • Thread starter Thread starter jez123456
  • Start date Start date
J

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
 
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
 
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)
 
Back
Top