python - Pyodbc Connection Error -


code

this code have entered using python 2.6 in linux red hat 64bit

import pyodbc  print pyodbc.datasources()  print "connecting via odbc"  conn = pyodbc.connect("driver={netezzasql};server=localhost;port=5480;database=database;uid=santiago;pwd=ha123;")

error

this true error received when running pyodbc. don't know language or means?

{'odbc': '', 'netezzasql': '/usr/local/nz_7.2.0.3/lib64/libnzodbc.so'} connecting via odbc traceback (most recent call last):   file "connect.py", line 41, in <module> conn = pyodbc.connect("driver{netezzasql};server=localhost;port=5480;database=database;uid=santiago;pwd=ha123;") pyodbc.error: ('h00', '[h00] [unixodbc]sre n/rpr trbtsaeepy\xc8 (33) (sqldriverconnectw)')

obdcinst.ini

this obdcinst file used

[odbc drivers] netezzasql = installed  [netezzasql] driver           = /usr/local/nz_7.2.0.3/lib64/libnzodbc.so setup            = /usr/local/nz_7.2.0.3/lib64/libnzodbc.so apilevel         = 1 connectfunctions = yyn description      = netezza odbc driver driverodbcver    = 03.51 debuglogging     = false logpath          = /tmp unicodetranslationoption = utf8 charactertranslationoption = prefetch         = 256 socket           = 16384

obdc.ini

this odbc configuration file used

; ;  odbc.ini ; [odbc data sources] nzsql = netezzasql   [netezzasql] ;path of driver used database connection driver                = /usr/local/nz_7.2.0.3/lib64/libnzodbc.so  ;a decription used identify database connection properties. description           = netezzasql odbc  ;the name of machine or ip address database located. servername            = 127.0.0.1  ;the port number connect. port                  = 5480  ;the name of database. database              = dev  ;the name of valid user. username              = guest  ;the password  user. password              = password  ;only select sql statements allowed if field checked. readonly              = false  ;when option enabled , application bindtype same   backend ;datatype query performance faster.query performance gain achieved  ;only single select statements (not batch queries).it works in case when ;application bind type different backend datatype there restrictions on it. fastselect            = false  ;when set true, system tables included in available table list. showsystemtables      = false  ;when set true, use old (2.5) functionality returning schemas in  sqltables. legacysqltables       = false  ;specifies login timeout in seconds. logintimeout          = 0  ;specifies query timeout in seconds. querytimeout          = 0  ;specifies date format follows - ; 1: ymd ; 2: mdy ; 3: dmy dateformat            = 1  ;when selected, driver treats sql_c_numeric buffers sql_c_char   buffers. numericaschar         = false  ;return sql_bit "1"/"0" when char. sqlbitonezero         = false  ;when enabled, replaces occurences of crlf, cr , lf single space. stripcrlf             = false  ;specifies level of security on system securitylevel         = preferredunsecured  ;name of root ca certificate. cacertfile            =  ;specifies maximum errors allowed. 0 value means no limit on  loadmaxerrors value. ;loadmaxerrors         = 1  ;if value true, rounds data of numeric columns precision  exceeds precision defined. ;loadroundfraction     = 0   [odbc] ianaappcodepage=4 installdir=/opt/odbc32v51 trace=0 tracedll=/opt/odbc32v51/lib/odbctrac.so tracefile=odbctrace.out usecursorlib=0

if else needed determine solution please let me know.

i can't tell error means don't recognize language either. however, netezza odbc port 5480, while specify 5668 in connection method. also, database want connect named "database"?


Comments

Post a Comment

Popular posts from this blog

r - Trouble relying on third party package imports in my package -

my package uses ggplot2 extensively make custom plots. import ggplot2 in namespace file. can build, install, , load package r without errors. when call function package, complains can't find function in imported package. function called had absolute nothing plotting , didn't make use of ggplot2 . how can make function calls package work without these types of errors? error in theme_beata() (from plot.r#14) : not find function "theme_classic" the first function erroring is: #' custom ggplot2 theme beata #' @import ggplot2 #' @family themes #' inheritparams ggplot2::theme_classic #' @export theme_beata <- function(base_size = 14, base_family="serif", ticks = true) { ret <- theme_classic() + theme(axis.line = element_line(size=0.6), axis.text = element_text(size = base_size), axis.title = element_text(size= base_size + 2), title = element_text(size=base_size + 4)) if (...
Read more

Payment information shows nothing in one page checkout page magento -

i using magento ver. 1.9.1.0 want remove shipping information , shipping method step 1 page checkout page. changed code in core file like in app\code\core\mage\checkout\block\onepage.php public function getsteps() { $steps = array(); $stepcodes = $this->_getstepcodes(); /* remove shipping address , shipping method */ $excludestep=array_diff($stepcodes,array('shipping','shipping_method')); //$excludestep=$stepcodes; if ($this->iscustomerloggedin()) { $stepcodes = array_diff($excludestep, array('login')); } foreach ($excludestep $step) { $steps[$step] = $this->getcheckout()->getstepdata($step); } return $steps; } and in app\code\core\mage\checkout\controllers\onepagecontroller.php public function savebillingaction() { if ($this->_expireajax()) { return; } if ($this->getrequest()-...
Read more