与Access 2007的ODBC连接Crystal Report [英] ODBC connection Crystal Report with Access 2007

问题描述

我想连接嵌入在Visual Studio中的Crystal Reports，以连接到Protected Access 2007数据库.我有以下查询:

1.使用DSN的ODBC连接能否顺利运行?

2.是否需要在部署项目的每台计算机上都创建此DSN?

帮助将不胜感激！

I want to connect crystal Reports embedded in Visual Studio to connect to Protected Access 2007 Database. I have the following querries:

1. Will a ODBC connection using DSN run smoothly ?

2. Will this DSN need to be created on every computer the project is deployed?

HELP would be appreciated!

推荐答案

您说您的Access 2007数据库受到保护吗?请详细说明受保护"的含义.

如果ODBC连接设置正确，它应该可以顺利运行.我不''通常会在使用ODBC连接时遇到性能问题.

您将必须在要运行软件的每台计算机上创建一个ODBC DSN连接.这是ODBC的缺点之一.但是，您可以编写在应用程序到客户端计算机的安装过程中创建此ODBC连接的代码.不幸的是，我从来不需要这样做，也无法在此特定过程中提供任何帮助.

我一直在商店和我们某些用户的工作站上使用ODBC.

You say that your Access 2007 db is protected? Please elaborate on what you mean by "protected".

If the ODBC connection is set up properly, it should run smoothly. I don'' usually run into problems in performance with my ODBC connections.

You will have to create an ODBC DSN connection on every computer that your software will run on. That is one of the drawbacks to ODBC. You can write code however that creates this ODBC connection in the install process of your application to the client computer. I, unfortunately, have never needed to do this yet and would not be able to offer any help with this particular process.

I use ODBC here in the shop and on some of our user''s workstations all the time.

这篇关于与Access 2007的ODBC连接Crystal Report的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！