读书人

这个程序为何还会死掉

发布时间: 2011-12-17 23:37:33 作者: rapoo

这个程序为什么还会死掉?
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
Dim SqlConn As New SqlClient.SqlConnection
Dim SqConnectStr = "server=local;user id=sa;pwd=amdlive;database=sql1 "
SqlConn.ConnectionString = SqConnectStr
SqlConn.Open()
Label1.Text = "lianjie OK "
Catch
Label1.Text = "lianjie no "
End Try
End Sub
End Class

按确定以后程序依然死掉.并且连接不上sql

[解决办法]
连接语句错了 还要注意连接的方式 是 OLEDB 还是ADO 方式不同连接语句有点区别
我用的语句你参考下嘛
workstation id=75BS1DWTA2FALXS;packet size=4096;user id=sa;initial catalog=book;persist security info=True;password=sa
[解决办法]
dim con as new sqlconnection
con.connectionstring= "server=计算机名称;database=数据库名称;uid=用户名;pwd=密码; "
分号要有。在要是不行的话就是系统或者计算机有问题了。哈哈
[解决办法]
Imports System.Data
Imports System.Data.SqlClient

button_click

dim con as new sqlconnection
con.connectionstring= "data source=(local);initial catalog=库名;user id=sa;password=ss "
con.open
这样写在看看
我都是这样写的没问题

读书人网 >VB Dotnet

热点推荐