>>>>>>>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 Server Native Client 11.0};Server=MYSQLSERVER;DATABASE=MyTestDB;Trusted_Connection=Yes")
MartinaJ