Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Delphi7 TClientDataset SQLServer 2005 Could not find prepared statement with handle -1

162 views
Skip to first unread message

jan_dek...@yahoo.com

unread,
Jan 13, 2009, 1:17:16 PM1/13/09
to
Just upgraded from SQL Server 2000 to 2005. My Delphi 7 app which was
working fine for many years now gives the following Error: 'SQL
Server Error: SQL State: 42000, SQL Error Code: 8179 Could not find
prepared statement with handle -1 when opening a Query. If repeat
this a number of times it will connect.

I suspect the driver: This is what I use:

AMS_SQLConnectionFormLetters.DriverName := 'MSSQL';
AMS_SQLConnectionFormLetters.LibraryName := 'dbexpmss.dll';
AMS_SQLConnectionFormLetters.VendorLib := 'oledb';
AMS_SQLConnectionFormLetters.GetDriverFunc :=
'getSQLDriverMSSQL';

and this is my connectionstring:

DriverName=MSSQL
HostName=NRSHBSQLS01\ClientSubs
DataBase=AMS
User_Name=xxxxxxxxxxxx
Password=xxxxxxxxxxxx
BlobSize=-1
LocaleCode=0000
MSSQL TransIsolation=ReadCommited
OS Authentication=False

Any help is appriciated

Jan

0 new messages