search for: tsql

Hello all, I am trying to connect to my remote MS SQL server from Ubuntu. I have followed HowtoConnectToMicrosoftSQLServerFromRailsOnLinux<http://http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux>as best that I can. TSQL is working, example below. My configs are found below. When I run isql : > isql -v pubs name password [IM002][unixODBC][Driver Manager]Data source...

RoR Equivalence of TSQL Stored Procedures and User defined functions As I browsed through the tutorials and online eBook ?Programming Ruby?, I have not come across the terms ?Stored Procedures? or ?User-defined functions? as I know them in SQL 2000. However, the online documentations in MySQL 5.0 show that Stored Pro...

...#### checking for mandatory modules: UNIXODBC... ok configure: creating ./config.status ######################################## And then when I go to make menuselect; [XXX]Res_odbc [XXX] func_odbc [XXX] cdr_odbc Can anyone help out with what I am missing? [I've gotten to a stage where tsql and isql connections to my sql db work, however, getting odbc right is making me pull my hair out a bit]

This might be better suited on a different list, but... Has anyone been able to retrieve information from a Cisco Call Manager to plug it in to an Asterisk box? I am attempting to use freetds and tsql to connect to the Microsft SQL server running on the Call Manager and get any and all information that I can. My big problem is that I can't figure out how to log on. I have set the password for the SQLSvc to something I know. I try this: tsql -S xxx.xxx.xxx.xxx -U 'DOMAIN\SQLSvc'...

Hello, Does asterisk func odbc support multi query? I'm executing stored procedure which returns two tables. With tsql command I can see both tables. But asterisk only shows the first. My database is MSSQL. Maybe there is workaround... Thanks -- Best Regards, Giedrius -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/201...

Hi everyone. I'm trying to use a windows third part software, and it uses a MSSQL database stored in a Windows 2008 Server. For this, I have Ubuntu 11, Wine 1.2 and WineTricks. Following the instructions on "How to configure Wine", the chapter 3.6 tell me to install MDAC_TYP.EXE, and then run CLICONFG.EXE and ODBCAD32.EXE. I did this. I run ODBCAD32 to configure my System DNS, but

...ntOS machine as follows: 1. Downloaded, compiled, and installed FreeTDS 0.63 2. Downloaded, compiled, and installed unixODBC 2.2.11 3. Downloaded, compiled, and installed Asterisk, Asterisk-Addons, and Zaptel from CVS HEAD We checked the FreeTDS and ODBC connections several ways, using the "tsql" and "isql" utilities, and Ethereal for network monitoring. Everything worked perfectly. Then we set up asterisk as follows: <extconfig.conf> [settings] sip.conf => odbc,asterisk,ast_config sipusers => odbc,asterisk,sip_buddies sippeers => odbc,asterisk,sip_buddie...

Hey :) We''re doing this large project, based on a legacy MSSQL database. We''ve had some issues, particularly with datetimes, when communicating with the server. These issues dissapeared after updating our ruby-odbc package to a new version (we''re developing on Linux and MacOS X, and connecting to the remote MSSQL server via FreeTDS and UnixODBC/iODBC, and then ruby-odbc

Hi, I have Asterisk 12.7.1 installed through Asterisk@Home CD. and explicitly I have installed UnixODBC and FREETDS in order to access MS SQL 2000 Database which in on Windows 2003 Server on remote location. I tested connectivity through isql and tsql, both utilities are working fine. I need to access MS SQL 2000 Database through PHP. When I tired to check the connectivity through a Test PHP file I got following results: Fatal error: Call to undefined function: odbc_connect() in /var/www/html/odbctest.php on line 3 By Default PHP was config...

...it) somehow but I can''t remember how. Also it''s off the Google radar but I can''t believe I''m the only person to experience it I''ve installed FreeTDS and unixODBC from DarwinPorts, along with rb- odbc and rb-dbi. I can connect to my SQL Server from tsql, but ActiveRecord won''t connect, and from in irb I get this error: irb(main):003:0> dbh = DBI.connect(''dbi:ODBC:MYDSN'',''MYUSER'',''MYPASS'') NoMethodError: undefined method `default_attributes'' for #<ODBC::Driver:0x485a...

I've successfully connected to my SQL server with tsql (freetds) and isql (unixodbc). I've followed the wiki, and everytime I try and run * shutdowns with a segmentation fault. Any help? Luke Catranis

...ing an application (made in C #) in wine, this application has a connection to a database (ms sql ).... and running this application there are no errors, but I get an alert message notifying me that it is impossible to connect because it is not or is blocked. I did a test connectivity and connects tsql ... hize also run the application in Windows, and perfect ... then that configuration files should work ... The type of connection is through OLE DB .... thx

I am trying to get access to a Microsoft SQL Server 2k installation on my network. To this point I''m not having any luck. I''ve followed the instructions at http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnOSX up to the point where you run the iodbctest where I get an error. The errors are: iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0001.0928 1: SQLDriverConnect = [iODBC][Driver Manager]Data source name not found and no default...

Help! I've been using mysql for cdr storage, I need to switch to MS SQL. I must be stupid or something but I cannot figure out how to setup the cdr_tds. I have FreeTDS configured properly, but my unixodbc is not working properly either... I'd be happy with either solution, but I'm in need of assistance. Luke Catranis

I could not find the answer to this in a few Google searches and thought I would ask. So when are prepared statements best leveraged in ActiveRecord''s interface? I never really noticed before, but simple condition hashes or scopes do not pass down the binds so that prepared statements are leveraged. So a `Car.find(1)` would but things like `Car.where(:id => 1).first` do not. Is it a

Hi -- I''ve been having problems connecting to a SQL Server database that I thought might be related to the fact I was upgrading Rails to 2.0. However, I also was moving the project to my shiny new macbook. Anyway, after jumping through a few hoops (instaling DBI, etc.), I finally get to my latest error message: <error> DBI::InterfaceError: Could not load driver (no such file to

I'm trying to optimize some database app running on a CentOS server and wanted to confirm some things about the disk/file caching mechanism. >From what I've read, Linux has a Virtual Filesystem layer that sits between the physical file system and everything else. So no matter what FS is used, applications are still addressing the VFS. Due to this, disk caching is done on an inode/block

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

...NECTINFO *connection = NULL; char query[128]; if (!(login = tds_alloc_login())) { ast_log(LOG_ERROR, "tds_alloc_login() failed.\n"); return -1; } tds_set_server(login, abcdhostname); tds_set_user(login, abcddbuser); tds_set_passwd(login, abcdpassword); tds_set_app(login, "TSQL"); tds_set_library(login, "TDS-Library"); #ifndef TDS_PRE_0_62 tds_set_client_charset(login, abcdcharset); #endif tds_set_language(login, abcdlanguage); tds_set_packet(login, 512); tds_set_version(login, 7, 0); if (!(context = tds_alloc_context())) { ast_log(LOG_ERROR, "...

Hi, Is anyone using Oracle with RoR successfully? Is everything running smoothly? What are the main issues? any response is appreciated thanks, Chris -- Posted via http://www.ruby-forum.com/.