|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|
||||||||
|
|||||||||
|
|
|
|
Company
|
|
 SQL LINKS DEVELOPER SUPPORT
SEARCH Borland Online/Developer Support
Unable to post blob (text, image, etc) data > 32k
to a Sybase or MSSQL database table via a live TQuery
result even though the table has a unique (clustered/primary)
index.
Date: 10/3/96 1:15pm
Subject: Image Transfer Problem - Solved!
A little learning experience...
"XYZ" are using Delphi 2.01
(C/S) and MS SQL Server 6.5. They were having problems
transferring large BLOBs into a table...
Easy, just make sure they have a unique single column
index (see READLINK.TXT) and BLOBs larger than 32k will
work without a problem.
Works perfectly using our SQLNT350 server (running MS SQL
Server 6.5). But, it fails for "XYZ"...
We actually have the same version of Delphi, BDE, SQL Links,
SQL Server client software, and MS SQL Server. Same dates,
everything.
Finally after a couple of callbacks, I had him fax me a
SQL Monitor log using a *very* simple table, and a *very*
simple app...
The only difference (apart from geographical location turns
out to be how the customer is logging in. Customer is
logged in as "sa" (sys admin).
Since "sa" doesn't own the table ("dbo" does), the BDE
fails to locate the index, which in turns makes BLOBs
larger than 32k not work...
Changing his select to:
select * from dbo.xyz (instead of select * from xyz)
cleared up the problem.
PUB
MSSQL LINK TECH
AO
|
|
||
|
|
|
|||
|
|||||
|
|
||||
 |
|||||
|
|||||
| Made in Borland® Copyright© 1994-2003 Borland Software Corporation. All rights reserved. Report Piracy, Legal Notices, Privacy Policy Last Modified Monday, 26-Mar-2001 16:27:08 PST |
|||||
