Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INSERT Text into SQL Server Varbinary col using SPT
Message
 
 
À
20/03/2018 18:15:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01658804
Message ID:
01658886
Vues:
60
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform