Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Driver vs more recent ODBC driver
Message
 
 
To
23/11/2018 18:01:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Miscellaneous
Thread ID:
01663573
Message ID:
01663760
Views:
38
>>Hi Antonio,
>>
>>I installed the trial version of the Devart ODBC driver. And when I go to my ODBC Source Administrator I see the driver, named "Devart ODBC Driver for SQL Server", exactly how you have in your test code (above). Yet when I run the above PRG I get "Devart ODBC Driver for SQL Server Not Available"
>>Can you think of what I may have done incorrectly?
>>
>>Thank you.
>
>Dmitry, make sure you installed the driver for Win32. That's the one that VFP will see and use, regardless if you have a 64-bit machine.

Antonio, I think I chose to install both, Win32 and Win64. I may have to uninstall it and install again, choosing only Win32.
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform