>>>>>>>>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?
>
>Hmm,
>
>*oTest.DataSource = SQLSTRINGCONNECT("Driver=SQL Native Client 11.0;Server=MYSQLSERVER;DATABASE=MyTestDB;Trusted_Connection=Yes")
>oTest.DataSource = SQLSTRINGCONNECT("Driver={SQL Server Native Client 11.0};Server=MYSQLSERVER;DATABASE=MyTestDB;Trusted_Connection=Yes")
>
>
>MartinaJ
I tried it (curly brakets) and even tried on SQL Server 2014 Express. Still no connection.
Thank you.
"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