I have a licensed copy of vertica 6.1.2
I can access centos-hosted tables from my macbook (osx maverics) using vsql and DbVisualizer just fine.
I am using unixodbc (2.3.2) instead of the default iODBC which i was unable to get working.
I am using pyodbc 3.0.7
I wish to use pyodbc to connect to vertica from my mac.
I ran into numerous problems encountered on these forums.
https://community.vertica.com/vertica/t ... dbc_on_mac
https://community.vertica.com/vertica/t ... ding_issue
By following the instructions at the bottom of the second link, i was able to recompile pyodbc
python setup.py install
using unixodbc and the change for SQL_WCHAR
This took me from output like this
[(u'\U00103030\udc8d\udc35\uddcc\ude2d\udc8b\udd32\U000d6463\udd8d\ude30\udcd8\ude34\udc59\udc33\udd0d\udd30', u'\udc4d\udf37\udc4d\ude38', u'\U00056565\udc4e\udc39\U0005312d\udc8b\udd30\U000d3635\U00013465\U00033233\ude18\udd64\udc98\udd39', u'\U000f5246\U00022054'),
To correctly reading string variables.
However, when it comes to reading Numeric values from a table, I get
/Users/kbroughton/anaconda/python.app/Contents/lib/python2.7/decimal.pyc in _raise_error(self, condition, explanation, *args)
3870 # Errors should only be risked on copies of the context
3871 # self._ignored_flags = []
-> 3872 raise error(explanation)
3873
3874 def _ignore_all_flags(self):
InvalidOperation: Invalid literal for Decimal: u''
I've traced it to a call in getdata.cpp
static PyObject* GetDataDecimal(Cursor* cur, Py_ssize_t iCol)
If anyone has a fix for this, I can stop here.
At that point, i decided I needed to do some c++ debugging so I spend a day building a clang++ project culminating in the following
clang++ -g -o test_sqlwchar test_sqlwchar.cpp -I/Users/kbroughton/vcp/git/pyodbc/src/ -I/usr/local/Frameworks/Python.framework/Versions/2.7/include/python2.7/ -I/opt/vertica/include /usr/local/lib/libodbc.dylib /usr/local/lib/libodbcinst.dylib /opt/vertica/lib/libverticaodbc.dylib /usr/lib/libstdc++.dylib
Which does compile and link, but fails to run with the error
./test_sqlwchar
dyld: Library not loaded: ../Bin/Darwin_x8664/libVerticaODBC.dylib
Referenced from: /Users/kbroughton/vcp/git/pyodbc/./test_sqlwchar
Reason: image not found
Trace/BPT trap: 5
Here's the thing.. if i grep libVerticaODBC in the project or /opt/vertica or /usr/local/Cellar/unixodbc i get nothing. My odbc.ini and related files all use the correct
path to libverticaodbc.dylib as in the clang++ commandline above.
My hunch is that the capitalization is throwing things off, but I can't discover where that is coming from. I presume it corresponds to the camel case class name, but
can't figure out what is asking for the lib by the camelcase name.
If anyone has got pyodbc working on maverics, please share your secret sauce.
kesten
error linking libverticaodbc.dylib / InvalidOperation: Inval
Moderator: NorbertKrupa
Jump to
- General
- ↳ Welcome to vertica-forums.com!
- ↳ Board Announcements
- ↳ Request for New Forums Categories
- ↳ Announcements, Events and Activities
- ↳ Vertica Links
- ↳ General
- ↳ Employment
- ↳ Vertica Certification
- Newbie
- ↳ New to Vertica
- ↳ New to Vertica Database Administration
- ↳ New to Vertica Database Development
- ↳ New to Vertica SQL
- Using Vertica
- ↳ Vertica Database Administration
- ↳ Vertica Database Development
- ↳ Vertica SQL
- ↳ Vertica SQL Functions
- ↳ Vertica Database Designer (DBD)
- ↳ Vertica User Defined Functions (UDFs)
- ↳ Vertica External Procedures
- ↳ Vertica Analytics
- ↳ Vertica Management Console
- ↳ Vertica Error Codes
- ↳ Vertica Backup & Recovery
- ↳ Vertica Installation
- ↳ Vertica Security
- ↳ Vertica Performance Tuning
- ↳ Vertica Administration Tools
- ↳ Vertica Upgrade
- ↳ Vertica Migration
- ↳ Vertica and the Operating System
- ↳ Vertica Data Load
- ↳ Vertica Tips, Lessons and Examples
- ↳ Vertica "How to..."
- Connecting to Vertica
- ↳ ADO.NET
- ↳ Cognos
- ↳ DBeaver
- ↳ dbVisualizer
- ↳ HDFS Connector
- ↳ Hadoop Connector
- ↳ HCatalog Connector
- ↳ Informatica PowerCenter
- ↳ JDBC
- ↳ Microsoft SQL Server Analysis Services (SSAS)
- ↳ MicroStrategy
- ↳ Microsoft SQL Server Integration Services (SSIS)
- ↳ ODBC
- ↳ Perl
- ↳ PHP
- ↳ Python
- ↳ R Language Integration
- ↳ Rhapsody Interface Engine
- ↳ SQL Workbench/J
- ↳ SQuirreL SQL Client
- ↳ Talend
- ↳ Tableau
- ↳ Toad for Data Analysts
- ↳ Vertica SDK API
- ↳ VoltDB
- ↳ vSQL
- Vertica Portfolio
- ↳ Vertica Premium Edition
- ↳ Vertica Express Edition
- ↳ Vertica Community Edition
- ↳ Vertica SQL on Hadoop
- ↳ Vertica in the AWS Cloud
- ↳ Vertica on Microsoft Azure
- All times are UTC+01:00
- Top
- Delete all board cookies
Powered by phpBB ® | phpBB3 theme by KomiDesign