连接SQL SERVER 2000的代码错误

[xiaobao3638]

dim scon as new sqlconnection("data source=localhost;database=northword;uid=sa;pwd=''")
这种定义对吗?
但是出了错误
谁能写一下自己定义SQL连接的代码

[chenyuming2004]

dim scon as new sqlconnection("data source=127.0.0.1;initial catalog=northword;uid=sa")

如果数据库是在本机的话就用127.0.0.1吧，
我个人不喜欢写localhost，万一别人改了hosts文件localhost的定义你程序就错了，
没有密码的话pwd就不用写

[karykwan]

server=(local);UID=sa;PWD=sa;database=rcv2

[点点星灯]

web.config中

<appSettings>
<!--<add key="ConSqlString123" value="data source=XXXX;initial catalog=XXXX;password=XXXXpersist security info=True;user id=sa;packet size=4096" />
-->
<add key="ConSqlString" value="data source=XXXX;initial catalog=XXXX;password=XXXX;persist security info=True;user id=yinquan;packet size=4096" />
<add key="SqlDSN" value="Provider=SQLOLEDB;driver={SQL Server};database=YinB2b;server=192.168.0.213;uid=yinquan;pwd=12345" />
</appSettings>
<system.web>





代码中
Dim con As String = ConfigurationSettings.AppSettings("ConSqlString")
Dim db As New SqlConnection(con)

[athossmth]

String strConn = "data source=localhost;initial catalog=Northwind;integrated security=SSPI;persist security info=False;workstation id=localhost;packet size=4096;";

[hamadou]

密码如果没有，就用空代替。如：dim scon as new sqlconnection("data source=localhost;database=northword;uid=sa;pwd=")

[zzzjaychung]

OLE CONN STR:
"Provider=SQLOLEDB.1;Password="xxxx";Persist Security Info=True;User ID="xxxx";Initial Catalog="xxxx";Data Source="xxxx";Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=XXXX;Use Encryption for Data=False;Tag with column collation when possible=False"

ADO CONN STR:
"Server="XXXX";driver={SQL Server};uid="XXXX";pwd="XXXX";database="XXXX";connect timeout=15"