有人有一些示例代码可以从vb express 2008访问我的SQL数据库吗? [英] Anybody have some example code for accessing a my SQL database from vb express 2008?

问题描述

大家好，
我将开始我的项目的新阶段，我想在我的服务器MySQL上创建并填充populste几个数据库.建立连接后，我几乎知道如何处理数据和查询，但我不知道该如何连接.我已经阅读了所有可以找到的帮助文件，直到我厌倦了阅读有关"Northwind"的帮助文件.这对我没有任何帮助.我需要的是在 http://mysite.com 上建立与MySQL的连接的三行或四行对于只需要将站点的用户名和密码放入配置文件中的用户而言是透明的.然后，我需要能够创建数据库并为用户提供使用其用户名和密码的访问权限.我知道如何创建数据库，但不知道如何设置用户名，密码和权限.

我将不胜感激.

谢谢，
Dick Roose

Hi all,
I am about to start a new phase of my project where I want to create and populate populste several databases on my server MySQL.  I pretty much know how to handle the data and queries once I have a connection, it is connecting that I don't know how to do.  I have read all the help file I can find till I am sick of reading about "Northwind" which doesn't help me a t all.  What I need are the three or four lines that establish a connection to MySQL at http://mysite.com  I need to be able to establish this connection transparent to the user who needs only to put thier user name and password for the site into a configuration file.  Then I need to be able to create a database and give the user access with thier username and password.  I know how to create the database but not how to set the username, password and premission.

I would appreciate any help.

Thanks,
Dick Roose

推荐答案

Dick，

在Interent上，有很多比Microsoft论坛更好的地方来询问mySQL服务器问题.

，特别是因为SQL Server Express是Microsoft提供的免费软件.

但是，您的第一个问题很容易填写

http://www.connectionstrings.com/mysql

其他问题是典型的mySQL，因为Microsoft当前为其数据库服务器使用了集成安全性，这意味着存在

请注意，在配置文件中设置密码对其他人来说是安全风险.

Cor

Dick,

There are many better places on Interent to ask for a mySQL server question than a Microsoft forum.

Especially because SQL server Express is freeware given by Microsoft.

However, your first question is easy to fullfil

http://www.connectionstrings.com/mysql

The other questions are typical mySQL because Microsoft uses for their databaseservers currently integrated security which means that there is no special login screen for the DataBase needed.

Be aware that setting a password in a config file is a security risc for others.

Cor

这篇关于有人有一些示例代码可以从vb express 2008访问我的SQL数据库吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！