Connecting to informix database

[Former Member]

Is there another way to connect to the informix database with a powerbuilder 12.6 classic app

other than Pbin9120.dll and pbi10120.dll

We currently use these with informix connect.

But, our client is saying the following:

We also have several local applications that make use of direct SQL connections to the ECF database, and those also became slow with centralization.  Over the past couple days I’ve done a lot of application and network traffic profiling to identify the root cause, and came to the conclusion that the Informix connect driver is simply terribly inefficient at TCP communication.

My developer suggested we make use of the more modern IBM driver set known as the “IBM Data Server Client”, and I have implemented it for one of our local apps, which resulted in a 300% speed boost when compared to the Informix Connect driver.  This was a simple configuration change on the Informix server, and a switch in my application from using an Informix ODBC connection to using an OLE DB connection with a connection string specifying the newer driver.

we don't use odbc... .so, I'm confused about that comment.

But, can powerbuilder make use of the "IBM Data server client"?

[Former Member]

I use OLE DB to connect to MS SQL Server and have it coded like this:

sqlca.DBMS    = "OLE DB"

sqlca.LogId   = "<userid>"

sqlca.LogPass = "<password>"

sqlca.DBParm  = "PROVIDER='SQLOLEDB',DATASOURCE='<server>',

PROVIDERSTRING='Database=<database>'"

It should be pretty similar, just change SQLOLEDB to the Informix OLE provider name, server to the server name, and database to the database name.

[Former Member]

Hi Scot;

  I am not an Informix guru by far but the "IBM Data server client" seems to refer to a suite of various connectivity clients that include native, odbc, jdbc, ado.net, etc. It sounds like your coworker just changed the connection type to OLE-DB and that made a huge difference in the aforementioned application.

  Newer versions of PB support the OLE-DB middle-ware connectivity to various DBMS systems. So it should be easy to install the "IBM Data server client" package that includes the OLE-DB driver and then set your PB application driver to use it's OLE-DB driver (which is really just an interface to the real OLE-DB DB Client driver) to enable your PB application to communicate to the Informix DBMS via that mechanism.

Example:

SQLCA.DBMS = "OLE-DB"

SQLCA.DBParm = "PROVIDER='<Informix OLDDB Client>',DATASOURCE='<Informix_DB>"

Regards ... Chris