>>>>>>The proper SQLSTRINGCONNECT() should have the Native Client 11 specified, no?
>>>>>>How do you specify the Native Client in SQLSTRINGCONNECT()? Could you, please, write me an example?
>>>>>
>>>>>
>>>>>
>>>>>SQLSTRINGCONNECT("Driver=SQL Native Client 11.0;Server=YourServer;DataBAse=YourDatabase;.....")
>>>>>
>>>>
>>>>When I use:
>>>>
>>>>oTest.DataSource = SQLSTRINGCONNECT("Driver=SQL Native Client 11.0;Server=MYSQLSERVER;DATABASE=MyTestDB;Trusted_Connection=Yes")
>>>>
>>>>
>>>>The value of .DataSource is -1. Does it mean that I don't have the SQL Native Client 11.0?
>>>
>>>Use AERROR to see what is the problem.
>>
>>"Data source name not found and no default driver specified"
>
>The ODBC driver {SQL Native Client 11.0} doesn't install in your PC.
>May be you have {SQL Native Client 12.0} or another version - check ODBC manager 32 bit.
>
>MartinaJ
When I go to the ODBC Data Source Administrator and click on Drivers tab I see the "SQL Server Native Client 11.0" version 2011.1106518.00. But when I run the test .PRG created by Borislav, I get error.
Is it possible that since I am testing the code created by Borislav, I use SQL Server 2008, it is not compatible with the new Native Client?
"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