D5 + ADO + MS Sql 2000 = Unspecified Error

David Carle

Delphi Developer

Mon, 14 Jul 2003 13:25:09 GMT

D5 + ADO + MS Sql 2000 = Unspecified Error

We have an application written in Delphi 5.0 (Build 5.62) which successfully connects to MS Sql Server 7
databases using ADO
We are now trying to connect to a Sql 2000 database, but when trying to open the ADOConnection we get an
exception "Unspecified error".
BTW - The PC I am using is NT Workstation 4 (with a local copy of Sql 7), connecting (trying) to an NT 4
Server.
I have installed the Sql 2000 client tools and can access the database using MS Management Console. I can also
access the database using ODBC.

Can anyone suggest what I need to change in Delphi to connect to Sql 2000.
All suggestions appreciated.

David Carl

Delphi Developer

Wed, 16 Jul 2003 11:00:25 GMT

Re:D5 + ADO + MS Sql 2000 = Unspecified Error

Quote

> We are now trying to connect to a Sql 2000 database, but when trying to open the ADOConnection we get an
> exception "Unspecified error".

I've now discovered that this is due to Sql Server 2000 being installed
to use Windows Authentication. If I change it to Mixed Mode, or add the
Integrated Security=SSPI (that's just from memory) then I can connect to
the database

I then get the problem due to MDAC 2.6 (crashes when trying to close an
empty query), but I'm hoping that upgrading Delphi to 5.01 will fix this.

Does anyone know whether I'll need to install the Delphi ADOExpress
update as well?

Other Threads

1. MS sql 2000, vb6.0 and d5

2. Newbie: D5 Pro + MS SQL Server 2000 Personal

3. Timeout in D5 ADO with SQL Server 2000

4. Unspecified error - Access 2000

5. Access 2000 "Unspecified Error"

6. MS-SQL 6.5 & MS-SQL 2000

7. Help: Upgrading from MS SQL 6.5 to MS SQL 2000

8. Delphi 5 - ADO - MS SQL Server 2000

9. ADo, MS SQL 2000 and Parameters

10. ADO, MS SQL 2000, CursorType ctDynamic and temp tables