>>>
>>>Hi Antonio,
>>>
>>>I've downloaded latest OleDB driver
https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microsoft-ole-db-driver-for-sql-server/ but I don't see it when I try to create the ODBC connection (may be it is not supposed to appear in that dialog).
>>>
>>>In any case, is it possible to connect using that driver? If yes, how should I test it?
>>>
>>>Thanks in advance.
>>
>>Naomi, I don't know exactly how this particular application of yours is built, but by the hints you already gave us I don't think it would be an easy task to move from ODBC to OLEDB, that is, not without a major rewrite of your code.
>>
>>You can experiment the driver by using a CursorAdapter, or by directly instantiating an ADODB.Connection object.
>
>Never mind, found that we can not use SQLStringConnect to connect to OleDB
>
>
https://social.msdn.microsoft.com/Forums/vstudio/en-US/7b1c90ca-4fcf-4985-bd76-9d392e7b3d69/using-ole-db-to-connect-my-vfp-app-to-sql-server-08?forum=visualfoxprogeneral>
>I guess it would not work for us then anyway :(
Why not?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham