如何使用 C# 为 SQL Server 创建 DSN? [英] How to create DSN for SQL Server using C#?

问题描述

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using Microsoft.SqlServer.Management.Common;

using Microsoft.SqlServer.Management.Smo;

using System.Data.SqlClient;

using Microsoft.Win32;

using System.Runtime.InteropServices;


[DllImport("ODBCCP32.dll")]

private static extern bool SQLConfigDataSource(IntPtr parent, int request, string driver, string attributes);



namespace CopyDatabase
{

public partial class Synchronize : Form
{

    public Synchronize()
    {
        InitializeComponent();
    }

    private void Synchronize_Load(object sender, EventArgs e)
    {
        Server srv = new Server();
        String[] s = { "master", "tempdb", "model", "msdb", "Resource", "distribution" };

        foreach (Database database in srv.Databases)
        {
            int flag = 0;
            for (int i = 0; i < s.Length; i++)
            {
                if (String.Compare(database.Name, s[i], true) == 0)
                {
                    flag = 1;
                    break;
                }
            }
            if (flag == 0)
            {
                cmbSource.Items.Add(database.Name);
                cmbDest.Items.Add(database.Name);
            }
        }
    }
    private void button1_Click(object sender, EventArgs e)
    {
       string str = "SERVER=HOME\0DSN=MYDSN\0DESCRIPTION=MYDSNDESC\0DATABASE=DBServer\0TRUSTED_CONNECTION=YES";
        SQLConfigDataSource((IntPtr)0, 4, "SQL Server",str);
    }
}

}

参考:http://social.msdn.microsoft.com/Forums/en-US/vscrystalreports/thread/441811b9-c4e9-4d15-97a3-7b92d2c9f318

谁能帮我删除以下错误??

Can anybody help me remove the following errors??

错误 1 ​​预期的类、委托、枚举、接口或结构 C:\Documents 和设置\Pavan\我的文档\视觉工作室2008\Projects\CopyDatabase\CopyDatabase\Synchronize.cs 17 23 CopyDatabase

Error 1 Expected class, delegate, enum, interface, or struct C:\Documents and Settings\Pavan\My Documents\Visual Studio 2008\Projects\CopyDatabase\CopyDatabase\Synchronize.cs 17 23 CopyDatabase

.

错误 2 名称 'SQLConfigDataSource'当前不存在上下文 C:\Documents 和设置\Pavan\我的文档\视觉工作室2008\Projects\CopyDatabase\CopyDatabase\Synchronize.cs 67 13 CopyDatabase

Error 2 The name 'SQLConfigDataSource' does not exist in the current context C:\Documents and Settings\Pavan\My Documents\Visual Studio 2008\Projects\CopyDatabase\CopyDatabase\Synchronize.cs 67 13 CopyDatabase

推荐答案

如果没有其他上下文代码，我的 WAG 是您没有在 extern 和单击处理程序周围声明一个类.

Without the rest of your code for context, my WAG is that you didn't declare a class around the extern and click handler.

这篇关于如何使用 C# 为 SQL Server 创建 DSN?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！