dbExpress与SQL Server 2000的连接!

BruceZhang 2003-01-28 03:28:17

在Delphi6/7中如何设置dbExpress与SQL Server 2000的连接？
其中下面各项目代表什么意思，参数要如何填呢？

Key Value

DriverName
HostName
DataBase
User_Name
Password
BlobSize
LocaleCode
MSSQL Translsolation
OS Authentication

我的E-mail

117zy@sohu.com

...全文

22 8 打赏收藏转发到动态举报

写回复

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

Martin2002 2003-03-05

打赏
举报

回复

请问数据库名是不是要写全数据库所在完整路经

wulangboy 2003-02-07

打赏
举报

回复

口令可以为空，但是必须下载一个补丁！
用了几次觉得不爽没有ADO来得上手，可能是我太逊了！

BruceZhang 2003-02-07

打赏
举报

回复

听说dbExpress比较新，可以夸平台，所以想学学！谢谢大家支持！

hamzsy 2003-02-07

打赏
举报

回复

我看到好多朋友用ADO＋SQLSERVER开发还是使用的文件型数据库开发方式，估计这样的程序员不会太少

Commandor 2003-02-07

打赏
举报

回复

个人感觉还是用ado+sql server来得自然一些。

gzllich 2003-02-06

打赏
举报

回复

gz

grail_ 2003-02-06

打赏
举报

回复

up

Billy_Chen28 2003-01-28

打赏
举报

回复

TSQLConnection.Params
HostName SQL Server的IP
DataBase SQL Server数据库名
User_Name SQL Server用户名
Password SQL Server口令//注意口令不能为空
其它的随便填了。

Delphi7 与SQL SERVER 连接必须借助于本驱动程序，否则较难连接。

适用于delphi，C++的DBEXPRESS数据库连接引擎，本身的版本是6.23，在安装开发工具后，直接运行安装程序可方便快捷的安装开发工具里。开发的程序只需要和包含相应的DLL文件即可保持数据连接，勿需再安装庞大的数据库管理软件。

使用Delphi中的dbExpress组件连接MySQL时需要对应的数据库驱动。开发项目时将解压出来的libmysql.dll放到c:\windows\system32下，程序发布时，将delphi自带的dbxmys.dll和本资源提供的libmysql.dll一并放置主程序所在文件夹下即可。详情参阅http://blog.csdn.net/chaijunkun/archive/2011/03/22/6266641.aspx

delphi2009实现使用DbExpress ADO ODBC 连接Oracle SqlServer MySql DB2 Sybase Informix 数据库,支持读取sql脚本文件和手动输入SQL语句,循环发送SQL语句。本程序是自己写的，界面粗糙，见谅。

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.

数据库相关

2,497

社区成员

88,445

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

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

+ 用AI写文章