informix DB with RobotFramework
up vote
0
down vote
favorite
I am trying to connect to informix DB from Robotframework script running on Mac. I have installed Robotframework-Database-Library[1.0.1] from http://franz-see.github.io/Robotframework-Database-Library/.
tried to install Informix DB per https://wiki.python.org/moin/Informix. Ran into issue
error: Can't find esql. Please set INFORMIXDIR correctly.
tried to install mxODBC using python. still running into error
I have installed egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt as this is precondition. Tried to verify the mx-base using.
$ pip install egenix-mx-base
Requirement already satisfied: egenix-mx-base in /Library/Python/2.7/site-packages.
Then tried to install egenix-mxodbc-3.3.6-py2.7_ucs2-macosx-10.4-fat-prebuilt.
msuresh$ python setup.py install
running install
found usable build data file 'build/build-py2.7_ucs2.pck'
prebuilt archive found: skipping the build process and loading the prebuilt archive
setting platform to 'macosx-10.4-fat'
adjusting distutils platform string from 'macosx-10.13-x86_64' to 'macosx-10.4-fat'
restoring build data from a previous build run
loaded build data for platform 'macosx-10.4-fat'
running install_lib
writing byte-compilation script '/var/folders/dc/nwlkjl0129d3qm1j8m5czmgsnkqkf_/T/tmpRNEu3H.py'
/usr/local/opt/python@2/bin/python2.7 -O /var/folders/dc/nwlkjl0129d3qm1j8m5czmgsnkqkf_/T/tmpRNEu3H.py
removing /var/folders/dc/nwlkjl0129d3qm1j8m5czmgsnkqkf_/T/tmpRNEu3H.py
running install_data
running install_egg_info
Removing /usr/local/lib/python2.7/site-packages/egenix_mxodbc-3.3.6-py2.7.egg-info
Writing /usr/local/lib/python2.7/site-packages/egenix_mxodbc-3.3.6-py2.7.egg-info
But on trying to verify mxodbc --> does through me error.
>>> import mx.ODBC.Manager
Traceback (most recent call last):
File "", line 1, in
File "mx/ODBC/Manager/__init__.py", line 48, in
ImportError: None of the supported ODBC managers unixODBC, iODBC or DataDirect could be imported: dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so, 2): no suitable image found. Did find:
/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so: no matching architecture in universal wrapper
/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so: no matching architecture in universal wrapper, dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/iODBC/mxODBC.so, 2): no suitable image found. Did find:
/usr/local/lib/python2.7/site-packages/mx/ODBC/iODBC/mxODBC.so: no matching architecture in universal wrapper
/usr/local/lib/python2.7/site-packages/mx/ODBC/iODBC/mxODBC.so: no matching architecture in universal wrapper, No module named DataDirect
.. Any help to get informix connection via Robotframework would be appreciated.
python-3.x robotframework informix
asked Nov 7 at 22:02
MSQA
83
|
show 1 more comment
up vote
0
down vote
favorite
I am trying to connect to informix DB from Robotframework script running on Mac. I have installed Robotframework-Database-Library[1.0.1] from http://franz-see.github.io/Robotframework-Database-Library/.
tried to install Informix DB per https://wiki.python.org/moin/Informix. Ran into issue
error: Can't find esql. Please set INFORMIXDIR correctly.
tried to install mxODBC using python. still running into error
I have installed egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt as this is precondition. Tried to verify the mx-base using.
$ pip install egenix-mx-base
Requirement already satisfied: egenix-mx-base in /Library/Python/2.7/site-packages.
Then tried to install egenix-mxodbc-3.3.6-py2.7_ucs2-macosx-10.4-fat-prebuilt.
msuresh$ python setup.py install
running install
found usable build data file 'build/build-py2.7_ucs2.pck'
prebuilt archive found: skipping the build process and loading the prebuilt archive
setting platform to 'macosx-10.4-fat'
adjusting distutils platform string from 'macosx-10.13-x86_64' to 'macosx-10.4-fat'
restoring build data from a previous build run
loaded build data for platform 'macosx-10.4-fat'
running install_lib
writing byte-compilation script '/var/folders/dc/nwlkjl0129d3qm1j8m5czmgsnkqkf_/T/tmpRNEu3H.py'
/usr/local/opt/python@2/bin/python2.7 -O /var/folders/dc/nwlkjl0129d3qm1j8m5czmgsnkqkf_/T/tmpRNEu3H.py
removing /var/folders/dc/nwlkjl0129d3qm1j8m5czmgsnkqkf_/T/tmpRNEu3H.py
running install_data
running install_egg_info
Removing /usr/local/lib/python2.7/site-packages/egenix_mxodbc-3.3.6-py2.7.egg-info
Writing /usr/local/lib/python2.7/site-packages/egenix_mxodbc-3.3.6-py2.7.egg-info
But on trying to verify mxodbc --> does through me error.
>>> import mx.ODBC.Manager
Traceback (most recent call last):
File "", line 1, in
File "mx/ODBC/Manager/__init__.py", line 48, in
ImportError: None of the supported ODBC managers unixODBC, iODBC or DataDirect could be imported: dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so, 2): no suitable image found. Did find:
/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so: no matching architecture in universal wrapper
/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so: no matching architecture in universal wrapper, dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/iODBC/mxODBC.so, 2): no suitable image found. Did find:
/usr/local/lib/python2.7/site-packages/mx/ODBC/iODBC/mxODBC.so: no matching architecture in universal wrapper
/usr/local/lib/python2.7/site-packages/mx/ODBC/iODBC/mxODBC.so: no matching architecture in universal wrapper, No module named DataDirect
.. Any help to get informix connection via Robotframework would be appreciated.
python-3.x robotframework informix
asked Nov 7 at 22:02
MSQA
83
Have you walked through the installation procedure on the egenix-mxodbc page?
– A. Kootstra
Nov 8 at 19:56
Yes, I have installled egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt, then tried to install egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt. Tried to verify the mx-base using --> $ pip install egenix-mx-base Requirement already satisfied: egenix-mx-base in /Library/Python/2.7/site-packages. But on trying to verify mxodbc --> does through me error. > ** ImportError: None of the supported ODBC managers unixODBC, iODBC or DataDirect could be imported: dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so, 2): no suitable image found. Did find:**
– MSQA
Nov 8 at 20:42
Can you add the information to the question itself, instead of posting as a comment. This will allows you more formatting options and keeps all your information in one place.
– A. Kootstra
Nov 8 at 20:44
Thank you for the tip. i hope i have made the issue clear
– MSQA
Nov 8 at 21:16
On the Robotframework-Database-Library going to the linked A Database API Specification 2.0 Python Module page you'll find Informix under [General Purpose Databases]( wiki.python.org/moin/…). Under the section for mxODBC you'll find the following note:The Informix ODBC drivers needed for mxODBC are included in the Informix CSDK.Do you have this installed?
– A. Kootstra
Nov 8 at 21:32
|
show 1 more comment
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am trying to connect to informix DB from Robotframework script running on Mac. I have installed Robotframework-Database-Library[1.0.1] from http://franz-see.github.io/Robotframework-Database-Library/.
tried to install Informix DB per https://wiki.python.org/moin/Informix. Ran into issue
error: Can't find esql. Please set INFORMIXDIR correctly.
tried to install mxODBC using python. still running into error
I have installed egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt as this is precondition. Tried to verify the mx-base using.
$ pip install egenix-mx-base
Requirement already satisfied: egenix-mx-base in /Library/Python/2.7/site-packages.
Then tried to install egenix-mxodbc-3.3.6-py2.7_ucs2-macosx-10.4-fat-prebuilt.
msuresh$ python setup.py install
running install
found usable build data file 'build/build-py2.7_ucs2.pck'
prebuilt archive found: skipping the build process and loading the prebuilt archive
setting platform to 'macosx-10.4-fat'
adjusting distutils platform string from 'macosx-10.13-x86_64' to 'macosx-10.4-fat'
restoring build data from a previous build run
loaded build data for platform 'macosx-10.4-fat'
running install_lib
writing byte-compilation script '/var/folders/dc/nwlkjl0129d3qm1j8m5czmgsnkqkf_/T/tmpRNEu3H.py'
/usr/local/opt/python@2/bin/python2.7 -O /var/folders/dc/nwlkjl0129d3qm1j8m5czmgsnkqkf_/T/tmpRNEu3H.py
removing /var/folders/dc/nwlkjl0129d3qm1j8m5czmgsnkqkf_/T/tmpRNEu3H.py
running install_data
running install_egg_info
Removing /usr/local/lib/python2.7/site-packages/egenix_mxodbc-3.3.6-py2.7.egg-info
Writing /usr/local/lib/python2.7/site-packages/egenix_mxodbc-3.3.6-py2.7.egg-info
But on trying to verify mxodbc --> does through me error.
>>> import mx.ODBC.Manager
Traceback (most recent call last):
File "", line 1, in
File "mx/ODBC/Manager/__init__.py", line 48, in
ImportError: None of the supported ODBC managers unixODBC, iODBC or DataDirect could be imported: dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so, 2): no suitable image found. Did find:
/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so: no matching architecture in universal wrapper
/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so: no matching architecture in universal wrapper, dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/iODBC/mxODBC.so, 2): no suitable image found. Did find:
/usr/local/lib/python2.7/site-packages/mx/ODBC/iODBC/mxODBC.so: no matching architecture in universal wrapper
/usr/local/lib/python2.7/site-packages/mx/ODBC/iODBC/mxODBC.so: no matching architecture in universal wrapper, No module named DataDirect
.. Any help to get informix connection via Robotframework would be appreciated.
python-3.x robotframework informix
asked Nov 7 at 22:02
MSQA
83
I am trying to connect to informix DB from Robotframework script running on Mac. I have installed Robotframework-Database-Library[1.0.1] from http://franz-see.github.io/Robotframework-Database-Library/.
tried to install Informix DB per https://wiki.python.org/moin/Informix. Ran into issue
error: Can't find esql. Please set INFORMIXDIR correctly.
tried to install mxODBC using python. still running into error
I have installed egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt as this is precondition. Tried to verify the mx-base using.
$ pip install egenix-mx-base
Requirement already satisfied: egenix-mx-base in /Library/Python/2.7/site-packages.
Then tried to install egenix-mxodbc-3.3.6-py2.7_ucs2-macosx-10.4-fat-prebuilt.
msuresh$ python setup.py install
running install
found usable build data file 'build/build-py2.7_ucs2.pck'
prebuilt archive found: skipping the build process and loading the prebuilt archive
setting platform to 'macosx-10.4-fat'
adjusting distutils platform string from 'macosx-10.13-x86_64' to 'macosx-10.4-fat'
restoring build data from a previous build run
loaded build data for platform 'macosx-10.4-fat'
running install_lib
writing byte-compilation script '/var/folders/dc/nwlkjl0129d3qm1j8m5czmgsnkqkf_/T/tmpRNEu3H.py'
/usr/local/opt/python@2/bin/python2.7 -O /var/folders/dc/nwlkjl0129d3qm1j8m5czmgsnkqkf_/T/tmpRNEu3H.py
removing /var/folders/dc/nwlkjl0129d3qm1j8m5czmgsnkqkf_/T/tmpRNEu3H.py
running install_data
running install_egg_info
Removing /usr/local/lib/python2.7/site-packages/egenix_mxodbc-3.3.6-py2.7.egg-info
Writing /usr/local/lib/python2.7/site-packages/egenix_mxodbc-3.3.6-py2.7.egg-info
But on trying to verify mxodbc --> does through me error.
>>> import mx.ODBC.Manager
Traceback (most recent call last):
File "", line 1, in
File "mx/ODBC/Manager/__init__.py", line 48, in
ImportError: None of the supported ODBC managers unixODBC, iODBC or DataDirect could be imported: dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so, 2): no suitable image found. Did find:
/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so: no matching architecture in universal wrapper
/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so: no matching architecture in universal wrapper, dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/iODBC/mxODBC.so, 2): no suitable image found. Did find:
/usr/local/lib/python2.7/site-packages/mx/ODBC/iODBC/mxODBC.so: no matching architecture in universal wrapper
/usr/local/lib/python2.7/site-packages/mx/ODBC/iODBC/mxODBC.so: no matching architecture in universal wrapper, No module named DataDirect
.. Any help to get informix connection via Robotframework would be appreciated.
python-3.x robotframework informix
python-3.x robotframework informix
asked Nov 7 at 22:02
MSQA
83
asked Nov 7 at 22:02
MSQA
83
edited Nov 8 at 21:20
asked Nov 7 at 22:02
MSQA
83
asked Nov 7 at 22:02
MSQA
83
asked Nov 7 at 22:02
MSQA
83
83
Have you walked through the installation procedure on the egenix-mxodbc page?
– A. Kootstra
Nov 8 at 19:56
Yes, I have installled egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt, then tried to install egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt. Tried to verify the mx-base using --> $ pip install egenix-mx-base Requirement already satisfied: egenix-mx-base in /Library/Python/2.7/site-packages. But on trying to verify mxodbc --> does through me error. > ** ImportError: None of the supported ODBC managers unixODBC, iODBC or DataDirect could be imported: dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so, 2): no suitable image found. Did find:**
– MSQA
Nov 8 at 20:42
Can you add the information to the question itself, instead of posting as a comment. This will allows you more formatting options and keeps all your information in one place.
– A. Kootstra
Nov 8 at 20:44
Thank you for the tip. i hope i have made the issue clear
– MSQA
Nov 8 at 21:16
On the Robotframework-Database-Library going to the linked A Database API Specification 2.0 Python Module page you'll find Informix under [General Purpose Databases]( wiki.python.org/moin/…). Under the section for mxODBC you'll find the following note:The Informix ODBC drivers needed for mxODBC are included in the Informix CSDK.Do you have this installed?
– A. Kootstra
Nov 8 at 21:32
|
show 1 more comment
Have you walked through the installation procedure on the egenix-mxodbc page?
– A. Kootstra
Nov 8 at 19:56
Yes, I have installled egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt, then tried to install egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt. Tried to verify the mx-base using --> $ pip install egenix-mx-base Requirement already satisfied: egenix-mx-base in /Library/Python/2.7/site-packages. But on trying to verify mxodbc --> does through me error. > ** ImportError: None of the supported ODBC managers unixODBC, iODBC or DataDirect could be imported: dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so, 2): no suitable image found. Did find:**
– MSQA
Nov 8 at 20:42
Can you add the information to the question itself, instead of posting as a comment. This will allows you more formatting options and keeps all your information in one place.
– A. Kootstra
Nov 8 at 20:44
Thank you for the tip. i hope i have made the issue clear
– MSQA
Nov 8 at 21:16
On the Robotframework-Database-Library going to the linked A Database API Specification 2.0 Python Module page you'll find Informix under [General Purpose Databases]( wiki.python.org/moin/…). Under the section for mxODBC you'll find the following note:The Informix ODBC drivers needed for mxODBC are included in the Informix CSDK.Do you have this installed?
– A. Kootstra
Nov 8 at 21:32
Have you walked through the installation procedure on the egenix-mxodbc page?
– A. Kootstra
Nov 8 at 19:56
Have you walked through the installation procedure on the egenix-mxodbc page?
– A. Kootstra
Nov 8 at 19:56
Yes, I have installled egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt, then tried to install egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt. Tried to verify the mx-base using --> $ pip install egenix-mx-base Requirement already satisfied: egenix-mx-base in /Library/Python/2.7/site-packages. But on trying to verify mxodbc --> does through me error. > ** ImportError: None of the supported ODBC managers unixODBC, iODBC or DataDirect could be imported: dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so, 2): no suitable image found. Did find:**
– MSQA
Nov 8 at 20:42
Yes, I have installled egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt, then tried to install egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt. Tried to verify the mx-base using --> $ pip install egenix-mx-base Requirement already satisfied: egenix-mx-base in /Library/Python/2.7/site-packages. But on trying to verify mxodbc --> does through me error. > ** ImportError: None of the supported ODBC managers unixODBC, iODBC or DataDirect could be imported: dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so, 2): no suitable image found. Did find:**
– MSQA
Nov 8 at 20:42
Can you add the information to the question itself, instead of posting as a comment. This will allows you more formatting options and keeps all your information in one place.
– A. Kootstra
Nov 8 at 20:44
Can you add the information to the question itself, instead of posting as a comment. This will allows you more formatting options and keeps all your information in one place.
– A. Kootstra
Nov 8 at 20:44
Thank you for the tip. i hope i have made the issue clear
– MSQA
Nov 8 at 21:16
Thank you for the tip. i hope i have made the issue clear
– MSQA
Nov 8 at 21:16
On the Robotframework-Database-Library going to the linked A Database API Specification 2.0 Python Module page you'll find Informix under [General Purpose Databases]( wiki.python.org/moin/…). Under the section for mxODBC you'll find the following note:
The Informix ODBC drivers needed for mxODBC are included in the Informix CSDK. Do you have this installed?– A. Kootstra
Nov 8 at 21:32
On the Robotframework-Database-Library going to the linked A Database API Specification 2.0 Python Module page you'll find Informix under [General Purpose Databases]( wiki.python.org/moin/…). Under the section for mxODBC you'll find the following note:
The Informix ODBC drivers needed for mxODBC are included in the Informix CSDK. Do you have this installed?– A. Kootstra
Nov 8 at 21:32
|
show 1 more comment
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53198535%2finformix-db-with-robotframework%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Have you walked through the installation procedure on the egenix-mxodbc page?
– A. Kootstra
Nov 8 at 19:56
Yes, I have installled egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt, then tried to install egenix-mx-base-3.2.9-py2.7_ucs2-macosx-10.5-x86_64-prebuilt. Tried to verify the mx-base using --> $ pip install egenix-mx-base Requirement already satisfied: egenix-mx-base in /Library/Python/2.7/site-packages. But on trying to verify mxodbc --> does through me error. > ** ImportError: None of the supported ODBC managers unixODBC, iODBC or DataDirect could be imported: dlopen(/usr/local/lib/python2.7/site-packages/mx/ODBC/unixODBC/mxODBC.so, 2): no suitable image found. Did find:**
– MSQA
Nov 8 at 20:42
Can you add the information to the question itself, instead of posting as a comment. This will allows you more formatting options and keeps all your information in one place.
– A. Kootstra
Nov 8 at 20:44
Thank you for the tip. i hope i have made the issue clear
– MSQA
Nov 8 at 21:16
On the Robotframework-Database-Library going to the linked A Database API Specification 2.0 Python Module page you'll find Informix under [General Purpose Databases]( wiki.python.org/moin/…). Under the section for mxODBC you'll find the following note:
The Informix ODBC drivers needed for mxODBC are included in the Informix CSDK.Do you have this installed?– A. Kootstra
Nov 8 at 21:32