Re: Informix and VB 6

The ODBC should work fine, though I've heard the DAO interface both integrates, and offers some OOP API methods that make it more attractive to the programmer. When all is said and done, it'll probably still be using the ODBC interface though.. VB hides the real method of access behind the curtains.. so don't worry about it. As a start though, I'd define a global DSN and work with it through that. "Don't forget" Informix is an "authenticated" database, that means you "must" create a user and password with the IPass program.. and unless you make him an admin/DBA privledge user.. you'll have to precreate the database, even if it has no tables to start, using an admin account, DB Explorer can do this for you... point and clickee.. "then" use SQL to "grant" that user privledges, either individually, or "godhood" over that database, as in: GRANT dba TO mickymouse; All this "security" will be new to you if your a Windows only type of person, its benefit only becomes apparent when you start thinking about someone in India accessing your database without your permission.. then the trouble starts looking really worth it. At 09:35 AM 6/23/00 -0400, you wrote: >I am using the personal edition of Informix and would like to make a music >database program with VB 6 as the front end and informix as the back end. Is >this possible.?? > >If so are there drivers I need for ODBC or is it with a DAO. I currently >have the learning edition of VB6. > >Thanks in advance > > > > =================================================== John Willis Microcomputer support Internet Publishing Technologies Group TXU Communications icq : 47700679 web : www.txucom.com, www.johntwillis.com, www.onslate.com email: jwillis@lcc.net Phone: 409.788.7523 FAX : 409.788.7566 this is my digital finger print: C219 3E66 C570 9CFF B0C4 A947 01C5 A0B3 6173 34B9 ===================================================