Connecting VB wht Informix.
I'm not sure what ODBC driver you are trying to use but I recently tried upgrading from the Intersolv 3.11 to the Informix 3.32. After exhaustive testing, decided to stay with Intersolv. It has a few problems, but nothing compared to the Informix one. The Apps I support are written in VB6 and utilize ADO. I originally tried the Informix 3.31 driver but couldn't execute stored procedures that did have any parameters passed in. I found a "work around" that did work with 3.32 but then errors showed up in other areas. Hopefully Informix will get the driver straightened out and actually usable. Until then, it's Intersolv for me. HTH Scott In article <8u5eom$em5$1@news.xmission.com>, "Neil Miranda" <nmiranda@afl.co.in> wrote: > > This is a multi-part message in MIME format. > > ------=_NextPart_000_002A_01C047DC.DDF6F360 > Content-Transfer-Encoding: quoted-printable > Content-Type: text/plain; > charset="Windows-1252" > > Query: > > "We are trying to connect Informix with VB 6.0 as front end. We have = > tried using ADODB object, but it gives error as provider not found and = > also through ODBC route using Informix ODBC drivers, but again the same = > error. Is there any solution ??? > > Now, we are trying to connect through MS Access, using link ODBC table, = > which allows to link Infomix, but when we try to access it through VB = > 6.0, it allows access to only one table at a time.=20 > Can we access multiple tables at a time as we wish to create joins from = > few related tables using this method. > > Any other method or suggestion is welcome. > > Thanks."=20 > > ------=_NextPart_000_002A_01C047DC.DDF6F360 > Content-Transfer-Encoding: quoted-printable > Content-Type: text/html; > charset="Windows-1252" > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META content=3D"text/html; charset=3Dwindows-1252" = > http-equiv=3DContent-Type> > <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=3D#ffffff> > <DIV><FONT size=3D2> > <P>Query:<BR><BR>"We are trying to connect Informix with VB 6.0 as front = > end. We=20 > have tried using ADODB object, but it gives error as provider not found = > and also=20 > through ODBC route using Informix ODBC drivers, but again the same = > error. Is=20 > there any solution ???<BR><BR>Now, we are trying to connect through MS = > Access,=20 > using link ODBC table, which allows to link Infomix, but when we try to = > access=20 > it through VB 6.0, it allows access to only one table at a time. <BR>Can = > we=20 > access multiple tables at a time as we wish to create joins from few = > related=20 > tables using this method.<BR><BR>Any other method or suggestion is=20 > welcome.<BR><BR>Thanks." <BR><BR></P></FONT></DIV></BODY></HTML> > > ------=_NextPart_000_002A_01C047DC.DDF6F360-- > > Sent via Deja.com http://www.deja.com/ Before you buy.
This is a multi-part message in MIME format. ------=_NextPart_000_002A_01C047DC.DDF6F360 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="Windows-1252" Query: "We are trying to connect Informix with VB 6.0 as front end. We have = tried using ADODB object, but it gives error as provider not found and = also through ODBC route using Informix ODBC drivers, but again the same = error. Is there any solution ??? Now, we are trying to connect through MS Access, using link ODBC table, = which allows to link Infomix, but when we try to access it through VB = 6.0, it allows access to only one table at a time.=20 Can we access multiple tables at a time as we wish to create joins from = few related tables using this method. Any other method or suggestion is welcome. Thanks."=20 ------=_NextPart_000_002A_01C047DC.DDF6F360 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="Windows-1252" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Dwindows-1252" = http-equiv=3DContent-Type> <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2> <P>Query:<BR><BR>"We are trying to connect Informix with VB 6.0 as front = end. We=20 have tried using ADODB object, but it gives error as provider not found = and also=20 through ODBC route using Informix ODBC drivers, but again the same = error. Is=20 there any solution ???<BR><BR>Now, we are trying to connect through MS = Access,=20 using link ODBC table, which allows to link Infomix, but when we try to = access=20 it through VB 6.0, it allows access to only one table at a time. <BR>Can = we=20 access multiple tables at a time as we wish to create joins from few = related=20 tables using this method.<BR><BR>Any other method or suggestion is=20 welcome.<BR><BR>Thanks." <BR><BR></P></FONT></DIV></BODY></HTML> ------=_NextPart_000_002A_01C047DC.DDF6F360--
We use VB6 with Informix. Here's an example of making a connection with ADO, using the MS OLEDB Provider for ODBC and the Informix ODBC driver from the Client-SDK. Setup "yourdsnname" in Control Panel using the Informix 32-bit ODBC driver: Public gadoConnMain As ADODB.Connection Set gadoConnMain = New ADODB.Connection With gadoConnMain .ConnectionString = "Provider=MSDASQL;DSN=yourdsnname;" & _ "User ID=yourlogin;Password=yourpwd;" .ConnectionTimeout = 5 .CursorLocation = adUseClient .Open .Errors.Clear End With "Neil Miranda" <nmiranda@afl.co.in> wrote in message news:8u5eom$em5$1@news.xmission.com... > > This is a multi-part message in MIME format. > > ------=_NextPart_000_002A_01C047DC.DDF6F360 > Content-Transfer-Encoding: quoted-printable > Content-Type: text/plain; > charset="Windows-1252" > > Query: > > "We are trying to connect Informix with VB 6.0 as front end. We have = > tried using ADODB object, but it gives error as provider not found and = > also through ODBC route using Informix ODBC drivers, but again the same = > error. Is there any solution ??? > > Now, we are trying to connect through MS Access, using link ODBC table, = > which allows to link Infomix, but when we try to access it through VB = > 6.0, it allows access to only one table at a time.=20 > Can we access multiple tables at a time as we wish to create joins from = > few related tables using this method. > > Any other method or suggestion is welcome. > > Thanks."=20 > > > > > ------=_NextPart_000_002A_01C047DC.DDF6F360 > Content-Transfer-Encoding: quoted-printable > Content-Type: text/html; > charset="Windows-1252" > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META content=3D"text/html; charset=3Dwindows-1252" = > http-equiv=3DContent-Type> > <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=3D#ffffff> > <DIV><FONT size=3D2> > <P>Query:<BR><BR>"We are trying to connect Informix with VB 6.0 as front = > end. We=20 > have tried using ADODB object, but it gives error as provider not found = > and also=20 > through ODBC route using Informix ODBC drivers, but again the same = > error. Is=20 > there any solution ???<BR><BR>Now, we are trying to connect through MS = > Access,=20 > using link ODBC table, which allows to link Infomix, but when we try to = > access=20 > it through VB 6.0, it allows access to only one table at a time. <BR>Can = > we=20 > access multiple tables at a time as we wish to create joins from few = > related=20 > tables using this method.<BR><BR>Any other method or suggestion is=20 > welcome.<BR><BR>Thanks." <BR><BR></P></FONT></DIV></BODY></HTML> > > ------=_NextPart_000_002A_01C047DC.DDF6F360-- >