'INDEXKEY_PROPERTY' is not a recognized function name

Article View: borland.public.delphi.database.dotnet

Article #44

Back to borland.public.delphi.database.dotnet Previous Next

#44

From: MaxSilva
Date: Mon, 19 Nov 2007 13:54

23 lines
2038 bytes

Hi,

I have using Delphi .net and configuring a SqlDataSource.I choose "MS
Sql Server" data source
and ".NET Framework Data Provider for OLE DB" data provider, next I
configure database
connection. After, when I go to next, to configure "..retrieve data
from database" (dialog box
where choose a table and columns ), I get this error:

 "Schema could not be retrieved for this table. Please make sure the
connection settings are correct and that the database is online.

'INDEXKEY_PROPERTY' is not a recognized function name."  , so the
dialog box doesn´t
list columns from any tables.

We have MS Sql Server 7 database and RAD Studio 2007 Enterprise. Using
Windows XP Professional.

Please, could anybody help-me?

Maxwell

Technical Details

Message-ID: <abac95d1-b41c-4c85-b109-a202fc801f32@a28g2000hsc.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!a28g2000hsc.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1effe6,8abc1fe76ff90bb,start
X-Google-Attributes: gid1effe6,public,usenet
X-Google-Language: ENGLISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!a28g2000hsc.googlegroups.com!not-for-mail
From: MaxSilva <maxsilva@gmail.com>
Newsgroups: borland.public.delphi.database.dotnet
Subject: 'INDEXKEY_PROPERTY' is not a recognized function name
Date: Mon, 19 Nov 2007 05:54:21 -0800 (PST)
Organization: http://groups.google.com
Lines: 23
Message-ID: <abac95d1-b41c-4c85-b109-a202fc801f32@a28g2000hsc.googlegroups.com>
NNTP-Posting-Host: 200.162.178.210
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1195480462 11412 127.0.0.1 (19 Nov 2007 13:54:22 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 19 Nov 2007 13:54:22 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: a28g2000hsc.googlegroups.com; posting-host=200.162.178.210; 
 posting-account=8tglVQoAAAAb7CZOrMOId9NrBrkaU18u
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pt-BR; rv:1.8.1.9) 
 Gecko/20071025 Firefox/2.0.0.9,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 kali.telecash.net.br:3128 (squid/2.6.STABLE5)
Content-Disposition: inline