Watch, Follow, &
Connect with Us

QualityCentral

Public Report
Report From: Delphi-BCB/Bold/Persistence    [ Add a report in this area ]  
Report #:  3094   Status: Closed
Unable to use MSSQL Server via ADO as persistence layer if there is BLOB attribute in the model.
Project:  Delphi Build #:  4.453
Version:    7.0 Submitted By:   Alex Uslontsev
Report Type:  Basic functionality failure Date Reported:  12/11/2002 10:27:13 AM
Severity:    Critical / Show Stopper Last Updated: 3/20/2012 2:24:39 AM
Platform:    All versions Internal Tracking #:   152597
Resolution: Fixed (Resolution Comments) Resolved in Build: : Bold 4.0.0.21
Duplicate of:  3059
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: 1
Description
We are unable to use ADOPersistenceHandle using ADO connection to MSSQL Server 2000 with Bold. Bold raises exception every time we use OCL expression that contains "select()" statement.

Please note that if we use other persistance handle (like Interbase handle) than everything works fine.

We tried to apply patch for BoldADOInterfaces.pas (see patch.txt)

Also look at the newsgroup borland.public.delphi.modeldrivenarchitecture.general threads "Databases + Drivers in Use Survey" and "MS SQL Server ADO and Blobs"
Steps to Reproduce:
I am including a zipped up test case.  The ado connection is connecting to Lab29.  
User name: barney
password: betty
Workarounds
None
Attachment
None
Comments

rafael zz at 12/18/2002 2:38:24 PM -
This bug is holding up two production projects that need to release in a few weeks.  We are currently forced to develop using Interbase, but the projects require release on MSSQL.

Failure to resolve this bug will force our projects to be rewritten without Bold, or to port the project to D6E + earlier Bold (we have D6E, but not earlier Bold)

We are 'banking' on Borland resolving this issue by Jan 15, since we can see that earlier (pre D7A) versions of Bold do not have these problems.

rafael zz at 12/18/2002 3:52:13 PM -
Please refer to Borland Developer Support Case #505147 for all the details on this.

There is no workaround, and AFAIKT, Bold + ADO persistence simply does not work.  DBExpress is also unuseable.

rafael zz at 12/18/2002 3:50:24 PM -
This issue is logged internally at Borland as bug number:  152597

It would be helpful to hear what the prognosis for resolution is.

Thank you!

Rafael

Server Response from: ETNACODE01

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.