Hi,

I have a program that connects to an ODBC Data Source, and performs some functions. Please, assume the following code fragment below:

 cSQLDataSource = "xyz"
 cSQLUserId     = "xyz"
 cSQLPassword   = "xyz"

 nPecasHandle = SqlConnect (cSQLDataSource, cSQLUserId, cSQLPassword)

 SqlTables (nPecasHandle, "Table", "TmpTables")

 Select TmpTables
 Browse
 
 SqlDisconnect (nPecasHandle)

In all my DSNs till now (Informix, Oracle and VFP) when I call SqlTables () it creates a cursor with field names as defined in the help file:

TABLE_QUALIFIER Table qualifier identifier 
TABLE_OWNER     Table owner identifier 
TABLE_NAME      The table name as it appears in the data dictionary 
TABLE_TYPE      The table type as it appears in the data dictionary 
REMARKS         A description of the table 

But now, when I accessed a SQL Server 2000 database, it returned:

TABLE_CAT   Character 128 
TABLE_SCHEM Character 128
TABLE_NAME  Character 128 
TABLE_TYPE  Character 32  
REMARKS     Character 254 

There is a reason (or explanation) for that? I'm running a VFP 6.0 SP5 app in a win2k professional.

Thanks in advance.

Fernando