Error using Informix OLE DB Provider

Hi Informixers, I'm trying to use the Informix OLE DB Provider from the brand new Client SDK 2.30.TC1-1. Within Visual Basic 6.0, I'm using the "add data link" dialog box. After selecting "Informix OLE DB Provider", I add the connection properties in the "Connection" tab and click the "test connection" button. Then I get the following error (translated from German, since I'm using the German edition of VB6): Microsoft Data Link - Error Testing connection failed. Error initializing Provider. XIX000:-111:ISAM error: no record found. I can connect to the database just fine via the ODBC 3.3 driver, so I assume that SETNET settings are ok. What's going wrong? Regards, Richard -- +--------------------------+------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-6110 | | Klinikum Grosshadern | FAX : +49-89-7095-6420 <-- NEW!!! | | 81366 Munich, Germany | GSM : +49-172-8933578 | +--------------------------+------------------------------------------+

There is SQL script (CLIENTHOME\\etc\\coledbp.sql) you need to run against sysmaster as user informix. Richard Spitz <Richard.Spitz@ana.med.uni-muenchen.de> wrote in message news:377CD58C.E73D149@ana.med.uni-muenchen.de... > Hi Informixers, > > I'm trying to use the Informix OLE DB Provider from the brand new > Client SDK 2.30.TC1-1. Within Visual Basic 6.0, I'm using the "add > data link" dialog box. After selecting "Informix OLE DB Provider", > I add the connection properties in the "Connection" tab and click the > "test connection" button. Then I get the following error (translated > from German, since I'm using the German edition of VB6): > > Microsoft Data Link - Error > > Testing connection failed. Error initializing Provider. > XIX000:-111:ISAM error: no record found. > > I can connect to the database just fine via the ODBC 3.3 driver, so I > assume that SETNET settings are ok. What's going wrong? > > Regards, Richard > -- > +--------------------------+------------------------------------------+ > | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | > | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-6110 | > | Klinikum Grosshadern | FAX : +49-89-7095-6420 <-- NEW!!! | > | 81366 Munich, Germany | GSM : +49-172-8933578 | > +--------------------------+------------------------------------------+