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

On Fri, 12 Jun 2009 03:32:01 -0700, jez123456
<(E-Mail Removed)> wrote:

>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

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)


"jez123456" <(E-Mail Removed)> wrote in message
news:1E91BC5A-F3E9-4119-9F84-(E-Mail Removed)...
> 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
>