铜川市教育信息网:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

来源：百度文库 编辑：高考问答 时间：2024/04/29 19:19:33
conn.Execute " insert into Return(Name,IdNumber, ProductName, ProductNumber，Price,Buyplace,Remark,Buytime,Returntime) values('" & TheName &"', '" & TheIdNumber &"', '" & TheProductName &"', '" & TheProductNumber &"', '" & ThePrice &"', '" & TheBuyplace &"', '" & TheRemark &"', '" & TheBuytime &"', '" & TheReturntime &"')"
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]在关键字 'Return' 附近有语法错误。

return是SQL SERVER保留关键字，一般不要用它来做表名，既然用了，在使用的时候要加上[]，另外你的语句中有一个逗号是中文的。
如下语句是正确的：

conn.Execute " insert into [Return](Name,IdNumber, ProductName, ProductNumber,Price,Buyplace,Remark,Buytime,Returntime) values('" & TheName &"', '" & TheIdNumber &"', '" & TheProductName &"', '" & TheProductNumber &"', '" & ThePrice &"', '" & TheBuyplace &"', '" & TheRemark &"', '" & TheBuytime &"', '" & TheReturntime &"')"

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E) Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft OLE DB Provider for SQL Server 求救~~ Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft OLE DB Service Components 错误 '8000ffff' Microsoft OLE DB Service Components 错误 '8000ffff' Microsoft OLE DB Provider for ODBC Drivers (0x80040E2F) Microsoft OLE DB Provider for ODBC Drivers (0x80004005)