Debian, SQL Server 7, and Ruby

(John Long) #1

Hi,

For some time now we have used custom compiled versions of SQL Relay
and the Sybase drivers to talk to Microsoft SQL Server 7 on Windows
from Debian 3.0. We are currently in the process of upgrading to
Debian 3.1 and are reevaluating our current stack. I'd like to move
away from using the custom compiled sources and rely strictly on
packages that are in the default Debian distribution. Is this
possible?

I'm a linux newby when it comes to database support. I've done a small
amount of research on the subject, but would be interested in knowing
about the solutions that other people are using. What have you found
that works for talking to SQL Server from Linux?

···

--
John Long
http://wiseheartdesign.com

(Corey Lawson) #2

There is a freeware/opensource ODBC stack that will connect to MSSQL
on Linux, and probably a couple of commercial ones as well.

Rails' sqladapter.rb has been modified to use that ODBC stack as well
as ADO (if on Win32).

···

On 8/23/05, John W. Long <ng@johnwlong.com> wrote:

Hi,

For some time now we have used custom compiled versions of SQL Relay
and the Sybase drivers to talk to Microsoft SQL Server 7 on Windows
from Debian 3.0. We are currently in the process of upgrading to
Debian 3.1 and are reevaluating our current stack. I'd like to move
away from using the custom compiled sources and rely strictly on
packages that are in the default Debian distribution. Is this
possible?

I'm a linux newby when it comes to database support. I've done a small
amount of research on the subject, but would be interested in knowing
about the solutions that other people are using. What have you found
that works for talking to SQL Server from Linux?

--
John Long
http://wiseheartdesign.com

(John Long) #3

Corey Lawson wrote:

There is a freeware/opensource ODBC stack that will connect to MSSQL
on Linux, and probably a couple of commercial ones as well.

Are you referring to iODBC?

Rails' sqladapter.rb has been modified to use that ODBC stack as well
as ADO (if on Win32).

That's good to know.

···

--
John Long
http://wiseheartdesign.com