Invalid Descriptor Index - SQL Server 2000 - Article 1592 - go-pugleaf

Article View: borland.public.cppbuilder.database.ado

Article #1592

Back to borland.public.cppbuilder.database.ado Previous Next

Invalid Descriptor Index - SQL Server 2000

#1592

From: Chad Eddy
Date: Wed, 26 May 2004 20:51

20 lines
1604 bytes

I am currently adapting my program to use SQL Server as well as the current
access database.  When I do a query from a table with "stream" values
(Image, Text) I sometimes get an "Invalid Descriptor Index" error.  If I put
all my non memory fields before the memory fields in my select statement I
am ok.  If I put even one non memory field after a memory field it errors
out.

Example

Select FirstName, LastName, Picture From People - will work
Select FirstName, Picture, LastName From People - will not work

Picture is of type image
First and Last name are of type varchar(25)

This is fine for a couple places, but obviously is not going to work for me
everywhere.  Anyone have any ideas why I get this behabior?  I am using
Borland 5 and using ODBC Express.

Chad

Technical Details

Message-ID: <40b50377@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,51f6c2e7e332d478,start
X-Google-Attributes: gid10698b,public
From: "Chad Eddy" <chad_eddy@qwest.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Invalid Descriptor Index - SQL Server 2000
Date: Wed, 26 May 2004 15:51:59 -0500
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 209.180.63.37
Message-ID: <40b50377@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1085604727 209.180.63.37 (26 May 2004 13:52:07 -0700)
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail