>Every time I use this command I get a connectivity error. I can successfully attach to the sql database. I can use sqltables to get a list of tables in the database, but when I want to get the structure of a table using
>nResults = SQLColumns(nHandle, 'arisdata.mdwo_sub','FOXPRO', 'md_sub')
>I get the connectivity error.

After you get the error, can you still issue any other SPT command successfully? What do you get if you use the NATIVE parameter instead of FOXPRO?