HomeFlySpeed SQL QueryConnect to informix-db

Connect to informix-db


Hello,

is it possible to connect with FlySpeed SQL Query to a IBM Informix database?
Steffen | email
February 15 2008, 03:00 AM
Dear Steffen,

The current version allows you to connect to Informix via generic ADO connection, OLE DB Provider for ODBC and Informix ODBC driver. The next minor version will be able to connect to databases directly via ODBC, so it will be more optimal to work with Informix and DB2 databases. But the syntax rules of Informix DS are already present in the current version, so I believe you may start working with Informix right now. To do that, select create a new connection and select the "Other (ADO Connection)" item from the list of database servers. On the next step, use the connection string and select the "Microsoft OLE DB Provider for ODBC Drivers", click "Next" and select your Informix ODBC data source. Don't forget to specify Informix in the "Use SQL dialect" combo box and define your Informix server version.

Sincerely
Sergey Smagin
Sergey Smagin | email
2 days, 1 hour since original post
This topic is closed