文件名称:ADODB数据库类操作实例
介绍说明--下载内容均来自于网络,请自行研究使用
可以连接4种数据库,例程里带了ACCESS和Firebird的数据库文件,MYSQL和MSSQL的就自己建吧,结构和ACCESS的一样就可以了。
另外Firebird 用的是2.12版的,嵌入式的,网络的也可以,修改下连接就行了,试的时候记得搭环境。
MYSQL用的5.1的ODBC驱动,没有的自己下了装下。
MSSql我用的2000,高版本的我没有试。
发现“到尾记录”中的一个错误,就不重新上传了,大家自己修改下吧!注意 MoveLast 这个
.版本 2
.子程序 到尾记录, 逻辑型, 公开
Recordset.方法 (“MoveLast”, )
返回 (Recordset.取错误 () = “”)(Can connect 4 kinds of database, routines with ACCESS and Firebird database files, MYSQL and MSSQL on their own built, the structure and ACCESS the same can be.
In addition, Firebird is using the 2.12 edition, embedded, network can also, modify the connection on the line, try to remember to use the environment.
MYSQL with 5.1 of the ODBC driver, no self installed under.
MSSql I used 2000, the high version of me did not try.
Found that "to the tail record" in an error, it will not upload again, we modify it! Pay attention to this MoveLast
Version 2
Subroutine to end record, logical type, open
Recordset. method ("MoveLast")
Returns (Recordset. takes error () = '))
另外Firebird 用的是2.12版的,嵌入式的,网络的也可以,修改下连接就行了,试的时候记得搭环境。
MYSQL用的5.1的ODBC驱动,没有的自己下了装下。
MSSql我用的2000,高版本的我没有试。
发现“到尾记录”中的一个错误,就不重新上传了,大家自己修改下吧!注意 MoveLast 这个
.版本 2
.子程序 到尾记录, 逻辑型, 公开
Recordset.方法 (“MoveLast”, )
返回 (Recordset.取错误 () = “”)(Can connect 4 kinds of database, routines with ACCESS and Firebird database files, MYSQL and MSSQL on their own built, the structure and ACCESS the same can be.
In addition, Firebird is using the 2.12 edition, embedded, network can also, modify the connection on the line, try to remember to use the environment.
MYSQL with 5.1 of the ODBC driver, no self installed under.
MSSql I used 2000, the high version of me did not try.
Found that "to the tail record" in an error, it will not upload again, we modify it! Pay attention to this MoveLast
Version 2
Subroutine to end record, logical type, open
Recordset. method ("MoveLast")
Returns (Recordset. takes error () = '))
(系统自动生成,下载前可以参看下载内容)
下载文件列表
ADODB测试3.e
test.mdb
TEST.FDB
test.mdb
TEST.FDB