Re: Connecting via VB6
Good point, it's: Microsoft OLE DB Provider for ODBC Drivers Thanks! Steve Leopold The Cat <leopold_the_cat@yahoo.com> wrote in message news:89jrmh$9v61@webint.na.informix.com... > The answer would depend on what is your provider. You could be using > Informix OLEDB, MS OLEDB -> Informix ODBC, Merant OLEDB or something else. > > Leopold > > Steve Schroeder <sschroeder@merchant-gould.com> wrote in message > news:dzbv4.2722$%A3.64125@ptah.visi.com... > > Despite being able to connect to informix via various other tool, i.e. > > Access 97, 2000, WinSQL to name a few, VB6 with 2.1 MDAC and SP3 refuses > to > > connect. Here is the error message I get: > > > > Test connection failed becuase of an error initializing provider. > > Catastrophic failure. > > > > Does anyone, anyone has an idea how I can solve this? I searched the > > knowledge base without any success. "Catastrophic" does not return any > > results, among other attempts. > > > > > > > > > >
Steve, Sorry, do not know much about that. I only know (a little) about Informix OLEDB. Maybe some Informix ODBC people are listening. Leopold Steve Schroeder <sschroeder@merchant-gould.com> wrote in message news:8egv4.2803$%A3.65102@ptah.visi.com... > Good point, it's: Microsoft OLE DB Provider for ODBC Drivers > > Thanks! > > Steve > > Leopold The Cat <leopold_the_cat@yahoo.com> wrote in message > news:89jrmh$9v61@webint.na.informix.com... > > The answer would depend on what is your provider. You could be using > > Informix OLEDB, MS OLEDB -> Informix ODBC, Merant OLEDB or something else. > > > > Leopold > > > > Steve Schroeder <sschroeder@merchant-gould.com> wrote in message > > news:dzbv4.2722$%A3.64125@ptah.visi.com... > > > Despite being able to connect to informix via various other tool, i.e. > > > Access 97, 2000, WinSQL to name a few, VB6 with 2.1 MDAC and SP3 refuses > > to > > > connect. Here is the error message I get: > > > > > > Test connection failed becuase of an error initializing provider. > > > Catastrophic failure. > > > > > > Does anyone, anyone has an idea how I can solve this? I searched the > > > knowledge base without any success. "Catastrophic" does not return any > > > results, among other attempts. > > > > > > > > > > > > > > > > > >
The answer was to install the client sdk for NT or the latest ODBC drivers 3.31. Leopold The Cat <leopold_the_cat@yahoo.com> wrote in message news:89k5as$e1l1@webint.na.informix.com... > Steve, > > Sorry, do not know much about that. I only know (a little) about Informix > OLEDB. Maybe some Informix ODBC people are listening. > > Leopold > > Steve Schroeder <sschroeder@merchant-gould.com> wrote in message > news:8egv4.2803$%A3.65102@ptah.visi.com... > > Good point, it's: Microsoft OLE DB Provider for ODBC Drivers > > > > Thanks! > > > > Steve > > > > Leopold The Cat <leopold_the_cat@yahoo.com> wrote in message > > news:89jrmh$9v61@webint.na.informix.com... > > > The answer would depend on what is your provider. You could be using > > > Informix OLEDB, MS OLEDB -> Informix ODBC, Merant OLEDB or something > else. > > > > > > Leopold > > > > > > Steve Schroeder <sschroeder@merchant-gould.com> wrote in message > > > news:dzbv4.2722$%A3.64125@ptah.visi.com... > > > > Despite being able to connect to informix via various other tool, i.e. > > > > Access 97, 2000, WinSQL to name a few, VB6 with 2.1 MDAC and SP3 > refuses > > > to > > > > connect. Here is the error message I get: > > > > > > > > Test connection failed becuase of an error initializing provider. > > > > Catastrophic failure. > > > > > > > > Does anyone, anyone has an idea how I can solve this? I searched the > > > > knowledge base without any success. "Catastrophic" does not return any > > > > results, among other attempts. > > > > > > > > > > > > > > > > > > > > > > > > > > > >