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 04:39:52
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:
01663735
Views:
30
>>>>It means that this driver is not going to be available when the client switches to this TLS 1.2 environment and so it's not going to be one of the choices when we create DSN to use with our application. As a result, our application (the way it currently connects to SQL Server) is not going to produce correct results when working with varchar(max) columns unless we do something in our code (say, use CAST(ourColumn as varchar(8000)) as ourColumn ) - obviously it's not a very good solution in our situation, but I don't see a better alternative (except for asking our client to get that Devart driver - who is going to pay then)?
>>>
>>>What if you use DSN-less connection?
>>
>>None of the drivers I currently have installed worked correctly for me using Antonio's test program (except for SQL Server driver). So, even if we don't use DSN, it's still a driver's problem.
>
>One possibility would be to create a workaround only for the memo fields: Select * should then be defining all fields individually and then CAST nVarchar(max) to Text.
>
>If there are too many queries, you could write a parser that interprets "MyTable.*" into separate fields. Get the field structure of the table "MyTable" and hunt for varchar(max). If found, replace the * with all fields and cast the varchar(max) to Text.

That's too many changes in too many places.
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