Delphi连接SQL Server6.5

chenlq 2000-02-14 12:54:00
我使用Delphi4.0编写的程序 1 连接本地数据库没有问题。
2连接SQL Server没有问题。
相同的程序加入TSession控件, 1.连接本地数据库没有问题。
2使用NT 4.0 装SQL Server 6.5客户端,客户端使用TCP/IP协议,SQL Explore可以打开数据库。程序不能。客户端使用Named pipes 协议可连接成功。
3使用NT 4.0 装SQL Server 6.5客户端,装VS6带的 SQL ODBC驱动。无论客户端配置何种协议都连接数据库不成功。
4Win98 2版连接数据库不成功。
请各位大侠不吝赐教。
急!急!急!急!


...全文
73 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复
除unidac外我愛用的一套,可存取不同資料庫,取代掉BDE,僅供各位同好試用,喜歡的話請購買支持開發者。 SQLDirect Component Library is a light-weight Borland Database Engine replacement for Borland/CodeGear/Embarcadero Delphi v.5 - 10, 2010, XE-XE10 and C++Builder v.5 - 2010, XE-XE10. It uses the native application programming interfaces to access to the following SQL-servers: IBM DB2 Universal Database Informix Server Interbase/Firebird Server Microsoft SQL Server MySQL Server Oracle Database Server PostgreSQL Server SQLite Database Sybase Adaptive Server Enterprise and Adaptive Server Anywhere Unify (Centura, Gupta) SQLBase Server ODBC datasources OLEDB datasources Using of SQLDirect Component Library gives you the following advantages: connecting to the following SQL servers using 32-bit native application programming interfaces (API): Centura SQLBase Server 6(+), IBM DB2 Universal Database with CAE v5.2, Informix Server 7.2(+), Firebird, Interbase, MySQL 3.23(+), Oracle Server 7.2(+) with SQL*Net 2.2(+), Microsoft SQL Server, PostgreSQL 7.1(+), SQLite, Sybase Adaptive Server Enterprise and Adaptive Server Anywhere (through Open Client, which is supported by Anywhere ver.6 as native interface), ODBC and OLEDB datasources. no distributing, installing and configuring the BDE or ODBC simultaneous access to the supported servers using Delphi 5, 6, 7, 9(2005), 10(2006), 2007, 2009, 2010, XE-XE7 or C++Builder 5, 6, 2006, 2007, 2009, 2010, XE-XE7 (Pro and above) to develop Client/Server applications query with an updatable result set query with macro support table component thread safe BLOB-fields (including LOB and BFILE for Oracle8) stored procedure support (with mutiple result sets for IBM DB2, Microsoft and Sybase SQL Server) bi-directional and unidirectional result sets cached updates record filtering support of data-aware components InfoPower support using images stored by Centura SqlWindows(or Team Developer) in their proprietary format interfaces (public methods and properties) of SQLDirect components are compatible with standard BDE data access components (TSession, TDatabase, TQuery ..).  Thread Safety Note Thread safety is supported by the following software: Oracle SQL*Net 2.3 or above Centura SQLBase Ver. 7 or above IBM DB2 Ver. 5.2 or above Microsoft SQL Server Ver. 6 or above MySQL Sybase ASE and ASA through OpenClient Ver. 11.1 or above  SQLDirect 6.5 was released. Delphi/C++Builder 10.1 Berlin support ftStream-Parameter support support ftWideString support (SQLBase 11.5+) bugfixes

5,386

社区成员

发帖
与我相关
我的任务
社区描述
Delphi 开发及应用
社区管理员
  • VCL组件开发及应用社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

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