使用Access 2000查询SQL 2005 XPrss .mdf [英] Querying SQL 2005 XPrss .mdf with Access 2000
问题描述
Hey Gang！
我刚刚为VS 2005 Web Dev和SQL 2005 Express浏览了一段精彩的Microsoft视频。数据通过VS网站添加到SQL .mdf文件...
如何查询SQL .mdf文件中的数据？
我可以通过VS Web Dev应用程序浏览数据库数据，当我找到文件夹时，数据库名称清晰可见，但是查询是牵强附会。
您如何看待正在发生什么？
祝你周末愉快！
D？k？ll
Hey Gang!
I just ran through a wonderful Microsoft video for VS 2005 Web Dev and SQL 2005 Express. Data added to SQL .mdf file through VS web site...
How does one query the data in the SQL .mdf file?
I can browse the database data through VS Web Dev application, and the database name is clearly visible when I locate the folders, but querying is far-fetched.
What do you think may be happening?
Have a great week-end!
D?k?ll
推荐答案
Hey Gang！
我刚刚为VS 2005 Web Dev和SQL 2005 Express浏览了一个精彩的Microsoft视频。数据通过VS网站添加到SQL .mdf文件...
如何查询SQL .mdf文件中的数据？
我可以通过VS Web Dev应用程序浏览数据库数据，当我找到文件夹时，数据库名称清晰可见，但是查询是牵强附会。
您如何看待正在发生什么？
周末愉快！
D？k？ll
Hey Gang!
I just ran through a wonderful Microsoft video for VS 2005 Web Dev and SQL 2005 Express. Data added to SQL .mdf file through VS web site...
How does one query the data in the SQL .mdf file?
I can browse the database data through VS Web Dev application, and the database name is clearly visible when I locate the folders, but querying is far-fetched.
What do you think may be happening?
Have a great week-end!
D?k?ll
您是否尝试使用odbc链接将表链接到Access数据库？
Have you tried linking the tables to the Access database using an odbc link?
您是否尝试将表链接到使用odbc链接访问数据库？
Have you tried linking the tables to the Access database using an odbc link?
不，我没试过，我试图通过使用''显示表格数据'选项简单地看到数据，并且已添加到窗格。认为这可以工作...... SQL可以看到Access，反之亦然！
看起来ODBC连接已经创建并准备就绪，将尝试使用它。感谢您发布此选项： - ）
No, I have not tried that, I attempted to simply see the data by using ''Show table data'' option and there were added to pane. Thought okay this could work... SQL can see Access, thus vice versa!
Looks like the ODBC connection is already created and ready, will try it. Thanks for posting this option:-)
您是否尝试使用odbc链接将表链接到Access数据库？
Have you tried linking the tables to the Access database using an odbc link?
我想我需要稍微处理ODBC部分。表是看不见的。我开始考虑简单地使用ADO来查看Access，Mary，你认为这可行吗？
D？k？ll
I think I need to work on the ODBC part a little. Tables are invisible. I started thinking simply using ADO to see Access, Mary, do you think that might work?
D?k?ll
这篇关于使用Access 2000查询SQL 2005 XPrss .mdf的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
