|
|
 | | From: | Cushat | | Subject: | 执行这个出错了 | | Date: | Wed, 1 Dec 2004 19:14:12 +0800 |
|
|
 | Module Module1
Sub Main()
Dim dbconn As New
System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=userdb.mdb")
dbconn.Open()
Dim cmd As New OleDb.OleDbCommand
cmd.CommandText = "Insert into users (id,email,pwd)
values(default,'123','123')"
cmd.Connection = dbconn
cmd.ExecuteNonQuery() <<<<<<<<<<<未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。
dbconn.Close()
End Sub
End Module
dbconn连接正常,执行的时候出错,为什么?
数据库文件写权限足够
|
|
| | From: | ijustok | | Subject: | Re: 执行这个出错了 | | Date: | Thu, 2 Dec 2004 10:27:14 +0800 |
|
|
| cmd.CommandText = "Insert into users ( email,pwd)
values( '123','123')"
id 是自增长字段吧
"Cushat" wrote in message
news:OlRykb51EHA.3504@TK2MSFTNGP12.phx.gbl...
> Module Module1
> Sub Main()
> Dim dbconn As New
> System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=userdb.mdb")
> dbconn.Open()
> Dim cmd As New OleDb.OleDbCommand
> cmd.CommandText = "Insert into users (id,email,pwd)
> values(default,'123','123')"
> cmd.Connection = dbconn
> cmd.ExecuteNonQuery() <<<<<<<<<<<未处理的
“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。
> dbconn.Close()
> End Sub
> End Module
>
> dbconn连接正常,执行的时候出错,为什么?
> 数据库文件写权限足够
>
>
|
|
|
