Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Python > Problem with Python module

Thread Tools

Problem with Python module

Posts: n/a
I want to connect to a remote MS SQL Server 2000 database through
my Fedora Core 2 machine via Python scripts. I have successfully
installed freetds & unixODBC and can now connect to the desired DB
through tsql(freetds) & isql(unixODBC). I installed mxODBC (RPM &
source) to be able to connect to the DB via Python scripts without any

The code( under test is as follows:

import mx.ODBC.unixODBC


conn=mx.ODBC.unixODBC.Connect (dsn, "maneesh_singh", "newuser")

print "Content-Type: text/plain"


print "MySQL Databse via mxODBC....\n"
cursorhandle.execute("select * from tb_mis_team")

for i in cursorhandle.fetchall():
print i

print cursorhandle.fetchall()

for i in cursorhandle.fetchall():
print i

The output is as follows:
[root@ps0778 cgi-bin]# python
Traceback (most recent call last):
File "", line 4, in ?
import mx.ODBC.unixODBC
File "/usr/lib/python2.3/site-packages/mx/ODBC/unixODBC/",
line 8, in ?
from mxODBC import *
ImportError: cannot open shared object file: No
such file or directory

Additional info:
[root@ps0778 unixODBC]# pwd
[root@ps0778 unixODBC]# ldd ./ => (0x0070b000) => /usr/lib/ (0x00b26000) => /lib/tls/ (0x007ca000) => /lib/tls/ (0x00eaa000) => not found => /lib/ (0x006b2000)
/lib/ => /lib/ (0x0089d000)

I want to use unixODBC and not iODBC, why is mxODBC looking for
iODBC's libraray? I had earlier tried to install iODBC,
unsuccessfully, hence shifted over to unixODBC. The missing iODBC
library exist in /usr/local/lib folder. Do I need to link the iODBC
library to mxODBC during installation? How? Configure in the
source setup?


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: F2PY: Access Fortran module data from multiple python module Gabriel Genellina Python 0 11-21-2008 04:22 AM
Re: module docstring, documentation,anything? please note is the module type/object NOT some module Maric Michaud Python 0 06-24-2006 12:42 PM
Converting a perl module to a python module would it be worth it? Mothra Python 5 04-15-2005 06:09 AM
PYTHON API : add new classes in a module from an other module mathieu gontier Python 1 09-01-2004 12:35 PM
Python-2.3b1 bugs on Windows2000 with: the new csv module, stringreplace, and the re module Daniel Ortmann Python 4 07-02-2003 03:23 PM