Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combination: BDE + ODBC + SQLserver2000 ?

Status
Not open for further replies.

tbecirevic

Programmer
Feb 12, 2002
2
NL
I am using ODBC driver (v. 03.08.0528) for SQL server 2000
and connection is fine. But when I use BDE components (like TTable) from Borland Bulider C++ problem is that I can not open more than 4 tables in the same time. The error is :"General SQL error". Those TTable components are connected to TDatabase component which uses ODBC data source to connect to SQL serever 2000.
BDE version I'm using is 5.01.
Do you know what can be the problem?

P.S. I've already tried with BDE native driver for SQL server (MSSQL, version 4.0) and than I have different error: "Couldn't perform the edit because another user changed the record." And table stays locked.

Thank you for your time.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top