I am attempting to execute a an SQL query through PowerShell against an MS Access database. My query works 99% of the time, but occasionally a localized string will cause an error beacuse it contains a single quote (') somewhere within the localized string. You can look at the following example to get a better idea of what I am talking about:
SELECT TermNo, File, Context
WHERE TermNo = 1
AND File = '\frContentfr_localized_content.xml'
AND Context = '(le second niveau), lequel doit accéder aux ressources d'un serveur de base de données ou d'un partage réseau (le troisième niveau). Le jeton de sécurité principal utilisé entre le navigateur et le s'
In most languages I could add slashes to this string to escape out the single quotes (') in the string. But I don's seem to be able to do that in PowerShell.
Is there a way I can execute this query within PowerShell and receive an accurate response back from the database?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!