FAO Alex (ADS)
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.
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, firstname.lastname@example.org, 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.
Subject: VFP with ADS
Date: Wed, 11 Feb 2004 11:58:52 +0100
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300
X-Trace: 11 Feb 2004 04:03:59 -0700, 188.8.131.52
Xref: solutions.advantagedatabase.com Advantage.FoxPro:170
Article PK: 1109525
FAO Alex (ADS)
Subject: Re: VFP with ADS
Date: Wed, 18 Feb 2004 14:21:03 -0700
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Trace: 18 Feb 2004 14:25:10 -0700, 184.108.40.206
Xref: solutions.advantagedatabase.com Advantage.FoxPro:171
Article PK: 1109526
> 2) i have ADS Data Architect installed and working on my computer so
> 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