用C#连接外部SQL数据库

前端之家收集整理的这篇文章主要介绍了用C#连接外部SQL数据库前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我在外部服务器上有一个sql服务器和数据库设置(为了这个目的,让我们调用域名“hello.com”),我想通过C#程序连接到这个服务器.到目前为止,我有这个(所有服务器/数据库的详细信息与真实的不同):
private static void Setupsql()
{
    string connectionString = "server=hello.com; database=db1; uid=user1; pwd=xxxxx;";
    connection = new sqlConnection();
    connection.ConnectionString = connectionString;
    try
    {
        connection.Open();
        Console.WriteLine("Connected");
    }
    catch (Exception e)
    {
        Console.WriteLine(e.Message.ToString());
    }
}

这给了我一条错误信息:

A network-related or instance-specific error occurred while establishing a connection to sql Server. The server was not found or was not accessible. Verify that the instance name is correct and that sql Server is configured to allow remote connections. (provider: Named Pipes Provider,error: 40 - Could not open a connection to sql Server)

我检查了所有连接字符串,并且允许远程访问,因为我已经在同一台计算机上打开查询数据库sqlWorkbench.

有任何想法吗?

解决方法

你需要MysqL驱动程序:

http://dev.mysql.com/downloads/connector/net/

然后,您可以使用MysqLConnection连接类进行连接.

MysqLConnection connection = new MysqLConnection(connectionString);

http://www.codeproject.com/Articles/43438/Connect-C-to-MySQL

猜你在找的C#相关文章