You probably need the fully qualified dbo name in your sql statement. It might be as simple as select ... from dbo.insured ....



>I have no experience with Advantage, so I don't know.
>
>>Craig--
>>
>>I got the ODBC driver for Advantage installed. The SQLCONNECT in VFP now works. SQLTABLES works. SQLEXEC(4, "EXECUTE PROCEDURE sp_mgGetAllTables()") works.
>>
>>SQLEXEC (4, 'select * from insured','sam') does not work ("insured" is one of my tables)
>>
>>Any thoughts?
>>
>>
>>Tim