DB2 & Visual Basic Programming

[Sankaranaryanan]

Hello & Hi,

I would like to know whether Visual Basic 6.0 can be connected to the DB2
and do the programming part. If so, pls let me know how it is and give an
example. I have the DB2 version 6.1 and having a database called SAMPLE.



Thnx & Regards,
Sankar

[Greg Nash]

Hi,

Visual Basic can access DB2 (and almost any other database) by a number
of means.

There should be some sample VB code somewhere in your DB2 install. Find
where DB2 was installed (e.g. c:\sqllib, or c:\program files\sqllib) and
browse through the sample folder (e.g. c:\program files\sqllib\samples)
- there should be some VB there somewhere. It's definitely there in DB2
v7 and v8.

Or, set up an ODBC connection for your database, then look for VB
information on ADO to use ODBC.

Regards,
Greg

Sankaranaryanan wrote:
> Hello & Hi,
>
> I would like to know whether Visual Basic 6.0 can be connected to the DB2
> and do the programming part. If so, pls let me know how it is and give an
> example. I have the DB2 version 6.1 and having a database called SAMPLE.
>
>
>
> Thnx & Regards,
> Sankar
>

[akirekab]

"Sankaranaryanan" <sankaranarayanan@express2.indexp.co.in> wrote:
>
>Hello & Hi,
>
>I would like to know whether Visual Basic 6.0 can be connected to the DB2
>and do the programming part. If so, pls let me know how it is and give an
>example. I have the DB2 version 6.1 and having a database called SAMPLE.
>
>
>
>Thnx & Regards,
>Sankar
>.....I use and enterprise VB6 APP and communicate with DB2 re Stored Procedures.
DB2 Can be manipulated with Stored procedures of several different types.
It is not necessarily intuitive, but you can utilize the large database
in this way. Ken