Results 1 to 6 of 6

Thread: sql

  1. Jun 11th, 2007, 05:36 PM #1
    doyer
    doyer is offline

    Thread Starter
    New Member
    Join Date
    Jun 2007
    Posts
    12

    sql

    i have vb6. and i learned all i really wanna know about programming sql from http://www.w3schools.com/sql/default.asp . but...i cant figure out hwo im supposed to use it. i wanna use it with vb...but i have no idea where to start, i looked all around for tutorials, but i couldn't find any. please help, thanks
    Reply With Quote Reply With Quote
  2. Jun 12th, 2007, 12:58 AM #2
    Paul M
    Paul M is offline
    Interweb adm/o/distrator Paul M's Avatar
    Join Date
    Nov 2006
    Location
    Australia, Melbourne
    Posts
    2,306

    Re: sql

    There is a mySQL class for Vb6
    Reply With Quote Reply With Quote
  3. Jun 12th, 2007, 01:16 AM #3
    jcis
    jcis is offline
    PowerPoster jcis's Avatar
    Join Date
    Jan 2003
    Location
    Argentina
    Posts
    4,430

    Re: sql

    Which is your backend? MSAccess? MSSQL?
    Start a VB Project, add a reference to ADO (Microsoft Activex Data Objects 2.x), then you need to create a Connection Object, this needs a connection string that depends on your Backend. Search the forum using ADO as keyword.
    Reply With Quote Reply With Quote
  4. Jun 12th, 2007, 03:32 AM #4
    RobCrombie
    RobCrombie is offline
    Fanatic Member
    Join Date
    Mar 2002
    Location
    AUSTRALIA
    Posts
    603

    Re: sql

    There is a feast of examples here -http://www.vb-helper.com/index_database.html#ado

    Do not use -
    VB's Data Control
    Bound controls
    VB's Data View window
    VB's Data Environment
    VB's Data Reports
    VB's Data Grid

    Many of the examples in the link follow those rules.
    Rob C
    Reply With Quote Reply With Quote
  6. Jun 12th, 2007, 06:10 AM #5
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: sql

    Quote Originally Posted by Hell-Lord
    There is a mySQL class for Vb6
    There is?

    Where?
    Reply With Quote Reply With Quote
  7. Jun 12th, 2007, 10:07 AM #6
    Al42
    Al42 is offline
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: sql

    Try Beacon's VB ADO tutorial.
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.
    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.
    Please Help Us To Save Ana
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width