Ric,

You can use AERROR() function to get ODBC errors. In this case you passed wrong second parameter to SQLTABLES(). It can be 'TABLE', 'VIEW', or 'SYSTEM TABLE' only.

>Sergey,
>
>Right, I think I am getting there and thanks again. So, here is what I am thinking:
>
>I have a system DSN, "MY TEST DSN". It is setup as follows:
> Data Source Name: My Test Dsn
> Driver: Microsoft Foxpro VFP Driver (*.dbf)
> Database Type: Free Table Directory
> Path: C:\My Test Data
>
>So, my DSN can only return .DBF stuff... got that, but this is not working:
>
>

lcDsn = ALLTRIM("MY TEST DSN")
>lnConn = SQLConnect( lcDsn )
>lcConnStr = SQLGetProp( lnConn, "ConnectString")
>*-- But, here is a problem.  lnTableCount Returns -1
>lnTableCount = SQLTABLES(lnConn, 'DBF', "_tablelist")
>*-- And here lnData Returns -1
>lnData = SQLEXEC(lnConn, "SELECT * FROM TEST1", "_TESTDBF1")

>
>Am I really clueless here :) ???
>