Hi, Is anyone working on a pure ruby version of the MS SQL Server Adapter? The current adapter connects via ADO which means it only works on Win32 :-( Neville _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
The following is posted at http://wiki.rubyonrails.com/rails/show/SQL%20Server%20(without%20Win32OLE%20dependancy)> SQL Server (without Win32OLE dependancy) > > I have gotten SQL Server working with Rails on Linux using > Free TDS? with unixODBC and the DBD::odbc driver. There > are minimal changes required to the Active Record sqlserver > adapter. I plan to get them cleaned up and posted back to the > Rails developers in the next week or two. > > I am very interested in a pure Ruby SQL Server driver. If anyone > is interested in collaborating on that, I''d be interested. > > June 15, 2005 15:33 by Mark ImbriacoI am interested in a FreeTDS sql server adapter as well. If anyone knows who Mark Imbriaco is please let me know so I can get in contact with him to help with this project. This would be a huge addition in my opinion and would allow some larger interests that have already built a dependance on SQL Server to jump aboard the Rails without also having to change databases, and be able to benefit from lighttpd/fastcgi. Anyone interested please let me know. On 5/9/05, Neville Burnell <Neville.Burnell-uEDVyssJ3mUpAS55Wn97og@public.gmane.org> wrote:> > > Hi, > > Is anyone working on a pure ruby version of the MS SQL Server Adapter? > > The current adapter connects via ADO which means it only works on Win32 :-( > > Neville > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > >
Not sure this is exactly what you''re after, but I''ve put together a FreeTDS-based MSSQL driver (DBD::MSSQL) that interfaces with Ruby/DBI. Needs a little more work still before I submit it to the Ruby/DBI folks, but it''s more or less functional. Let me know if you''re interested. Caveats... - It uses db-lib, so expect the db-lib restrictions (max 255 varchar fields, etc). - It''s based on FreeTDS, which works for me, but I don''t think I''d recommend using this in a production environment. David Joe Noon wrote:> The following is posted at > http://wiki.rubyonrails.com/rails/show/SQL%20Server%20(without%20Win32OLE%20dependancy) > > >>SQL Server (without Win32OLE dependancy) >> >>I have gotten SQL Server working with Rails on Linux using >>Free TDS? with unixODBC and the DBD::odbc driver. There >>are minimal changes required to the Active Record sqlserver >>adapter. I plan to get them cleaned up and posted back to the >>Rails developers in the next week or two. >> >>I am very interested in a pure Ruby SQL Server driver. If anyone >>is interested in collaborating on that, I''d be interested. >> >>June 15, 2005 15:33 by Mark Imbriaco > > > I am interested in a FreeTDS sql server adapter as well. If anyone > knows who Mark Imbriaco is please let me know so I can get in contact > with him to help with this project. This would be a huge addition in > my opinion and would allow some larger interests that have already > built a dependance on SQL Server to jump aboard the Rails without also > having to change databases, and be able to benefit from > lighttpd/fastcgi. Anyone interested please let me know. > > On 5/9/05, Neville Burnell <Neville.Burnell-uEDVyssJ3mUpAS55Wn97og@public.gmane.org> wrote: > >> >> >>Hi, >> >>Is anyone working on a pure ruby version of the MS SQL Server Adapter? >> >>The current adapter connects via ADO which means it only works on Win32 :-( >> >>Neville >>_______________________________________________ >>Rails mailing list >>Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org >>http://lists.rubyonrails.org/mailman/listinfo/rails >> >> >> > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails > >
The DBI package also has a driver for SQL Server, but it''s for Win32 only (it talks to SQLOLEDB thru ADO). There''s a HOWTO for installing it on the Rails Wiki. It works for me, but one caveat for it currently is that in your controllers, you will need to explicitly add an :order_by => "field(s)_to_order ASC_or_DESC" (the case on ASC and DESC matters). It works for me. On 6/20/05, David Kinkead <david.kinkead-jxQbuoToBN+Nls3PewDF2w@public.gmane.org> wrote:> Not sure this is exactly what you''re after, but I''ve put together a > FreeTDS-based MSSQL driver (DBD::MSSQL) that interfaces with Ruby/DBI. > Needs a little more work still before I submit it to the Ruby/DBI folks, > but it''s more or less functional. Let me know if you''re interested. > > Caveats... > > - It uses db-lib, so expect the db-lib restrictions (max 255 varchar > fields, etc). > > - It''s based on FreeTDS, which works for me, but I don''t think I''d > recommend using this in a production environment. > > David > > > Joe Noon wrote: > > The following is posted at > > http://wiki.rubyonrails.com/rails/show/SQL%20Server%20(without%20Win32OLE%20dependancy) > > > > > >>SQL Server (without Win32OLE dependancy) > >> > >>I have gotten SQL Server working with Rails on Linux using > >>Free TDS? with unixODBC and the DBD::odbc driver. There > >>are minimal changes required to the Active Record sqlserver > >>adapter. I plan to get them cleaned up and posted back to the > >>Rails developers in the next week or two. > >> > >>I am very interested in a pure Ruby SQL Server driver. If anyone > >>is interested in collaborating on that, I''d be interested. > >> > >>June 15, 2005 15:33 by Mark Imbriaco > > > > > > I am interested in a FreeTDS sql server adapter as well. If anyone > > knows who Mark Imbriaco is please let me know so I can get in contact > > with him to help with this project. This would be a huge addition in > > my opinion and would allow some larger interests that have already > > built a dependance on SQL Server to jump aboard the Rails without also > > having to change databases, and be able to benefit from > > lighttpd/fastcgi. Anyone interested please let me know. > > > > On 5/9/05, Neville Burnell <Neville.Burnell-uEDVyssJ3mUpAS55Wn97og@public.gmane.org> wrote: > > > >> > >> > >>Hi, > >> > >>Is anyone working on a pure ruby version of the MS SQL Server Adapter? > >> > >>The current adapter connects via ADO which means it only works on Win32 :-( > >> > >>Neville > >>_______________________________________________ > >>Rails mailing list > >>Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > >>http://lists.rubyonrails.org/mailman/listinfo/rails > >> > >> > >> > > > > _______________________________________________ > > Rails mailing list > > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
I seem to recall some date formatting / handling issues with the DBI driver. Can you confirm, or deny that? What''s been your experience? -Larry On 6/20/05, Corey Lawson <corey.ssf.lawson-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > The DBI package also has a driver for SQL Server, but it''s for Win32 > only (it talks to SQLOLEDB thru ADO). There''s a HOWTO for installing > it on the Rails Wiki. It works for me, but one caveat for it currently > is that in your controllers, you will need to explicitly add an > :order_by => "field(s)_to_order ASC_or_DESC" (the case on ASC and DESC > matters). > > It works for me. > > On 6/20/05, David Kinkead <david.kinkead-jxQbuoToBN+Nls3PewDF2w@public.gmane.org> wrote: > > Not sure this is exactly what you''re after, but I''ve put together a > > FreeTDS-based MSSQL driver (DBD::MSSQL) that interfaces with Ruby/DBI. > > Needs a little more work still before I submit it to the Ruby/DBI folks, > > but it''s more or less functional. Let me know if you''re interested. > > > > Caveats... > > > > - It uses db-lib, so expect the db-lib restrictions (max 255 varchar > > fields, etc). > > > > - It''s based on FreeTDS, which works for me, but I don''t think I''d > > recommend using this in a production environment. > > > > David > > > > > > Joe Noon wrote: > > > The following is posted at > > > > http://wiki.rubyonrails.com/rails/show/SQL%20Server%20(without%20Win32OLE%20dependancy) > > > > > > > > >>SQL Server (without Win32OLE dependancy) > > >> > > >>I have gotten SQL Server working with Rails on Linux using > > >>Free TDS? with unixODBC and the DBD::odbc driver. There > > >>are minimal changes required to the Active Record sqlserver > > >>adapter. I plan to get them cleaned up and posted back to the > > >>Rails developers in the next week or two. > > >> > > >>I am very interested in a pure Ruby SQL Server driver. If anyone > > >>is interested in collaborating on that, I''d be interested. > > >> > > >>June 15, 2005 15:33 by Mark Imbriaco > > > > > > > > > I am interested in a FreeTDS sql server adapter as well. If anyone > > > knows who Mark Imbriaco is please let me know so I can get in contact > > > with him to help with this project. This would be a huge addition in > > > my opinion and would allow some larger interests that have already > > > built a dependance on SQL Server to jump aboard the Rails without also > > > having to change databases, and be able to benefit from > > > lighttpd/fastcgi. Anyone interested please let me know. > > > > > > On 5/9/05, Neville Burnell <Neville.Burnell-uEDVyssJ3mUpAS55Wn97og@public.gmane.org> wrote: > > > > > >> > > >> > > >>Hi, > > >> > > >>Is anyone working on a pure ruby version of the MS SQL Server Adapter? > > >> > > >>The current adapter connects via ADO which means it only works on > Win32 :-( > > >> > > >>Neville > > >>_______________________________________________ > > >>Rails mailing list > > >>Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > >>http://lists.rubyonrails.org/mailman/listinfo/rails > > >> > > >> > > >> > > > > > > _______________________________________________ > > > Rails mailing list > > > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > > > > > > _______________________________________________ > > Rails mailing list > > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >_______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
On 6/20/05, David Kinkead <david.kinkead-jxQbuoToBN+Nls3PewDF2w@public.gmane.org> wrote:> Not sure this is exactly what you''re after, but I''ve put together a > FreeTDS-based MSSQL driver (DBD::MSSQL) that interfaces with Ruby/DBI. > Needs a little more work still before I submit it to the Ruby/DBI folks, > but it''s more or less functional. Let me know if you''re interested.David, I would be very interested in checking out what youve done! If you have time my email is joenoon at gmail.com Thanks! Joe