>>>>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?
>
>Dmitry,
>
>"Not without a major rewrite of Naomi's code"...
>
>Their application uses ODBC to connect to a data source, and data operations are carried on over SPT statements that are going through SQLExec(). Moving to OLEDB would require significant changes om how data is retrieved and stored, and Naomi's company is looking for a light solution for the problem TLS will pose.
Antonio,
Thank you for the explanation. Am I correct to assume that if their organization were using Cursor Adapter, making change from ODBC to OleDb would be possible (without a major rewrite)?
"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
