这是一段源码,工程中已经引用了 ADO 2.8 和 ADO Ext 2.8,用下面这段代码可以创建一个数据库文件,但是在创建表的时候,运行到下面的最后一句是发生错误,提示“类型无效”,清高手看看怎么会事。 Dim tbl As New ADOX.Table
Dim cat As New ADOX.Catalog
Dim connStr As String connStr = "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=MYDB.MDB"
cat.Create connStr cat.ActiveConnection = connStr
tbl.Name = "MODEL"
tbl.Columns.Append "MODEL", adVarWChar, 9
tbl.Columns.Append "FREQ", adDouble
tbl.Columns.Append "DCR", adDouble
tbl.Columns.Append "SENS", adDouble
tbl.Columns.Append "DAMP", adDouble
tbl.Columns.Append "DIST", adDouble
tbl.Columns.Append "LEAK", adDouble
tbl.Columns.Append "TEMPERATURE", adDouble
tbl.Columns.Append "SEPA", adVarWChar, 7
tbl.Columns.Append "TDATA", adVarWChar, 21
cat.Tables.Append tbl ' 运行到这一句出错:“类型无效”
Dim cat As New ADOX.Catalog
Dim connStr As String connStr = "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=MYDB.MDB"
cat.Create connStr cat.ActiveConnection = connStr
tbl.Name = "MODEL"
tbl.Columns.Append "MODEL", adVarWChar, 9
tbl.Columns.Append "FREQ", adDouble
tbl.Columns.Append "DCR", adDouble
tbl.Columns.Append "SENS", adDouble
tbl.Columns.Append "DAMP", adDouble
tbl.Columns.Append "DIST", adDouble
tbl.Columns.Append "LEAK", adDouble
tbl.Columns.Append "TEMPERATURE", adDouble
tbl.Columns.Append "SEPA", adVarWChar, 7
tbl.Columns.Append "TDATA", adVarWChar, 21
cat.Tables.Append tbl ' 运行到这一句出错:“类型无效”
解决方案 »
- 以下两种关闭记录集的方式哪种更好一些呀?[这个贴子发了为何看不到呀?]
- 关于VBA写SQL数据库的编码问题
- MDI窗体问题有点难
- (急急急)同一个teechart控件如何Import多个已Export的文件,并同时显示比对.
- VB报表生成Execl文件问题?急,谢谢!!
- 请问,怎样在install shield for vb 添加dao数据库的驱动
- 关于ORACLE中的行加锁问题
- VB6+SQL2000 用VB插入数值型数据到SQL SERVER时报错“类型不匹配”
- 请问怎样在vb中使用DirectShow?
- 我想在一个文件中同时 写入 或 读出 一些变量和记录(record),有什么方法?给我写个例子。谢谢大家!~
- 访问服务器数据库的问题
- 怎么搜索日期类型的数据库记录??
Dim cat As New ADOX.Catalog
Dim connStr As String
'这里修改了
connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\MYDB.MDB"
cat.Create connStr cat.ActiveConnection = connStr
tbl.Name = "MODEL"
tbl.Columns.Append "MODEL", adVarWChar, 9
tbl.Columns.Append "FREQ", adDouble
tbl.Columns.Append "DCR", adDouble
tbl.Columns.Append "SENS", adDouble
tbl.Columns.Append "DAMP", adDouble
tbl.Columns.Append "DIST", adDouble
tbl.Columns.Append "LEAK", adDouble
tbl.Columns.Append "TEMPERATURE", adDouble
tbl.Columns.Append "SEPA", adVarWChar, 7
tbl.Columns.Append "TDATA", adVarWChar, 21
cat.Tables.Append tbl '
另外你建立数据库直接用SQL语句是最省事的了。不妨尝试一下。
Dim connStr As String connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\MYDB.MDB"
cat.ActiveConnection = connStr tbl.Name = "MODEL"
tbl.Columns.Append "MODEL", adVarWChar, 9
tbl.Columns.Append "FREQ", adDouble
tbl.Columns.Append "DCR", adDouble
tbl.Columns.Append "SENS", adDouble
tbl.Columns.Append "DAMP", adDouble
tbl.Columns.Append "DIST", adDouble
tbl.Columns.Append "LEAK", adDouble
tbl.Columns.Append "TEMPERATURE", adDouble
tbl.Columns.Append "SEPA", adVarWChar, 7
tbl.Columns.Append "TDATA", adVarWChar, 21
cat.Tables.Append tbl '