Help: How to use SQL in VB6 to access Informix

Posted in 2000

Chrsitopher Nguyen — Mon, 11 Sep 2000 00:07:05 -0700 — source: Informix-list mailing list archive (1991-1998)

Hi all, I am currently using VB6 with Informix, and use Data Environment to open/connect with that database and would like to know if any of you could advise me how to use SQL command to access its database?...any response to this newsgroup or tp my email would be greatly appreciated. Thanks, -- Trisha Vo, email: cpnguyen@lanset.com

↪ replying to Chrsitopher Nguyen

Bert van den Dongen — Mon, 11 Sep 2000 23:02:17 +0200 — source: Informix-list mailing list archive (1991-1998)

Chrsitopher Nguyen <cpnguyen@lanset.com> schreef in berichtnieuws 39bc8717@monitor.lanset.com... Hi all, I am currently using VB6 with Informix, and use Data Environment to open/connect with that database and would like to know if any of you could advise me how to use SQL command to access its database?...any response to this newsgroup or tp my email would be greatly appreciated. Thanks, -- Trisha Vo, email: cpnguyen@lanset.com Hi Chris I just learned this myself: Suppose: Your DataEnvironment is DE1 Your Connection = CONN1 You can now program: Dim CONN1 As New ADODB.Connection Dim RS as New ADODB.RecordSet Set RS.Execute("Select * From Blablabla etc") CONN1.Close Set RS = Nothing It works for me I lernt it from a Norwegian Pro (named Erling). Bert.