DELPHI不用BDE怎样访问ACCESS数据库？

bamboo2000 2004-08-31 04:09:14

ActiveX组件能不能在不注册的情况下使用，怎样调用里面的内容

delphi能不能直接调用msado15.dll中的函数来操作ACCESS数据库

请给出例子！

...全文

167 25 打赏收藏转发到动态举报

写回复

25 条回复

切换为时间正序

请发表友善的回复…

发表回复

bamboo2000 2004-08-31

打赏
举报

回复

谢谢大家!
既然大家都说ADO不会轻易损坏，那我就用它了

siglex 2004-08-31

打赏
举报

回复

对于不同地数据库最好选择好地数据库引擎
oracle：BDE
sybase：BDE
Microsoft的SQL 和ACESS等用ADO或ODBC等等哈

BigAngell 2004-08-31

打赏
举报

回复

使用ADO吧,跟BDE差不多

windy2008 2004-08-31

打赏
举报

回复

下载吧.

P908 2004-08-31

打赏
举报

回复

ADO损坏了就装MDAC,去微软的主页上下载.

ly_liuyang 2004-08-31

打赏
举报

回复

绝对推荐ADO的

chengtwn 2004-08-31

打赏
举报

回复

用ADO，方便，打包也容易。

kaguo 2004-08-31

打赏
举报

回复

ADO 是最广泛的，也没有什么要求

cdsgajxlp 2004-08-31

打赏
举报

回复

ado

SunRoll 2004-08-31

打赏
举报

回复

可以用ADO呀

ExSystem 2004-08-31

打赏
举报

回复

ado和dao差不多吧，仅仅是猜的……

ExSystem 2004-08-31

打赏
举报

回复

□◇[DELPHI]DELPHI 支持的DAO数据格式
td.Fields.Append(td.CreateField ('dbBoolean',dbBoolean,0));
td.Fields.Append(td.CreateField ('dbByte',dbByte,0));
td.Fields.Append(td.CreateField ('dbInteger',dbInteger,0));
td.Fields.Append(td.CreateField ('dbLong',dbLong,0));
td.Fields.Append(td.CreateField ('dbCurrency',dbCurrency,0));
td.Fields.Append(td.CreateField ('dbSingle',dbSingle,0));
td.Fields.Append(td.CreateField ('dbDouble',dbDouble,0));
td.Fields.Append(td.CreateField ('dbDate',dbDate,0));
td.Fields.Append(td.CreateField ('dbBinary',dbBinary,0));
td.Fields.Append(td.CreateField ('dbText',dbText,0));
td.Fields.Append(td.CreateField ('dbLongBinary',dbLongBinary,0));
td.Fields.Append(td.CreateField ('dbMemo',dbMemo,0));
td.Fields['ID'].Set_Attributes(dbAutoIncrField);//自增字段

bamboo2000 2004-08-31

打赏
举报

回复

上面不是ADO，是DAO

ExSystem 2004-08-31

打赏
举报

回复

用ADO控件，出错到ms网站找下载，office97的盘里也有……

bamboo2000 2004-08-31

打赏
举报

回复

听说DAO比较ADO速度更快，delphi怎样用ADO啊？

CodeDuDu 2004-08-31

打赏
举报

回复

用ADO！我在几十个项目中都是用的ADO组件，一点问题都没有（除了用Delphi5时要打补丁）

aiunong 2004-08-31

打赏
举报

回复

用ado 设置连接

wenkai 2004-08-31

打赏
举报

回复

用ADO，方便，打包也容易。没有发现客户使用中ADO出过问题的情况。

angelface 2004-08-31

打赏
举报

回复

ADO啊，　更方便，

GoldShield 2004-08-31

打赏
举报

回复

ADO不能使用的情况,我还没碰到过.

加载更多回复（5）

新建ODBC数据源名(系统DSN):jx
数据库：db\jx.mdb
用户名:tjz929
密码:tjz929

--------------------------------------
1.安装BDE数据库引擎;
2.控件：FastReport.v3.09、AlphaControls_v4.51

