Hello, currently OLEDB is not supported. I don't know Ruby, but a search for Ruby ODBC on the internet returns a lot of results. Can you try to use an ODBC solution for Ruby? Please also make sure you have configured SQL Azure's firewall rule to "Allow Microsoft Services access to this server".Lante, shanaolanxing This posting is provided "AS IS" with no warranties, and confers no rights.
Yes. The normal (only) way to access SQL Server from ruby on linux is via ODBC.
I am happy to try this - but how should I set up the ODBC data source? I know this can be done programatically during one of the start up events in the worker role, but is there an easier way to do this - by configuration or something? Has anyone got any advice?