delphi5与SQLServer2000的数据库编程c/s模式？

[明行]

1、连接的方式有多少种？
2、BDE方式、ADO方式连接SQLServer2000的具体方法？或更多方式的与它连接方法？

[windindance]

就用ADO。其他都不要用。

[zsr]

BDE也可以，但微软的东西，用ADO方便一点。

[forgot2000]

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)

[erickleung]

如樓上所說, BDE,和ADO都可以, 但ADO在將來安裝到客戶時會較方便. win95只要安裝MDAC2.5/MDAC2.6就可以了, 而WIN2K或以上更是自設呢.
用ADO, 你只要設好ADOCONNECTION1.CONNECTIONSTRING便是了.

[明行]

能用一个小例子说得具体一些吗？

[明行]

还有就是，做delphi5+SQLServer2000的c/s数据库软件应在windows2000下开发吗？是不是在win98下不可以？

[明行]

小的具体一点的例子没有的吗？

[ljun1979]

帮你UP!

[明行]

算了还是用SQLServer7.0好了，98下可以。

各位有什么意见呀？

[mars_han]

server 2000在2000专业版上也没什么特别，所以以我之见98应该可以。我在win2000专业版+delphi6+server2000实现过.你试试吧。在来讨论你的另一个问题。delphi的数据库访问该有4中方法吧--bde,ado,ibx，还有我记不得了。访问server2000最好用ado。其实ado的控件和bde的没太大区别。都是：
连接库-〉连接表、查询-〉datasource->数据感知组件。若用ado代码我知之甚少。望zengyixun可以有所收获，也希望各位对我的发言予以指导！

[masterjames]

bde
ado
corba
com

[xiaoxiao197821]

2000和98下都可以

[抱朴守拙]

ADO

[明行]

但是98下只能安装SQLServer2000的桌面版呀。

但我又想在win2000下有可能有的API在win98下不一样，会不会出现这种情况呢？是在win2000下做，还是在98下做好呢？

[明行]

不会用到LINUX的，都是微软的。

各位发言呀

[明行]

自己up

各位踊跃发言呀:-(

[line]

ADO虽然用的比较不错,但要记住他是微软的产品,如果上到LINUX的话,那就,,,用BDE吧
不过,我在WIN20Kk