Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Driver vs more recent ODBC driver
Message
 
 
To
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:
01663818
Views:
44
>>
>>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.

Never mind, found that we can not use SQLStringConnect to connect to OleDB

https://social.msdn.microsoft.com/Forums/vstudio/en-US/7b1c90ca-4fcf-4985-bd76-9d392e7b3d69/using-ole-db-to-connect-my-vfp-app-to-sql-server-08?forum=visualfoxprogeneral

I guess it would not work for us then anyway :(
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform