Ric,

My guess is, that something's wrong with DSN configuration. Did you try to access the same directory with code I provided in another message in this thread? Did you try to access another directory with free tables?

>Sergey,
>
>I have ran each line with AERROR(). Here is the return (REM: I do have a valid connection, lnConn = 1):
>
>

>*-- But, here is a problem.  lnTableCount Returns -1
>lnTableCount = SQLTABLES(lnConn, 'TABLE', "_tablelist")
>
>*-- AERROR RETURNS:
>*-- [1] 1526
>*-- [2] "Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]Function sequence error"
>*-- [3] "[Microsoft][ODBC Visual FoxPro Driver]Function sequence error"
>*-- [4] S1010
>*-- [5] 0
>*-- [6] 1
>*-- [7] .NULL.
>
>lnData = SQLEXEC(lnConn, "SELECT * FROM TEST1", "_TESTDBF1")
>*-- AERROR RETURNS:
>*-- [1] 1526
>*-- [2] "Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]Invalid file descriptor."
>*-- [3] "[Microsoft][ODBC Visual FoxPro Driver]Invalid file descriptor."
>*-- [4] S1000
>*-- [5] 111
>*-- [6] 1
>*-- [7] .NULL.
>

>
>So, there is something wrong in there but I am missing it. I know that [6] is the correct handle ID. The reason I am trying this is to learn how to get data without PATH() type commands, or hardcoding any path at all.
>
>Ric