Visual Basic&database, Visual Basic and Informix

Visual Basic and Informix

Author	Message
Mel Haynes J #1 / 5	Visual Basic and Informix We are desperately wanting to move from PowerBuilder to Visual Basic, but have only one problem: We need to be able to connect to Informix with something faster than an ODBC connection. Unless there are some ODBC drivers for Informix that actually work well with large amounts of data, we would need some OCX or native drivers that can connect to Informix. If there is anyone out there that has any ideas, I would greatly appreciate it. Thanks -- Mel Haynes Jr Software Developer Phoenix Retail Systems 1785A South 8th St Colorado Springs, Co 80906 www.apisys.com
Fri, 29 Oct 1999 03:00:00 GMT

Juan José Herrer #2 / 5	Visual Basic and Informix Quote: > We are desperately wanting to move from PowerBuilder to Visual Basic, but > have only one problem: We need to be able to connect to Informix with > something faster than an ODBC connection. Unless there are some ODBC > drivers for Informix that actually work well with large amounts of data, we > would need some OCX or native drivers that can connect to Informix. If > there is anyone out there that has any ideas, I would greatly appreciate > it. Thanks > -- > Mel Haynes Jr > Software Developer > Phoenix Retail Systems > 1785A South 8th St > Colorado Springs, Co 80906 > www.apisys.com We have a Database in Informix 5.0 SE like server and the client aplicattion works in New Era 2.0 (From Informix). New Era comes with an ODBC but i have a lot of problems with its ODBC. i Tried with a new ODBC from Q+E and it works well. I found this ODBC fast enough, but this is an aprreciation because i use it in ACCESS 2.0 to made reports and queries. Jon Herrero Spain
Sat, 30 Oct 1999 03:00:00 GMT

Kevin Howar #3 / 5	Visual Basic and Informix Quote: >> We are desperately wanting to move from PowerBuilder to Visual Basic, but >> have only one problem: We need to be able to connect to Informix with >> something faster than an ODBC connection. Unless there are some ODBC >> drivers for Informix that actually work well with large amounts of data, we >> would need some OCX or native drivers that can connect to Informix. If >> there is anyone out there that has any ideas, I would greatly appreciate >> it. Thanks We're in the same boat. We haven't gone far enough to see any speed problems yet, but thanks for the warning, I'll keep an eye out. I suspect we might see a problem there. We have a fairly large database with client worstations spread across most of the Eastern US. One of the laments I have (cause I like to complain) is the difficulty in taking advantage of ODBC to Informix and yet maintaining the integrety of an object oriented design in VB. Since Classes in VB4.0 can't inherit properties, I am stuck with making everything public. And what's worse, it seems that ODBC by nature, isn't set up for OOP -- especially when it comes to having common routines to backout any open transactions in case of an error. Not really anything directly relating to the topic, but I just wanted to complain. I can't really recommend our drivers. I suspect they are not as stable as advertised and have the habit of creating GPF's anytime they encounter a problem. This has created problems for me, since (again) one object may not know what the other is doing. Thanks again for these concerns! I'm sure I will be fighting with them! :-\
Tue, 02 Nov 1999 03:00:00 GMT

William Harr #4 / 5	Visual Basic and Informix Quote: >We are desperately wanting to move from PowerBuilder to Visual Basic, but >have only one problem: We need to be able to connect to Informix with >something faster than an ODBC connection. Unless there are some ODBC >drivers for Informix that actually work well with large amounts of data, we >would need some OCX or native drivers that can connect to Informix. If >there is anyone out there that has any ideas, I would greatly appreciate >it. Thanks I know of no such OCX system; knowing Informix, if there -is- anything available, you'd probably be better off with an ODBC driver. (Informix has decent database products, but they are utterly without a clue on desktop products - see their New Era development environment.) Given Visual Basic, bending over backward to avoid ODBC is likely to be a time-consuming futile quest. Try Openlink's drivers; it's unlikely you'll find anything faster. With that said, keep in mind a couple more things: Visual Basic going through the Jet engine to an ODBC driver to Informix is not going to be a speed demon. For better efficiency, use passthrough mode (avoids for the most part the Jet engine) - for maximum efficiency, use direct ODBC calls. Yes, this makes database programming in VB more difficult - you lose most of the built-in database support - but this certainly won't make it any more difficult than the OCX monstrosity you seem to be contemplating. :-) --
Tue, 02 Nov 1999 03:00:00 GMT

Page 1 of 1

[ 5 post ]