Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Driver vs more recent ODBC driver
Message
From
23/11/2018 18:24:59
 
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:
01663761
Views:
41
>>>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.

Dmitry, you can have both, no problem with that. Just make sure the Win32 is installed, and check this installation in the 32-bit ODBC administrator at %windir%\SysWOW64\odbcad32.exe.
----------------------------------
António Tavares Lopes
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform