search for: psqlodbc

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_locati...

Hi, I'm running Debian (Sid), Postgres (7.3.4) and R (1.8.1). I get the following error when I tri to use DBI >library("DBI") > p <- dbDriver("PostgreSQL") Error in do.call(as.character(drvName), list(...)) : couldn't find function "PostgreSQL" Is there any other package I need in order to interface between R and Postgres ?

...not PostgreSQL that is the limitation. dbWriteTable in RSQLite was also able to handle this without truncating the data. I think these fields are 4-5000 characters wide, but don't actually know how to get the exact figure. The offending field is set as a text field in PostgreSQL. I'm using psqlODBC on Windows Server 2003 and R-2.6.0. Have I missed an argument somewhere that could solve the problem? I've read that RODBC has a field length limit of 64k. This could be the problem. Is there somewhere I could change this in the source code? Would that just give me other problems? Any assista...

My windows application uses BDE and PostgreSQL ODBC driver to access database server. I frist installed Wine on Ubuntu and then installed psqlodbc.exe and BDE. How can now I access ODBC administrator to add and configure PostgreSQL ODBC driver?

..."?????" when I try to establish an connection by using >con <- odbcConnect(dsn="MyDataSource",UID="Me",pwd="secret") Could anyone please hint me towards additional diagnostics I can run to pin down the problem? I have the latest versions of unixODBC and psqlODBC installed from Macports. They seem to be okay, because $isql dsn uid pwd works fine to connect to the database. Thanks in advance for your help, Julia

Wine 1.1.31 Msi package installs for sqlncli.msi and psqlodbc.msk (psqlodbc_08_04) do not install correctly. They are not displayed in by "wine odbcad32.exe". In previous betas they did work ok.

...or DSN=mydb;UID= postgres;PWD=secret The odbc.ini file generated by ODBC Administrator (an GUI tool that comes with OS X) looks like this: [ODBC Data Sources] mydb = PostgreSQL [ODBC] Trace = 0 TraceAutoStop = 0 TraceFile = TraceLibrary = [mydb] Driver = /usr/local/lib/psqlodbc.so Description = This is my database username = postgres password = secret servername = localhost port = 5432 database = mydb How might I get this working? Anthony

Hi, I'm trying to establish a connection to a MySQL database, and am using the rodbc package for it. This is in a GNU/Debian Linux box, with the corresponding Debian unstable packages. I can login to my MySQL databases from any shell and directory, so the problem is probably not there. Here's an example of what I'm doing: R> odbcConnect("test",

...localhost UserName=XXXX Password=XXXX Port=5432 Protocol=7.4 ReadOnly=No RowVersioning=No ShowSystemTables=Yes ShowOidColumn=Yes FakeOidIndex=Yes ConnSettings= root@pbx:# cat /etc/odbcinst.ini [PostgreSQL] Description=PostgreSQL ODBC driver for Linux and Windows Driver=/usr/local/lib/psqlodbc.so Setup=/usr/lib/odbc/libodbcpsqlS.so Debug = 1 CommLog = 1 root@pbx:# echo "select * from ast_config where filename='iax.conf' and commented=0 order by filename,cat_metric desc,var_metric asc,category,var_name,var_val,id" | isql Asterisk <lot of output from table&g...

Hi, I have installed RODBC on FreeBSD 4.9 and I am using the PostgreSQL ODBC Driver that is distributed with unixODBC 2.2.8. I can access ODBC Data Sources from Open Office so I think that everything is properly installed. When I installed RODBC I had to set export LIBS=-L/usr/local/lib so that R could locate my ODBC manager. I do not have any problems opening database connections and qurey

Greetings - is there any update on a PostgreSQL driver for the DBI package? If not, what's the currently-preferred method of creating a link from a PostgreSQL database and R? Thanks. ---------------------------------------------------------------------- Andrew J Perrin - andrew_perrin (at) unc.edu - http://www.unc.edu/~aperrin Assistant Professor of Sociology; Book Review Editor, _Social

Hi, I'm running Rgui v2.4.0, RODBC v1.1-8, and psqlODBC v8.2.0002. Whenever I do the following chan <- odbcConnect("mydatabase", uid="admin") # connection to a postgresql db on a linux box tmp <- sqlQuery(chan, "select * from sometable;") # this is successfull odbcClose(chan) # this crashes Rgui and raises an error...

...fips configured -- resuming normal operations I try to reinstall all PHP modules and get this messages Installing : php-xml-5.3.3-3.el6_2.6.x86_64 14/24 Installing : php-intl-5.3.3-3.el6_2.6.x86_64 15/24 Installing : php-embedded-5.3.3-3.el6_2.6.x86_64 16/24 */sbin/ldconfig: /opt/PostgreSQL/psqlODBC/lib/libpq.so.5 is not a symbolic link* Installing : php-soap-5.3.3-3.el6_2.6.x86_64 17/24 Installing : php-mbstring-5.3.3-3.el6_2.6.x86_64 18/24 Installing : php-snmp-5.3.3-3.el6_2.6.x86_64 19/24 PostgreSQL an APACHE runs normal and PHP does not recognize php_pgsql/pdo_pgsql. How i fix this...

When I run the rake db:migrate command, I get this: C:\testror\depot>rake db:migrate --trace (in C:/testror/depot) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate rake aborted! 182: Le systÞme d''exploitation ne peut pas exÚcuter %1. - c:/ruby/ lib/ruby/gem