Universal Data Access Components (UniDAC) is a powerful library of nonvisual cross-database data access components for Delphi, Delphi for .NET, C++Builder, and Free Pascal. The UniDAC library is designed to help programmers develop faster and cleaner cross-database applications. UniDAC is a complete replacement for standard database connectivity solutions and presents an efficient native alternative to the Borland Database Engine and dbExpress for access to Oracle, SQL Server, MySQL, InterBase, Firebird, SQLite, DB2, Microsoft Access, Advantage Database Server, Adaptive Server Enterprise, and other databases (using ODBC provider). UniDAC is based on the well-known Data Access Components from Devart such as ODAC, SDAC, MyDAC, IBDAC, and PgDAC. We have joined the experience of long-term successful development into one great product which provides unified access to popular databases such as Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, SQLite, DB2, Microsoft Access, Advantage Database Server, Adaptive Server Enterprise, and other databases (using ODBC provider). The UniDAC library is actively developed and supported by Devart Team. If you have questions about UniDAC, email the developers at unidac@devart.com or visit UniDAC online at http://www.devart.com/unidac/. Advantages of UniDAC Technology UniDAC is very convenient in setup and usage. It provides transparent server-independent interface for working with different databases. Selected database provider ensures the best way to perform operations on the server. Universal Data Access UniDAC provides transparent server-independent interfaces for working with different databases, and lets you change the client engine for specific server type just by changing single connection option. It means that you can easily switch between database servers in your cross-database UniDAC-based application. Server-Aware Providers UniDAC chooses the best way specific to the server to perform most operations. Every UniDAC data provider uses server-specific native connectivity. All operations with data are performed by providers automatically considering peculiarities of the selected database server. Optimized Code The goal of UniDAC is to enable developers to write efficient and flexible database applications. The UniDAC library is implemented using advanced data access algorithms and optimization techniques. Classes and components undergo comprehensive performance tests and are designed to help you write high-performance, lightweight data access layers. Compatibility with Other Connectivity Methods The UniDAC interface retains compatibility with standard VCL data access components like BDE. Existing BDE-based applications can be easily migrated to UniDAC and enhanced to take advantage of server-specific features. Development and Support UniDAC is a cross-database connectivity solution that has been actively developed and supported. UniDAC comes with full documentation, demo projects, and fast (usually within one business day) technical support by the UniDAC development team. Find out more about how to get help or submit feedback and suggestions to the UniDAC development team in the Getting Support topic. A description of the UniDAC components is provided in the Component List.

Diamond ADO is a Delphi component library, that provide high-speed performance when working with any OLE DB provider or ODBC data source. Diamond ADO uses ActiveX Data Objects 2.x (ADO) to access data without requiring the BDE. Using Diamond ADO you can connect to any OLE DB provider. Currently OLE DB providers exist for SQL Server, Oracle, Access, ODBC, Active Directory Services and the Index Server. Key features: High speed - fast, native access to data without BDE. Compatibility with standard Delphi data-aware components. Complete BDE replacement. Diamond ADO doesn‘t emulate BDE behavior. It is a true TDataset descendent. Full access to ADO. You can use the original ADO objects through component‘s properties. In version 2.00: - Added Delphi 6 support; - Added MIDAS support; - Fixed problem with TableName property of TdADOTable.

TurboDB is a full-featured multi-user database engine and a set of data access components for accessing TurboDB database tables in your Delphi/Kylix/C++ Builder or .NET application. TurboDB for VCL/CLX TurboDB Engine and TurboDB Components are 100% Delphi code. TurboDB Components are very close in use to the BDE data access components included in Delphi Professional and Delphi Enterprise. Compared to these BDE components TurboDB offers the following advantages: · Available for Windows and for Linux, 100% compatible between platforms · Smaller executables · No special installation and/or configuration needed · Tables can be encrypted · Full-text indexing for very fast keyword search Compared to the database client components for InterBase and MySQL included in Kylix, TurboDB · is much easier to install and configure · offers table creation and altering within the IDE · includes a table component to access database data without SQL statements · is highly compatible to BDE, so you can migrate very quickly · offers much more functionality via methods and properties

