VB 2008连接到外部数据库? [英] vb 2008 connecting to an external database?

问题描述

谁能告诉我如何使用VB 2008表单连接到我大学所在的外部数据库?

还有...

如何使VB 2008检查数据库中是否存在对象，然后显示该对象的所有字段?

在此先感谢

Hi,

Can anyone tell me how I can connect to an external database which is situated in my university using a VB 2008 form?

and...

How can I get VB 2008 to check if an object is in the database and if it is then show all the fields of that object?

Thanks in advance

推荐答案

取决于您使用的数据库. MySQL的? SQL Server 2000? 2005年? 2008年?

您需要检查系统表以获取有关数据库包含哪些对象的信息.使用连接字符串连接到外部数据库，该字符串通常包含服务器名称，实例名称(如果未使用默认实例)，默认数据库，用户名和密码.如果有防火墙或阻止直接访问数据库的内容，则可以创建 Web服务将数据库数据公开给外界. Google会为您提供很多帮助(我在您可能想开始的地方加上一些下划线).

Depends on the database you are using. MySql? SQL Server 2000? 2005? 2008?

You need to check the system tables for information on what objects the database contains. You connect to an external database using a connection string, which typically contains the server name, the instance name (if the default instance is not used), the default database, the username, and the password. If there is a firewall or something blocking direct access to your database, you can create a web service to expose database data to the outside world. Google will help you with a lot of that (I underlined a few phrases you may want to start with).

您能指定哪个数据库吗?

有几个选项.

Can you specify which db?

There are several options.

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