asp获取access表字段名称
DBname="JXC.mdb"
connstr="DBQ="+server.mappath(dbName)+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};uid=admin;pwd=rsa1314"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
'获取字段中文名称
set field_rs=Server.CreateObject("ADODB.recordset")
field_sql="select * from KC"
field_rs.Open field_sql, conn
fieldname1 = field_rs(1).name
field_rs.close
sql="select * from KC where " & fieldname1 & "=1"
Response.write(sql)
set field_rs=Server.CreateObject("ADODB.recordset")
field_rs.Open field_sql, conn
fieldname1 = field_rs(1).name
Response.write(field_rs(1))
field_rs.close
asp在查询access表字段名称为中文出错时
检查asp文件的格式是否为ansi