similar to: Ruby 1.9, Rails 2.3.2, and MSSQL issue

Hello Friends! :) I''ve sold my iBook before landing in LA yesterday and as long as I can''t afford buying a new one I have to do it with LINUX : ) I''ve been installing the system yesterday and it''s working good, performances on athlon are good and I''m satisfied but I have two questions.. a) which editor to use? b) is there any *session disabled*

I have followed the cookbook on http://wiki.rubyonrails.org/database-support/ms-sql but am having problems with the rails part. I can connect to the database using sqsh so I think all the freetds plumbing is good. When I try to connect to the db with a rake db:migrate or just using script/ console I get this error: >> Client.find(:first) DBI::InterfaceError: Unable to load driver

Hi, thanks for reading. Since hours, I am facing a problem and it seems that I am not able to solve it. Let''s say, I''ve got a model called "AnnotationType". This model has got a method called "foobar(x)". It''s just so simple. I can access this method in my unit tests, in the console (all modes), but if I start the server in production mode and try

There is something seriously wrong with DBI support for SQL server. I have tried both DBI::ODBC and DBI:ADO and the following code always fails. ---------- Code require ''dbi'' host= "DEVELOPMENT_DATABASE_SERVER" database="adventureworks2000" username="someusername" password="Somepwd" db = DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data

[Reposted now I've joined the list, so I hopefully don't get moderated out] Hi, I've upgraded lots of machines to 5.6 (thanks!) and there was one particular machine that I'd also like to upgrade to PHP 5.3. Unfortunately it seems I can't. On the machine I have php-mssql installed, and it appears that there is no php53-mssql. php-mssql is built from the php-extras SRPM, so

Hi all, I''m trying to get rails up on mssql for a friend, does anyone have experience? We''re working on a Windows XP box with MSSQL 2000 (no service pak), and both rails (1.1) and MSSQL are on the same box. I''m running into a bug (I think) where activerecord is using this syntax: SELECT TOP 1 * FROM users WHERE (users.user = ''jbgnuumnbu'')

Hi, I have an app with Delphi7 + MSSQL, developed during 10 years. Now, the users have asked me about some way to run this app into Linux Fedora Core 2/3. I use Fedora for apps in Java with no problems, but I never heard about Delphi run. I look at WineHQ site about this combination of Delphi + MSSQL but I didn't find. I found some thing about Delphi 7 install and slow behaviour in

Hi All, I am having a problem to access multiple databases with mssql I am running Ruby 1.8.4 and Rails 1.1 on Windows 2000 Advanced Server. I am simply trying to integrate the application I wrote before for Oracle to Mssql. The application works perfectly with Oracle with the installed driver OCI8. The app retrives data based on a search criteria from those databases. I followed the directions

require ''dbi'' # 0.4.2 dbh = DBI.connect(''DBI:ODBC:PACS'', ''username'', ''password'') This works in IRB; in Rails it fails (taken from Rails console): DBI::InterfaceError: Unable to load driver ''ODBC'' (underlying error: uninitialized constant DBI::DBD::ODBC) from

I have downloaded the php5 rpms from Centos and successfully am running them on RHEL4. However, there is no rpm for php-mssql. Has anyone created one that could be installed on RHEL4? Thanks. - Mark

Hello I am having trouble setting up the cdr_odbc with MSSQL server. Has anybody done this? I have followed what little documentation I can find. Asterisk errors on a connection error, but tcpdump doesn't even show an attempt. Does anybody have some examples for MSSQL ODBC CDR? I've downloaded unixODBC and the FreeTDS project, recompiled asterisk.... Thanks Duane Cox --------------

Hi all, I am testing with Asterisk 1.8.0 beta3 using realtime with a mssql server using freetds and unixodbc, which works with 1.6.1.20. With the same config in 1.8 I get an error when trying to start asterisk which says: [Aug 23 15:06:12] WARNING[7180]: loader.c:387 load_dynamic_module: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined

Hello, I'm trying to execute a stored procedure on a MSSQL Server from the dial plan, but it's not working. I'm getting the following error: Unable to execute query.... Asterisk has been compiled with UnixODBC, and I've done the necessary configurations in func_odbc, res_odbc and odbc.ini. Has anyone done this before with success? -------------- next part -------------- An HTML

Dear all, I'm running CentOS 5.1. Is there any way to run MSDE or MSSQL on Linux? Please help. Thanks, Chaminda Mendis

Hi Team,I need to connect two MSSQL servers.?One server ask me to enter user name and password. I can use dbConnect (from DBI package) to connect the serve.Another one do not ask me credential to access the serve. But when I remove UID and PWD, it doesn't work. Then I tried to use my PC log in credential for UID and PWD, it still doesn't allow me to access. The error message:?Error:

Workstations in our network fail to make ODBC SQL server connections using NT authentication mode. This is our situation: We are running Samba 2.2.7a as PDC. We also have one Windows 2000 server running MSSQL server and being a member of this domain. The MSSQL server is used by an accounting program (Exact Globe 2000) running on several client computers in our network (members of the domain).

Hi Roberto, What is the cpu and memory configuration of your guest? Are you pinning to dedicated CPUs, are you exposing host topology and cpu features, do you have dedicated I/O threads? Are you backing the guest memory with hugepages? All of the above will likely increase performance and minimise noise. Cheers, On 6 December 2016 at 05:13, Roberto Fichera <kernel at tekno-soft.it> wrote:

Hi, I have to connect to MSSQL server to get some TimeSeries value (datetime, float) on output. Datetime data type in R is a POSIXct date with information about timezone, daylight or solar time. In the DB I have not this kind of information and this cause some problem at the change of time for energy savings. Any idea on how to connect and have an simple and clear interpretation of date (without

Hello, I have rails using a MSSQL db. The set up works fine with low volume, but with 2+ requests/second I keep on getting the following error: DBI::DatabaseError: Execute OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction mode. HRESULT error code:0x80020009 Exception occurred.: SELECT

I''m trying to use activerecord outside of rails with a legacy mssql database. Reading from the db works, but when I try to save a new object (i.e. insert) I get the following error. DatabaseError: Execute (ActiveRecord::StatementInvalid) OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction