Antonio,

Yes, I do use the CursorAdapter with CursorSchema enabled. Is this good or bad? :)

Thank you for the code that should help me with question 2. And you are correct, I am not looking for what SQL Server. But rather what specific driver is being use by my application, as it connects to the SQL Server.

>Dmitry,
>
>You're using CursorAdapter with CursorSchema enabled, right?
>
>Regarding question #2, you're looking for what driver is being used, right? Not the SQL Server... If that is so, you can use the SQLGetInfo ODBC API function to query some driver info for a connection.
>
>

>DECLARE INTEGER SQLGetInfo IN ODBC32 ;
>	LONG ConnectionHandle, INTEGER InfoType, ;
>	STRING @ InfoValuePtr, ;
>	INTEGER BufferLength, INTEGER @ StringLengthPtr
>
>LOCAL DriverName AS String
>LOCAL StrLength AS Integer
>
>m.DriverName = SPACE(200)
>m.StrLength = 0
>
>SQLGETINFO(SQLGETPROP(m.YourODBCConnection, "ODBChdbc"), 7, @m.DriverName, 199, @m.StrLength)
>
>? LEFT(m.DriverName, m.StrLength)
>

>
>
>
>>Hi,
>>
>>First, I am using CursorAdapter to connect and update SQL Server tables.
>>
>>I looked through some old messages and find the gurus (I don't want to name names) warning of not being able to use SQL Server Native Client 11.0 driver. One message says that this driver, when using the type VARCHAR(MAX) will return empty string. However, just a few days ago I replaced the driver SQL Driver with the SQL Server Native Client 11.0 driver (for an in-house application that I use every day). And I don't see a problem, the SQL Server type VARCHAR(MAX) returns to the VFP 9 application the value in the field. The type DateTime is correctly mapped to the DATE type in VFP 9.
>>So, I have two questions:
>>1. What am I missing in being able to use SQL Server Native Client 11.0 driver without a problem?
>>2. I create connection string based on the driver value in XML configuration file. And I see that I replaced the old ODBC driver with the Native Client Driver. Just in case, I miss something, can the VFP 9 code determine what is in fact the SQL server being used?
>>
>>TIA