目录：第0章认识Delphi 0-1 前言 0-2 Delphi简介 0-3 进入Delphi7 0-4 退出Delphi 第1章常用的窗口工具 1-1 窗体（Form） 1-2 代码编辑器(Code Editor) 1-3 代码浏览器(Code Explorer) 1-4 组件面板(Componet Palette) 1-5 对象检视器(Object Inspector) 1-6 快捷工具栏(Speed Menu) 1-7 项目管理器(Project Manager) 1-8 桌面工具栏(Desktops Tollbar) 1-9 图像编辑器(Image Editor) 1-10 对象浏览器(Object TreeView) 1-11 关联选项卡(Digram Page) 第2章常用的菜单 2-1 File菜单 2-2 Edit菜单 2-3 Search菜单 2-4 View菜单 2-5 Project菜单 2-6 Run菜单 2-7 Tools菜单 2-8 Windows菜单第3章集成开发环境的改变 3-1 Delphi集成开民环境介绍 3-2 操作菜单方面的改进 3-2-1 外面方面的改变 3-2-2 内容方面的改变 3-3 对象检视器方面的改进 3-4 组件面板的改进 3-5 代码编辑器的改进 3-6 设计陈列室的改进 3-7 编译信息的显示 3-8 调试器方面的改进 3-8-1 Watch List改进 3-8-2 Debugger选项的改进 3-8-3 Run Parameters对话框的改进第4章 Delphi Object Pascal的初步印象 4-1 面向对象程序概论 4-1-1 类 4-1-2 对象 4-1-3 继承 4-1-4 封装 4-1-5 信息 4-2 Delphi项目结构及窗体的建立 4-2-1 GUI模式的项目 4-2-2 Console模式的项目 4-3 Object Pascal程序结构 4-3-1 项目程序（Program）的结构 4-3-2 单元程序（Unit）的结构 4-4 如何完成一个简单的窗体程序第5章简单的常用指令介绍 5-1 TLabel类对象 5-1-1 Caption属性 5-2 TButton类对象 5-2-1 Caption属笥 5-2-2 OnClick事件 5-3 TEdit类对象 5-4 TCanvas类对象 5-5 Showmessage函数 5-6 InputBox函数 5-7 MessageDlg函灵敏第6章 Delphi与Object Pascal程序的基本概念 6-1 Object Pascal Program程序结构与Delphi项目结构的关系 6-1-1 标头(Heading) 6-1-2 Uses子句 6-1-3 编译指令(Compiler directive) 6-1-4 源代码区(begin end) 6-2 Unit程序结构与窗体的关系 6-2-1 Unit代码结构 6-2-2 语句(Statement) 6-2-3 Unit间Use的状况 6-3 数据类型与定义变量 6-3-1 数据类型概论 6-3-2 不需要使用type声明的数据类型 6-3-3 必须使用type声明的数据类型 6-3-4 定义变量 6-3-5 变量的作用域 6-3-6 定义常量 6-3-7 变量的类型转换(Typecast) 6-4 Object Pascal的运算符(Operator) 6-4-1 设置运算符(assign Operator) 6-4-2 算数运算符(Arithmetic Operator) 6-4-3 关系运算符(Relational Operator) 6-4-4 布尔运算符 6-4-5 集合运算符 6-4-6 字符串运算符 6-4-7 位逻辑运算符 6-4-8 运算符优先级 6-5 流程控制 6-5-1 语句的基本概念 6-5-2 表达式语句(Expression-Statement) 6-5-3 流程控制语句 6-5-4 可视化程序与嵌套程序 6-6 数组与指针 6-6-1 数组类型 6-6-2 指针类型 6-6-3 浅谈指针与数据结构 6-7 程序与函数(Procedures and Functions) 6-7-1 函数的意义与优点 6-7-2 函数的分类与效用 6-7-3 自定义函数使用方法概述 6-7-4 函数的声明、定义及其实现 6-7-5 参数传递方式 6-7-6 声明修

语言基础/算法/系统设计

16,748

社区成员

33,247

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章