[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

Re: How to return list of table names from FoxPro DB

Cindy Winegarden

9/26/2002 9:18:00 PM

Ben Ohtsu <bohtsu@yahoo.com> wrote in message
news:8d5701c2556d$281d24b0$9de62ecf@tkmsftngxs01...
> I'm trying to get a list of table names available from a
> FoxPro database. The DSN I've setup is a FoxPro "Free
> Table directory" databae type.
>
> Is there an equivalent ODBC API like SQLTables()? Any
> other ways?

Ben, do you have a .DBC file in your directory? If so, you should use the
Database option. Otherwise, I just tried setting up a datasource to a free
table directory and issued SQLTABLES() and it returned a list of everything
in the directory.

What version of the ODBC driver are you using?
--

Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org http://cindywinegarden.ads...
http://msdn.microsoft.c... http://foxc...