2440
社区成员
- 主页
delphi5与SQLServer2000的数据库编程c/s模式？
1、连接的方式有多少种？
2、BDE方式、ADO方式连接SQLServer2000的具体方法？或更多方式的与它连接方法？
2、BDE方式、ADO方式连接SQLServer2000的具体方法？或更多方式的与它连接方法？
...全文
请发表友善的回复…
发表回复
line 2002-03-07
ADO虽然用的比较不错,但要记住他是微软的产品,如果上到LINUX的话,那就,,,用BDE吧
不过,我在WIN20Kk
不过,我在WIN20Kk
明行 2002-03-07
自己up
各位踊跃发言呀:-(
各位踊跃发言呀:-(
明行 2002-03-07
不会用到LINUX的，都是微软的。
各位发言呀
各位发言呀
明行 2002-03-06
但是98下只能安装SQLServer2000的桌面版呀。
但我又想在win2000下有可能有的API在win98下不一样，会不会出现这种情况呢？是在win2000下做，还是在98下做好呢？
但我又想在win2000下有可能有的API在win98下不一样，会不会出现这种情况呢？是在win2000下做，还是在98下做好呢？
抱朴守拙 2002-03-06
ADO
xiaoxiao197821 2002-03-06
2000和98下都可以
masterjames 2002-03-06
bde
ado
corba
com
ado
corba
com
mars_han 2002-03-06
server 2000在2000专业版上也没什么特别，所以以我之见98应该可以。我在win2000专业版+delphi6+server2000实现过.你试试吧。在来讨论你的另一个问题。delphi的数据库访问该有4中方法吧--bde,ado,ibx，还有我记不得了。访问server2000最好用ado。其实ado的控件和bde的没太大区别。都是：
连接库-〉连接表、查询-〉datasource->数据感知组件。若用ado代码我知之甚少。望zengyixun可以有所收获，也希望各位对我的发言予以指导！
连接库-〉连接表、查询-〉datasource->数据感知组件。若用ado代码我知之甚少。望zengyixun可以有所收获，也希望各位对我的发言予以指导！
明行 2002-03-06
算了还是用SQLServer7.0好了，98下可以。
各位有什么意见呀？
各位有什么意见呀？
ljun1979 2002-03-06
帮你UP!
明行 2002-03-06
小的具体一点的例子没有的吗？
明行 2002-03-06
还有就是，做delphi5+SQLServer2000的c/s数据库软件应在windows2000下开发吗？是不是在win98下不可以？
明行 2002-03-05
能用一个小例子说得具体一些吗？
erickleung 2002-03-05
如樓上所說, BDE,和ADO都可以, 但ADO在將來安裝到客戶時會較方便. win95只要安裝MDAC2.5/MDAC2.6就可以了, 而WIN2K或以上更是自設呢.
用ADO, 你只要設好ADOCONNECTION1.CONNECTIONSTRING便是了.
用ADO, 你只要設好ADOCONNECTION1.CONNECTIONSTRING便是了.
forgot2000 2002-03-05
BDE的替代品大全（按数据库类型分)
整理编辑：China ASP
详细连接见 http://www.kylecordes.com
====================================
BDE Alternatives List By Database Server / File Type
This section lists the BDE Alternative products by the kind of database
file type or database server they access. Middleware-based solutions,
such as Adonis, ODBC98, ODBCExpress, and SQL Connectors, can be used to
access a wide variety of servers and file types if an appropriate driver
(ODBC) is available. However, experience shows that unless the vendors
has specifically tested their solution with a given ODBC driver, there
may be incompatibilities. Therefore, middleware-based solutions are
only listed under the database servers and file types with which the
vendor has tested their product.
ADO
ADOExpress (Native)
Adonis Component Suite (Native)
AdoSolutio (Native)
Diamond ADO (Native)
Free ADO DataSet (Native)
GM-Components (Native)
Kamiak ADO (Native)
Borland Paradox
ODBCExpress (Via ODBC/Jet)
Opus DirectAccess (Via Jet)
c-Tree
CT-Connect/32 (Native)
Centura SQLBase
SQLDirect (Native)
Dataflex
Dataflex access (TPFTable) (Native)
DBF
Advantage Database Server (Native)
Apollo (Native)
CodeBase (Native)
Halcyon (Native)
ODBCExpress (Via ODBC/Jet)
ODBF (Native)
Opus DirectAccess (Via Jet)
TbDbase (Native)
TbDBF (Native)
tFox (Native)
Topaz (Native)
IBM DB2
SQLDirect (Native)
Informix Corp. Informix
ODBCExpress (Via ODBC)
Interbase Corp. Interbase
FreeIBComponents (Native)
InterBase Objects (Native DSQL & BLR)
ODBCExpress (Via ODBC)
Microsoft Access (MDB)
Adonis Component Suite (Via ADO/ODBC)
AdoSolutio (Via ADO/ODBC)
DAO Database Collection (Native)
Diamond Access (Native DAO)
GM-Components (Native)
ODBC98 (Via ODBC)
ODBCExpress (Via ODBC/Jet)
Opus DirectAccess (Native)
TbJet (Native)
Titan Access Developer (Native)
Microsoft SQL Server
Adonis Component Suite (Via ADO/ODBC)
AdoSolutio (Via ADO/ODBC)
ODBC98 (Native ODBC = native)
ODBCExpress (Native ODBC = native)
SQLDirect (Native)
SQLQuery (Native)
ODBC
Adonis Component Suite (Via ADO)
AdoSolutio (Via ADO)
Diamond ADO (Via ADO)
Free ADO DataSet (Via ADO)
GM-Components (Via ADO)
Kamiak ADO (Via ADO)
mODBC (Native)
ODBC98 (Native)
ODBCExpress (Native)
Opus DirectAccess (Via Jet)
Oracle Corp Oracle
AdoSolutio (Via ADO/ODBC)
Direct Oracle Access (Native)
ODBCExpress (Via ODBC)
Oracle Data Access (Native)
Oracle Data Access Components (ODAC) (Native)
SQLDirect (Native)
Pervasive Btrieve SQL
KeoBTV (Delphi+Btrieve) (Native)
Pervasive Data Access Components (Native)
Titan Btrieve Developer (Native)
Pervasive Btrieve
KeoBTV (Delphi+Btrieve) (Native)
Pervasive Data Access Components (Native)
TBtr (Native)
Titan Btrieve Developer (Native)
Proprietary
DBISAM Database System for Delphi (Native)
FlashFiler (Native)
MiniTable for Delphi (Native)
QDB Components (Native)
Spider Object Database (Native)
tBinDataSet (Native)
TkbmMemTable (Native)
tMemDataSet (Native)
Solid Technologies Solid Server
ODBCExpress (Native ODBC = native)
Sybase Adaptive Server
ODBC98 (Via ODBC)
ODBCExpress (Via ODBC)
SQLDirect (Native)
Sybase SQL Anywhere
Adonis Component Suite (Via ADO/ODBC)
ODBC98 (Native ODBC = native)
ODBCExpress (Native ODBC = native)
SQLDirect (Native)
Titan SQLAnywhere Developer (Native)
Tcx MySQL
TmySQL project (Native)
Zeos Library for Windows (Native)
整理编辑：China ASP
详细连接见 http://www.kylecordes.com
====================================
BDE Alternatives List By Database Server / File Type
This section lists the BDE Alternative products by the kind of database
file type or database server they access. Middleware-based solutions,
such as Adonis, ODBC98, ODBCExpress, and SQL Connectors, can be used to
access a wide variety of servers and file types if an appropriate driver
(ODBC) is available. However, experience shows that unless the vendors
has specifically tested their solution with a given ODBC driver, there
may be incompatibilities. Therefore, middleware-based solutions are
only listed under the database servers and file types with which the
vendor has tested their product.
ADO
ADOExpress (Native)
Adonis Component Suite (Native)
AdoSolutio (Native)
Diamond ADO (Native)
Free ADO DataSet (Native)
GM-Components (Native)
Kamiak ADO (Native)
Borland Paradox
ODBCExpress (Via ODBC/Jet)
Opus DirectAccess (Via Jet)
c-Tree
CT-Connect/32 (Native)
Centura SQLBase
SQLDirect (Native)
Dataflex
Dataflex access (TPFTable) (Native)
DBF
Advantage Database Server (Native)
Apollo (Native)
CodeBase (Native)
Halcyon (Native)
ODBCExpress (Via ODBC/Jet)
ODBF (Native)
Opus DirectAccess (Via Jet)
TbDbase (Native)
TbDBF (Native)
tFox (Native)
Topaz (Native)
IBM DB2
SQLDirect (Native)
Informix Corp. Informix
ODBCExpress (Via ODBC)
Interbase Corp. Interbase
FreeIBComponents (Native)
InterBase Objects (Native DSQL & BLR)
ODBCExpress (Via ODBC)
Microsoft Access (MDB)
Adonis Component Suite (Via ADO/ODBC)
AdoSolutio (Via ADO/ODBC)
DAO Database Collection (Native)
Diamond Access (Native DAO)
GM-Components (Native)
ODBC98 (Via ODBC)
ODBCExpress (Via ODBC/Jet)
Opus DirectAccess (Native)
TbJet (Native)
Titan Access Developer (Native)
Microsoft SQL Server
Adonis Component Suite (Via ADO/ODBC)
AdoSolutio (Via ADO/ODBC)
ODBC98 (Native ODBC = native)
ODBCExpress (Native ODBC = native)
SQLDirect (Native)
SQLQuery (Native)
ODBC
Adonis Component Suite (Via ADO)
AdoSolutio (Via ADO)
Diamond ADO (Via ADO)
Free ADO DataSet (Via ADO)
GM-Components (Via ADO)
Kamiak ADO (Via ADO)
mODBC (Native)
ODBC98 (Native)
ODBCExpress (Native)
Opus DirectAccess (Via Jet)
Oracle Corp Oracle
AdoSolutio (Via ADO/ODBC)
Direct Oracle Access (Native)
ODBCExpress (Via ODBC)
Oracle Data Access (Native)
Oracle Data Access Components (ODAC) (Native)
SQLDirect (Native)
Pervasive Btrieve SQL
KeoBTV (Delphi+Btrieve) (Native)
Pervasive Data Access Components (Native)
Titan Btrieve Developer (Native)
Pervasive Btrieve
KeoBTV (Delphi+Btrieve) (Native)
Pervasive Data Access Components (Native)
TBtr (Native)
Titan Btrieve Developer (Native)
Proprietary
DBISAM Database System for Delphi (Native)
FlashFiler (Native)
MiniTable for Delphi (Native)
QDB Components (Native)
Spider Object Database (Native)
tBinDataSet (Native)
TkbmMemTable (Native)
tMemDataSet (Native)
Solid Technologies Solid Server
ODBCExpress (Native ODBC = native)
Sybase Adaptive Server
ODBC98 (Via ODBC)
ODBCExpress (Via ODBC)
SQLDirect (Native)
Sybase SQL Anywhere
Adonis Component Suite (Via ADO/ODBC)
ODBC98 (Native ODBC = native)
ODBCExpress (Native ODBC = native)
SQLDirect (Native)
Titan SQLAnywhere Developer (Native)
Tcx MySQL
TmySQL project (Native)
Zeos Library for Windows (Native)
zsr 2002-03-05
BDE也可以，但微软的东西，用ADO方便一点。
windindance 2002-03-05
就用ADO。其他都不要用。