Ric,

Did you check what AERROR() function returns in both cases?

>Sergey,
>
>Thanks, that was a type. That second parameter is 'TABLE' but I still get a -1 Return value. So, I must study a bit more on this issue because it is not working. The DSN connection works, as I can get all of the DSN properties. But, I am still not able to retrieve a list of all the tables in the DSN dirctory; nor am I able to run a select statemnt. If you have any more suggestions they would be well taken. But, thank you so much for your time in any event.
>
>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 :) ???
>>>