从SQL Server链接到外部数据源 [英] Linking to external Data source from SQL Server

问题描述

我需要链接到另一个用户计算机上的Foxpro数据库.我无法正确连接.我是否需要将其链接为另一台服务器，还是可以仅链接到数据源?如果我只能链接到数据源，该如何处理?我尝试执行导入向导来创建链接，但它不接受文件的路径名.

谢谢，

Carolyn

I need to link to a Foxpro database that resides on another user''s machine. I''m having trouble getting the connection correct. Do I need to link this as another server or can I just link to the datasource? If I can just link to the datasource how do I go about that? I tried doing an import wizard to do a link and it''s not accepting the pathname of the file.

Thanks,

Carolyn

推荐答案

我认为最简单的方法可能是设置ODBC DSN，然后从那里提取数据.我在使用旧版MySQL数据库时遇到了麻烦，此解决方案有效.

要做到这一点应该很简单，这里是帮助链接 [

I think the easiest route might be to set up an ODBC DSN and then pull the data from there. I was having trouble with a legacy MySQL database and this solution worked.

Should be pretty simple to do this, here''s a link to help[^] get the settings right, depending on your approach.

Cheers.

这篇关于从SQL Server链接到外部数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！