>>>>>>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
Thank you, Martina.
"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