Uploading data to MS SQL Server - problem with quote character

[Sam Dela Cruz]

--=_alternative 0005EE1F882570ED_=
Content-Type: text/plain; charset="US-ASCII"

Hi,

I'm a ruby newbie. On one project I have, I need to upload data coming
from Oracle database to an MS SQL Server. But I'm having problems
inserting if data contains a quote (') character. Is there a method
within the dbi ODBC to quote the data?

Thanks,
Sam
--=_alternative 0005EE1F882570ED_=--