Question

C#写的连接SQL Server2008数据库语句，怎么连不上啊

语句如下：
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 System.Data.SqlClient;

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection conn;//声明一个SqlConnection对象
private void Form1_Load(object sender, EventArgs e)
{
try
{
string Constr = "server=f32server2;database=Barcode;uid=server,Pwd=?Server12* SqlConnection conn = new SqlConnection(Constr);
conn.Open();
}
catch
{
MessageBox.Show("数据库连接失败");
}
}
}
}

Answer 1

string Constr = "server=f32server2;database=Barcode;uid=server,Pwd=?Server12* SqlConnection conn = new SqlConnection(Constr);
改成：密码里面有?，可能需要转义符
string Constr =@"server=f32server2;database=Barcode;uid=server;Pwd=?Server12*';
' SqlConnection conn = new SqlConnection(Constr);

Answer 2

string Constr = "data source=f32server2; initial catalog=Barcode; user id=server; password=?Server12*" SqlConnection conn = new SqlConnection(Constr);

Answer 3

uid=server,这里应该用分号，改了再说。

Answer 4

要看具体错误提示信息了，可能是pwd密码不正确，或者服务器名字写错等等，还有可能是数据库本身连接没有设置好