关于ASP与数据库连接的问题
问题现象:
ASP代码分别通过ODBC连接到ACCESS数据库的wtk和SQL SERVER数据库的wtk中,ACCESS的表是通过ODBC建立的SQL SERVER数据源导入的,即两张表的结构是一样的,现在运行ASP代码时,发现数据库为SQL SERVER时,程序没有问题,但为ACCESS数据库时,提示:[错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)]
ASP代码如下:
CommandText="insert into wtk (xmbh,mkbh,cwlx,cwxx,dengji,pinlv,shiji,faxianren,banben,fxrq) values('"& xmbh &"','"& mkbh &"','"& cwlx &"','" & xianxiang &"','"& dengji &"','"& pinlv &"','"& shiji &"','"& faxianren &"','"& strbanben &"',convert(char(15),getdate(),112))"
objConn.Execute CommandText,RecordsAffected,adCmdText
若把代码改为
CommandText="insert into wtk (xmbh,mkbh,cwlx,cwxx,dengji,pinlv,shiji,faxianren,banben,fxrq) values('"& xmbh &"','"& mkbh &"','"& cwlx &"','" & xianxiang &"','"& dengji &"','"& pinlv &"','"& shiji &"','"& faxianren &"','"& strbanben &"','20021208')"
objConn.Execute CommandText,RecordsAffected,adCmdText
就没有出错信息,请问原因
WTK的表结构如下:
CREATE TABLE [wtk] (
[xmbh] [char] (15) NOT NULL ,
[bshh] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ,
[mkbh] [char] (15) NOT NULL ,
[cwlx] [char] (15) NOT NULL ,
[cwxx] [char] (1000) NOT NULL ,
[dengji] [char] (15) NOT NULL ,
[pinlv] [char] (15) NOT NULL ,
[shiji] [char] (15) NOT NULL ,
[faxianren] [char] (10) NOT NULL CONSTRAINT [DF_wtk_faxianren] DEFAULT ('-'),
[zhuangtai] [char] (3) NOT NULL CONSTRAINT [DF_wtk_zhuangtai] DEFAULT ('New'),
[xiugairen] [char] (10) NOT NULL CONSTRAINT [DF_wtk_xiugairen] DEFAULT ('-'),
[querenren] [char] (10) NOT NULL CONSTRAINT [DF_wtk_querenren] DEFAULT ('-'),
[banben] [tinyint] NOT NULL ,
[zhongcai] [char] (10) NOT NULL CONSTRAINT [DF_wtk_bugairen] DEFAULT ('-'),
[fxrq] [char] (30) NOT NULL ,
[bgyy] [char] (500) NULL ,
[qrdate] [char] (30) NULL ,
[xgdate] [char] (30) NULL ,
[clsstate] [int] NOT NULL CONSTRAINT [DF_wtk_clsstate] DEFAULT (0),
[opendate] [char] (30) NULL ,
[nostate] [int] NOT NULL CONSTRAINT [DF_wtk_nostate] DEFAULT (0),
[zcyy] [char] (500) NULL ,
[zclx] [int] NOT NULL CONSTRAINT [DF_wtk_zclx] DEFAULT (0)
)