CODEWITHSUNDEEP
mysqlsqlparametersvb6call
scarface23
scarface23

Reputation: 282

parameter or call from vb6 to sql code

I am about to make a system using VB6. My instructor told me that I should use a parameter or a call from SQL code because we need to focus on sql. My question is how to do this? I know about ADO ,RDO, etc ... but i'm having a hard time looking for something like this. Any advise or clue on how to do this? Your help will be highly appreciated.

Upvotes: 1

Views: 335

Answers (1)

aksappy
aksappy

Reputation: 3400

You need to have the right driver which goes well with your database installed/available first. This would then be avialable in the References dialog box.

For ADO, set a reference to the appropriate ADO type library. There are two ADO type libraries. One is called ADODB and is contained in MSADO15.DLL. The other is called ADOR and is contained in MSADOR15.DLL.

ADODB is the larger and more feature-rich of the two. It contains the main ADO objects and is the one you'll probably want to use mostly. The second is a "lightweight" subset of the ADODB type library that supports only recordsets. You can use if your operations are limited to recordsets.

A good set of examples are found in this link

Upvotes: 1

Related Questions