3

I have to connect my app to a customer's Informix 7.2 legacy database.

From what I was able to find out, in theory there should be a database service running on port 50000. The problem is that I cannot find any database service in the Operative System.

So far I'm only able to use dbaccess and perform queries from the command line.

I would like to use a database driver (such as http://code.google.com/p/ibm-db/) so my app can connect and query the database using a cursor, but since I cannot find any database service, apparently I can't...

Am I missing something here? Are there options I'm not considering?

Is it possible to have an Informix database in which the only interface is dbaccess?

ivo
  • 4,101
  • 5
  • 33
  • 42
  • Which tool are you using to connect to it? .NET, Java, etc? – KMån May 14 '10 at 10:31
  • I'm using Python, planning to connect with SQLAlchemy with the IBM driver (http://code.google.com/p/ibm-db/) – ivo May 14 '10 at 13:53
  • It seems that this driver works only with newer versions of Informix. – Michał Niklas May 17 '10 at 07:18
  • Do you have Client SDK installed on your machine? What operation system do you use? – Michał Niklas May 17 '10 at 07:23
  • 1
    The python app and the Informix server are on different machines. The python app is running on ubuntu. The Informix server is installed in a different machine (a very old Red Hat distro). I don't have permission to install anything on the Red Hat machine, so I have to connect remotely. – ivo May 17 '10 at 21:18

3 Answers3

2

See connection strings for Informix

KMån
  • 9,896
  • 2
  • 31
  • 41
1

BTW, if you want to connect to a remote legacy Informix database using Python from a Mac, pypyodbc-informixcsdk could be your only (free) choice. Check this wiki.

On a Windows box, pyodbc + Informix Client SDK + ODBC do the job nicely.

Rockallite
  • 16,437
  • 7
  • 54
  • 48
1

If you use Python you can look at: Python wiki but I would like to extend it a little.

If you work on Windows and have Client SDK then there should be ODBC driver installed on your machine. There is also Linux and other unix versions of such client software. If you install that you can use ODBC to connect to database. On Windows you can use Active State Python 2.6 with win32 extensions which has odbc module included. On other Python implementations you can use win32 extensions or other ODBC module such as mxODBC.

I work also with Jython where I use both JDBC and ODBC drivers. You can see this "in action" in my SO questions like: Problem with Informix JDBC Money format

Community
  • 1
  • 1
Michał Niklas
  • 53,067
  • 18
  • 70
  • 114
  • InfomixDB, mentioned in the python wiki, looks good, but I can't get it to install on the python app machine, since I don't have the Informix server there... I need to do something remotely... Haven't tried mxODBC yet... – ivo May 17 '10 at 21:20