1: C++Builder10.2.1好像不支持SQL Server 2000了,因為我用10.2撰寫的程式,用10.2.1編譯過后就不能連接了,SQL Server2005就沒有這個問題。
uj5u.com熱心網友回復:
補充一下:在發現連接不上SQL Server 2000后,安裝了sqlncli (2008版_x64),還是連接不上!
2: XE 壓根就沒有利用sqlncli,因為10.2我就沒有安裝,照樣能連接上SQL Server,那為何幫助上說要我們安裝sqlcli???
uj5u.com熱心網友回復:
SQL Server 2000 在服務器上?服務器也大10幾年了。uj5u.com熱心網友回復:
沒辦法啊,有個老程式最近要升級,但是資料庫客戶不買,我們只好用老的了!!!還有,剛剛觀察了一下,FireDAC連接資料庫是有個默認驅動順序的,見如下:
================================
Connection definition parameters
================================
DriverID=MSSQL
Pooled=False
================================
FireDAC info
================================
Tool = RAD Studio 10.2
FireDAC = 16.0.0 (Build 88974)
Platform = Windows 32 bit
Defines = FireDAC_NOLOCALE_META;FireDAC_MONITOR
================================
Client info
================================
Loading driver MSSQL ...
Loading odbc32.dll driver manager
Creating ODBC environment handle
Searching for ODBC driver ...
Checking for ODBC driver [SQL SERVER NATIVE CLIENT 11.0] ...
Checking for ODBC driver [ODBC DRIVER 11 FOR SQL SERVER] ...
Checking for ODBC driver [SQL SERVER NATIVE CLIENT 10.0] ...
Checking for ODBC driver [SQL NATIVE CLIENT] ...
Checking for ODBC driver [SQL SERVER] ...
Found [SQL Server]
================================
Session info
================================
Failed to connect to DBMS !
[FireDAC][Comp][Clnt]-506. Connection [Unnamed] establishment is canceled
uj5u.com熱心網友回復:
你用10.2能連,就用10.2不就好了,為什么一定要最新版呢?uj5u.com熱心網友回復:
與時俱進啊 Update 1修復了一些BUGuj5u.com熱心網友回復:
你寫的是VCL程式吧?新版本更新的主要是FMX和多平臺方面,VCL已經很成熟了。
uj5u.com熱心網友回復:
新產生的bug了轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/56467.html
標籤:數據庫及相關技術
