Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Driver vs more recent ODBC driver
Message
From
27/11/2018 01:56:04
 
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:
01663814
Views:
49
>
>Hi Antonio,
>
>I've downloaded latest OleDB driver https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microsoft-ole-db-driver-for-sql-server/ but I don't see it when I try to create the ODBC connection (may be it is not supposed to appear in that dialog).
>
>In any case, is it possible to connect using that driver? If yes, how should I test it?
>
>Thanks in advance.

Naomi, I don't know exactly how this particular application of yours is built, but by the hints you already gave us I don't think it would be an easy task to move from ODBC to OLEDB, that is, not without a major rewrite of your code.

You can experiment the driver by using a CursorAdapter, or by directly instantiating an ADODB.Connection object.
----------------------------------
António Tavares Lopes
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform