Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INSERT Text into SQL Server Varbinary col using SPT
Message
 
 
To
20/03/2018 18:15:43
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01658804
Message ID:
01658886
Views:
63
This message has been marked as a message which has helped to the initial question of the thread.
>Nice idea, but:
>
>ODBC Error Message: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Explicit conversion from data type text to varbinary(max) is not allowed.]
>
>According to what I've been able to find online, conversion from text to varbinary(max) is implicit (hence the error above).
>
>https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql#large-value-data-types
>
>I've looked at SQLSETPROP() for any connection properties that might affect this, I didn't see anything that might be applicable.

Hmm, I think it worked for me a while ago:

http://blogs.lessthandot.com/index.php/datamgmt/datadesign/dealing-with-the-the-text/
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