作者rico1212112 (没有不景气,只有不争气)
看板Visual_Basic
标题[.NET] Visual Studio 2008执行时出现问题
时间Sun Nov 14 22:59:47 2010
我的电脑是装Visual Studio 2008,执行一段程式都出现问题
Imports System.Data.SqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim strDbCon As String
strDbCon = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=|DataDirectory|\iPods.mdb"
txtOutput.Text = CreateConnection(strDbCon)
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
Dim strDbCon As String
strDbCon = "Provider=SQLOLEDB;" & _
"Data Source=(local)\SQLEXPRESS;" & _
"Initial Catalog=我的学校;" & _
"Integrated Security=SSPI"
txtOutput.Text = CreateConnection(strDbCon)
End Sub
End Class
这是一个很简单的程式,执行Button1都OK很正常,但执行Button2就会出现问题,已经试
过N次,希望高手能帮忙指点!!
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 220.129.126.96
1F:→ nobody1:连线打开要关起来? 11/15 14:30
2F:推 horngsh:你是连ACCESS or SQL SERVER? 11/15 16:31
3F:→ rico1212112:要连ACCESS & SQL SERVER 11/15 21:42
4F:→ rico1212112:Button1连ACCESS,Button2连SQL SERVER,1正常2异常 11/15 21:43
5F:→ rico1212112:电脑有装SQL Server 2005 Express版,没有移除 11/15 21:44
6F:→ rico1212112:後来加装Visual Studio 2008,会不会因为这样而冲突?? 11/15 21:46
7F:推 horngsh:你用错连线字串内容了,SQLOLEDB是给7.0及以前版本用的. 11/16 11:09
8F:→ rico1212112:Visual Studio 2008连线字串SQLOLEDB不是吗?? 11/16 22:29
9F:→ rico1212112:但是同样的连线字串内容,在学校连线是正常没问题的 11/16 22:30
11F:→ horngsh:还有你的我的学校.MDF有装上你自己本机的SQL SERVER 2005? 11/17 09:28
12F:→ rico1212112:那把SQL Server 2005 Express版移除会正常吗?? 11/18 19:25