search for: dbname

Displaying 20 results from an estimated 808 matches for "dbname".

Did you mean: d_name
2009 Feb 18
0
Segmentation Fault occured while connecting to the database
Hi All, Can anyone help me please?I don't know much about segmentation faults.I understand what it is,but why my script's throwing the error i don't know. This is my main function:---- *main<-function()* *{* * dbName<-"xyz_database"* * hostName<-"xyz.com"* * con<-myDbconnect(dbName,hostName) * * * * #Fetching exact sub group names* * sub_grp_exact_num<-getSbGrpExactNum(con)* * sub_grp_...
2009 Aug 07
1
RMySQL - overwrite record, not table
Hi, useR- In RMySQL, how do I overwrite records? (equivalent to "replace" query). For example, suppose that dat2 is a newer data.frame than dat1. con <- dbConnect(MySQL()) res <- dbWriteTable(con, "DBname", dat1, row.names=F, append=T, replace=T) res <- dbWriteTable(con, "DBname", dat2, row.names=F, append=T, replace=T) This would not update/replace the dat1 records in "DBname" with newer records from dat2. How would you solve the problem? Thanks= -- View this messa...
2009 Feb 20
2
importing data to SQLite database with sqldf
...quot;) (do I need it for SQLite?) ## sqldf("attach 'mydb.db' as new") f <- file("myexample.txt") attr(f,"file.format") <- list(header=TRUE,sep="\t") sqldf("create table myexample as select * from f", stringsAsFactors=FALSE, dbname="mydb.db") ## or f <- file(fi) sqldf("create table myexample as select * from f", stringsAsFactors=FALSE,file.format=list(header=TRUE,sep="\t"), dbname="mydb.db") ## sqldf("select * from myexample",dbname="mydb.db") gives me...
2009 Feb 23
0
Segmentation Fault still exists
...ot;0.1-11" * *RMySQL "0.5-11" * * * *MySQL version: 5.0.32* *A small R- program* *also doesn't run now*,whereas with these same configurations,i ran correlation analysis,regression analysis for my datasets. Now if i do this :--- *library(RMySQL) myDbconnect<-function(dbName,hostName) { print("myDbconnect print before driver") drv<-MySQL() #print(drv) print("myDbconnect print after driver") #con <- dbConnect(drv, user="xyz", password="xyz",dbname = dbName, host = hostName) con<-dbConnect(drv)...
2009 May 16
1
Fwd: Cannot allocate a new database connection error
...error in evaluating the argument 'conn' in selecting a method for function 'dbSendQuery' Error in is(object, Cl) : error in evaluating the argument 'res' in selecting a method for function 'fetch'* *this is my DB connection function* *myDbConnect <- function (dbName, hostName) { drv<-MySQL() con <- dbConnect(drv, user="xyz", password="xyz",dbname = dbName, host = hostName) return(con) }* everytime i need ,Db connection , i used in this way:---- This is the structure of my code:-- main <- function () {...
2004 Sep 01
1
Omega cgi question
IRIX 6.5.22, compiled omega.0.8.1 with native MIPS compiler. omega.cgi isn't running from apache. From the log: [Wed Sep 1 10:04:36 2004] [error] [client 198.149.32.31] malformed header from script. Bad header=Caught unknown exception: /var/www/cgi- bin/omega.cgi This is with a url of http://<machine>/cgi-bin/omega.cgi?DB=/open/ When I run it from the command line with no
2005 Feb 22
1
Rdbi and ODBC
...t;- odbcConnect("xf", "xfl2", "xfl2") Now for Rdbi the documentation is lacking. "?Rdbi" doesn't work and "?dbConnect" gives little detail and no examples. I tried all of the following without success: conn <- dbConnect("ODBC()", dbname="xf", user="xfl2", password="xfl2") conn <- dbConnect("ODBC", dbname="xf", user="xfl2", password="xfl2") conn <- dbConnect(ODBC, dbname="xf", user="xfl2", password="xfl2") conn <- dbConnect(...
2016 Apr 21
2
Error using RPostgreSQL
...g trouble connecting to my postgreSQL db on Heroku(Amazon) using RPostgreSQL. I've looked through GitHub for people doing the same thing. There are quite a few examples and all look similar to the below: drv <- dbDriver("PostgreSQL") con <- dbConnect( drv, dbname = "dadqn30er7ghpl", host = "ec2-27-837-167-90.eu-west-1.compute.amazonaws.com", port = 5432, user = "tascofyvasswmblc", password = XXXXXX' ); I'm getting the error: Error in postgresqlNewConnection(drv, ...) : RS-DBI...
2005 Jul 20
5
Can't connect to MySQL on another machine
...st_controller with "scaffold :test" in it). What I get is: ---- Mysql::Error in Test#index Access denied for user ''''@''192.168.0.3'' (using password: NO) ---- Here''s what database.yml looks like: ---- development: adapter: mysql database: dbname host: 192.168.0.4 username: username password: somepassword ---- The database, user name and password are the same as the ones used to connect with "mysql". (and yeah, I restarted webrick after modifying the file) Any pointers appreciated, Cheers
2004 Jun 10
1
pgsql documentation
From dovecot-pgsql.conf # Examples: # connect = host=192.168.1.1 dbname=users # connect = host=sql.example.com dbname=virtual user=virtual There is a reference to identify the rest of the parameters via libpq in the postgres documentation. From postgres, libpq says the connection environment variables are: hostname:port:database:username:password http://www.postg...
2006 Feb 06
0
dovecot-cvs/mysql-5.0.18 OLD/PASSWORD problem
...ysql$> SET PASSWORD FOR 'db_user'@'localhost' = OLD_PASSWORD('db_pw'); now, dovecot CAN connect to mysql-server and everything work fine i patched src/lib-sql/driver-mysql.c to test, use something like: i_error("host(%s), db->user(%s), db->password(%s), db->dbname(%s) ....); before mysql_real_connect(), then see the maillog, the db->user/password/dbname is correct maillog: auth-worker(default): conn->mysql is NOT NULL auth-worker(default): host((null)), db->user(db_user), db->password(db_pw), db->dbname(dbname), db->port(0), unix_socket(/m...
2010 Feb 09
1
Help on R functions
Dear R Experts, I have written a following function :- myfunction<- function(servername,dbname,dbtablename){ library(RODBC) channel <- odbcDriverConnect("driver=SQL Server;server=servername") initdata<- sqlQuery(channel,paste("select * from dbname .. dbtablename")) return(dim(initdata)) } I have written this function which has input parameters like servername ,db...
2005 Jan 29
2
Database Connection Problem with RMySQL package
...downloaded from bell lab: http://stat.bell-labs.com/RS-DBI/download/index.html My case in R is as follows: > library(DBI) > library(RMySQL) > mgr <- dbDriver("MySQL") > con <- dbConnect(mgr, user="root", pass="*******", host="localhost", dbname="campus") Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect root at localhost on dbname "campus") What am I doing wrong with?... It is really an annoying question. Thank you very much for your help and patience. Yours truly, Willie Y CHEN -- *********...
2005 Aug 05
3
Compile trouble with mysql
Hello! I tried to compile the latest 1.0-test (79) with mysql support, but there is the following error: ... /usr/local/mysql/lib/libmysqlclient.a(sha1.o)(.text+0x5c): In function `sha1_result': : multiple definition of `sha1_result' ../lib/liblib.a(sha1.o)(.text+0x830):/usr/local/src/dovecot/dovecot-1.0-test79/src/lib/sha1.c:233: first defined here ... So 'sha1_result' is
2003 Jul 11
4
module : cdr_sybase.so
...nnected to sybase database.\n"); } res = ast_cdr_register(name, desc, sybase_log); if (res) { ast_log(LOG_ERROR, "Unable to register Sybase CDR handling\n"); } return res; } int reload(void) { struct ast_config *cfg; struct ast_variable *var; char *hostname, *dbname, *password, *dbuser; cfg = ast_load(config); if (!cfg) { ast_log(LOG_WARNING, "Unable to load Sybase CDR config %s\n", config); return 0; } var = ast_variable_browse(cfg, "global"); if (!var) { /* nothing configured */ return 0; } hostname = ast...
2002 Aug 02
2
variables inside an Rdi-select statement?!
...R-users, I would like to use an environment variable inside an SELECT-statement from R to a postgres-db, but it will not work and so I need some advice from you. <code> ezg <- Sys.getenv("EZG") connect <- dbConnect.PgSQL(host="localhost", user="username", dbname="dbname") query <- dbSendQuery(connect, "SELECT ezg.s FROM ezg WHERE ezg.s!='12'") </code> the error is, that SELECT searches for the relation ezg, but it should use value stored in ezg. Any suggestions? thanks in advance stephan -- Linux: the operating...
2006 Dec 04
4
MySQL cmd % pattern matching
Hi All Does anyone know how to use the MySQL cmd in Asterisk with LIKE and % in the query? I have: exten => s,5,Set(query=SELECT name from contacts where tel like %${number}) exten => s,6,MySQL(Connect connid hostname username password dbname) exten => s,7,MySQL(Query resultid ${connid} ${query}) But there seems to be a problem with the % sign and I don't know how to hash it out. It works without the % sign. Thanks Kind Regards Garth
2004 Nov 02
2
A little more on R, mdbtools and Access databases
...gEmpID < 3") lngEmpID strAccess 1 1 Admin 2 2 User > Here are the functions: ### Some quick code to make use of mdb-tools to use MS Access tables in R. ### 2004-11-02 ### David Whiting require(gdata) # for the trim function. mdbTables <- function(dbname) { system(paste("mdb-tables -d '\t' -S", dbname), intern=TRUE) } mdbReadTable <- function(dbname,tableName) { tableName <- dQuote(tableName) read.table(pipe(paste("mdb-export -d '\t' ", dbname, tableName)), sep="\t", header=TRUE) } mdbD...
2003 Oct 11
2
Problem in 'methods' package (PR#4525)
...n. Somehow the function '.valueClassTest' which is defined on package 'methods', is not being defined. To ilustrate how this breaks DBI, try this in a 1.8.0 R install (with DBI installed): > library(DBI) > con <- dbConnect(dbDriver("MySQL"), dbname = "test") Error in dbConnect(dbDriver("MySQL"), dbname = "test") : couldn't find function ".valueClassTest" A dirty fix would be defining it by hand (from src/library/methods/R/RMethodUtils.R) : .valueClassTest <- function(object,...
2007 Jan 17
3
Asterisk 1.4 and CDR
...l zlib # yum install zlib-devel # yum install ncurses-devel Install perl support perl -MCPAN -e "install DBD::mysql" I compile /usr/src/asterisk-addons as follows: # ./configure # make clean # make install In the file /etc/asterisk/cdr_mysql.conf [global] hostname=localhost dbname=asteriskcdrdb table=cdr password=strongpass user=asterisk port=3306 userfield=1 In the File asterisk-stat define ("WEBROOT", "http://192.168.190.10/asterisk-stat/"); define ("FSROOT", "/var/www/html/asterisk-stat-v2/"); define ("LIBDIR", FSROOT...