similar to: RODBC, freetds, and MS SQL Server

I don't know whether this is an RODBC issue, a psqlodbc issue or a PostgreSQL issue; I've searched the documentation and forums for each, with no success. I want to list all the tables in a PostgreSQL schema, and return the table comments as well as the table names. As an example, one table is defined as follows: CREATE TABLE scen990.ezone_locationprice_year1 ( ezone integer NOT NULL,

Hi all, I have a working 1.0.7 installation and it is recording CDR to mysql. I am using FreeTDS on the system currently to access our MS SQL 2000 server for account verification, we may use it to store CDR records there in the future. I have decided to update the installation to 1.0.9. However, during "make", I receive: make[1]: Entering directory `/usr/src/asterisk/cdr' gcc

Hello -- What repository, or other website, can I access in order to get the latest version of freetds? The version that comes with centos 6.2 is the 0.64 release, and it has a bug in it that is preventing me from running another application. The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the

Hi there ! I''m drilling for some framework/apserver solution and come to RoR. After using InstantRails, I would try to run it on my test platform (Solarix 10 x86 on 1 machine, Sybase ASE on another, FreeTDS for the join). I could not manage to have the sybase driver for ruby compile with FreeTDS. So I try to run a ODBC bridge. All seems good (freeTDS runnin, unixODBC working with

maybe someone here can help me understand why I am getting this strange behaivor. I am connecting to a MS SQL server from PHP by the ODBC module, I use unixODBC-2.2.9-1, freetds-0.63-1.2.el4.rf and php-4.3.9-3.9 all but the freetds package came with CentOS-4.2 + updates the problem is that I am getting -1 from the odbc_num_rows(); function, I search the net and it looks that this is a very

I''m having an error from Linux via freeTDS/ODBC to SQL Server with cod that runs fine against SQLite and MySQL. Here''s the code: def find_recipes_for_workorder_by_id @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :conditions => ["recipe.workorder_id = ?", params [:workorder]] render :template =>

Hi there ! After writing up a little adapter to access my sybase server, using odbc/dbi/freetds/unixodbc (yes all of these), it''s now time to have a *real* adapter, not running through to-many-to-count layers. I plan to use the FreeTDS library rather than Sybase because of the availability of FreeTDS for windows os. Is there already a work in progress for this kind of stuff ? Are

Hi, I'm trying to install FreeTDS. I followed the instructions on http://www.voip-info.org/tiki-index.php?page=FreeTDS, but still can't get it to work. I serched around trying to find instructions on it, and it seems the same info (even wording) appear on all sites I found. I downloaded freetds-0.63, and followed the instructions step by step, and when I try to re-compile Asterisk (#make

Hi, I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from sources. I installed freetds-common,freetds-dev, libct4, libsybdb5, freetds-bin, but, when I run configure and then make menuconfig in section "Call Detail Recording" -> "cdr_tds" it's "disabled". It only writes that "Depends on: freetds(E)". On another server (same

I would like some Asterisk community input: It was requested of me to create an Asterisk FreeTDS (cdr_tds.c) module to allow Asterisk to populate MS SQL Server (and Sybase) with CDR records. unixODBC has been thrown around as a bright shiny button but it adds an additional layer of DB abstraction. That additional layer of abstraction can cause problems when it is not necessary for our TDS (MS

I'm trying to use freetds/odbc to write CDR records to a MSSQL database but when I installed them and tried to compile asterisk again I get: _tds.c cdr_tds.c: In function `mssql_connect': cdr_tds.c:415: `TDSCONNECTINFO' undeclared (first use in this function) cdr_tds.c:415: (Each undeclared identifier is reported only once cdr_tds.c:415: for each function it appears in.)

Hello all, just curious if anyone's successfully compiled (*) with the latest FreeTDS code/driver. The Makefile in (*) seems to only take care of 0.63 or older. I tried to muck around with it a bit into tricking to compile for not just 0.63 but anything later than 0.62 but it seems to crap out complaining about CDR modules, which I really don't need. It's been a while since I tried it

Anyone know of a repository with the current - 1.0 - version of FreeTDS? ? The packaged version 0.91 from EPEL is considerably out of data. -- Meetings Coordinator, Michigan Association of Railroad Passengers 537 Shirley St NE Grand Rapids, MI 49503-1754 Phone: 616.581.8010 E-mail: awilliam at whitemice.org GPG#D95ED383 Web: http://www.marp.org

Hi folks, How would I go about running a stored procedure call from asterisk via func_odbc. I'm after an example entry in func_odbc if possible for ast 1.4 Also, if someone could post an insert statement that actually works, would be nice. Thanks, :)

All, I'm trying to connect to a remote SAS server using SAS's 9.1 ODBC driver and the RODBC package. I'm running R-2.6.1 on Win XP. I can successfully connect to the database, but no matter which table I query, I get back an empty table with only the column headers. For example: > sqlQuery(con, "select * from PRICES.DB_PRICES") [1] COMMOD_CURVE START_DATE

Hi, In an app I''m developing I''ve run into a strange problem. I''ve created some controllers and models using the scaffolding generator and everything seemed to work fine. However I''ve noticed that a particular model I''ve created always fails its tests and I can''t test it out in a browser due to the same error I''m getting which is:

I have a Postgres database that I am connecting to with the Postgres ODBC driver on Windows XP in R 2.1.0. In the database is a database with two schemas (public and X). With RODBC (1.1-4) , I can connect to the database and get the tables with sqlTables(db). I can query tables in the schema with sqlQuery("SELECT * FROM X.test"). However, I can't get the columns in table X.test

Hello, I decided to embrace getting a new Rails application to see an existing MSSQL database and trying to get unixODBC, freeTDS, and ActiveRecord able to query my MSSQL database. I''m following the procedure outlined at http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux but my system (Ubuntu 8.10 - Intrepid Ibex, Rails 2.3, Ruby 1.8.7)

Hello Everyone, I have been reading this mailing list for a while and am impressed with the generous help that many here are eager to provide. Perhaps someone will be able to shed some light on a configuration issue I am having. Thank you in advance for any assistance. First, system setup details: #System Setup# * OS: Fedora Core 4 running in a VMWare box on Windows XP * Database: MS SQL

Greetings, I have an application that connects to a remote SQL Server database using DBI/ODBC. If I run the application via the Rails console, I am able to retrieve data and work with the database just fine. If, however I try to access it via the Web application itself, I get the following error: DBI::DatabaseError (S1000 (0) [unixODBC][FreeTDS][SQL Server]Unable to connect to data source):