Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 9 app and TLS
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01676383
Message ID:
01676403
Views:
34
>>>>>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"

Then you don't have SQL Native Client 11.0 installed :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform