>>>>>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