Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

VFP with ADS

2 posts in FoxPro Last posting was on 2004-02-18 21:21:03.0Z
Barry Newton Posted on 2004-02-11 10:58:52.0Z
From: "Barry Newton" <barry.newton@plan-international.org>
Newsgroups: Advantage.FoxPro
Subject: VFP with ADS
Date: Wed, 11 Feb 2004 11:58:52 +0100
Lines: 67
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300
NNTP-Posting-Host: 217.110.152.170
Message-ID: <402a0c1f@solutions.advantagedatabase.com>
X-Trace: 11 Feb 2004 04:03:59 -0700, 217.110.152.170
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!217.110.152.170
Xref: solutions.advantagedatabase.com Advantage.FoxPro:170
Article PK: 1109525

FAO Alex (ADS)

hello alex

it's been a while since i've tried this so apologies for the time lapse.
re: my problem detailed below with your reply:
1) i'm using ADS 6.2 and ADS StremlineSQL ODBC v.6.20.00.00.
2) i have ADS Data Architect installed and working on my computer so assume
this is able to connect OK.
3) i can use VFP to connect to both SQL-Server and Oracle OK through their
respective ODBC drivers.
the only problem i have is actually with the ADS data. it's a shame because
this is where we store the majority of our data (the other DBs being simply
there for my own testing).

if you've had any ideas for a fix for this please let me know.
thanks
barry


-------------------------------------
Hi Barry,

I don't have good ideas for getting around the problem, just some suggestion
to diagnose the possible causes of the problem.

1) What version of ADS and ADS ODBC driver are you using?
2) Can you use the ADS ODBC driver to see the data using other utilities -
for example the Advantage Data Architect? If no, the problem is between the
ADS ODBC driver and ADS server and you can get help from our technical
support, advantage@extendsys.com, on this issue if this is the case.
If the Advantage Data Architect can use the ADS ODBC driver then the problem
is related to VFP. Perform Step 3.
3) Can you use other ODBC drivers from within VFP 8? If no, then the problem
is likely not Advantage related and you should post your problems to VFP
related NG to get better help. If you can use other ODBC drivers from within
VFP without problem, then it appears to be a problem between VFP 8 and
Advantage ODBC driver and you can contact our technical support for help.

--
Alex Wong
Advantage R&D

"Barry Newton" <barry.newton@plan-international.org> wrote in message
news:3f6ff873@solutions.advantagedatabase.com...
> Hi
>
> We have a Clipper app that's been running successfully with ADS for a few
> years. We're now trying to write some utilities to use the live data from
> VFP 8. My problem is that some tables have a DESCEND() index which VFP
> doesn't like, it just shows an error on opening the table. Sometimes this
> appears many times while opening just one table (eg. if there are many
> indexes in the CDX that have this function).
>
> I've tried using the ADS ODBC driver but this always crashes VFP with a
> C00005 error.
>
> Anyone have any ideas about how I can get around this problem?
>
> Many thanks in advance,
> Barry
>
>


Alex Wong (ADS) Posted on 2004-02-18 21:21:03.0Z
From: "Alex Wong \(ADS\)" <alexw@extendsys.com>
Newsgroups: Advantage.FoxPro
References: <402a0c1f@solutions.advantagedatabase.com>
Subject: Re: VFP with ADS
Date: Wed, 18 Feb 2004 14:21:03 -0700
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 198.102.102.8
Message-ID: <4033d836@solutions.advantagedatabase.com>
X-Trace: 18 Feb 2004 14:25:10 -0700, 198.102.102.8
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.8
Xref: solutions.advantagedatabase.com Advantage.FoxPro:171
Article PK: 1109526

Barry,

"Barry Newton" <barry.newton@plan-international.org> wrote in message
news:402a0c1f@solutions.advantagedatabase.com...
> FAO Alex (ADS)
>
> hello alex
>
> it's been a while since i've tried this so apologies for the time lapse.
> re: my problem detailed below with your reply:
> 1) i'm using ADS 6.2 and ADS StremlineSQL ODBC v.6.20.00.00.

OK.

> 2) i have ADS Data Architect installed and working on my computer so
assume
> this is able to connect OK.

Sorry for being dense. Can you access the data using the ODBC SQL Utility in
the Data Architect? It is under the "Tools" menu. If yes, then the ODBC
driver is working correctly. Then we will need to figure out what VFP is
doing differently.

Alex