代码如下: mysql1 = "insert into tbGood " & _
"SELECT * " & _
"From [ODBC;Driver=SQL Server;Server=127.0.0.1;Uid=sa;Pwd=;database=CCNA].tbCourseCalendar"
With lws_Ado_RecSet
.ActiveConnection = g_Ado_Connection
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
'.LockType = adLockOptimistic
.Source = mysql1
.Open
End With
返回错误:
实时错误 '-2147467259(80004005)':
字段 'tbgood.good' 不能是零长度的字符串PS: 数据库中该字段可以设置为空值。请问如何解决?谢谢!
"SELECT * " & _
"From [ODBC;Driver=SQL Server;Server=127.0.0.1;Uid=sa;Pwd=;database=CCNA].tbCourseCalendar"
With lws_Ado_RecSet
.ActiveConnection = g_Ado_Connection
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
'.LockType = adLockOptimistic
.Source = mysql1
.Open
End With
返回错误:
实时错误 '-2147467259(80004005)':
字段 'tbgood.good' 不能是零长度的字符串PS: 数据库中该字段可以设置为空值。请问如何解决?谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货