DB2 DSN less connection

oracle Pakistan
  • 15 years ago

    i want to connect to DB2 through Visual Basic 6.0 using DSN less connection (OLEDB provider is required). currently i am using DSN based connection which is too slow
    Thanks

  • 15 years ago

    here is how you can do it


    select adodc data control 6.0 from components. put it on the form. then select it to bring its properties. double click custom to show property pages. select use connection string and click build next to it.
    In th provider tab select Microsoft Jet 4.0 OLE DB Provider.
    Click Next
    Now in the connection tab select or enter the database path you want it to connect with. Then click Test Connection to make sure connection to the databse is made.
    Click OK and you're done.


    I hope it will help.

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Better train people and risk they leave – than do nothing and risk they stay.” - Anonymous