#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    Gold Coast, Australia
    Posts
    1
    Rep Power
    0

    connecting to sql server using visual basic


    I am a recent graduate with a trial for a new job tomorrow, and need some guidance/help/code/examples to successfully connect to a sql server from visual basic 6.0. I have no trouble connecting to Access but no such luck with sql server.

    Need hhheeellllppppp !!!!!!



    P.S. Would also appreciate an example to access the data in a table once connected.

    Thanks heaps.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    DataConnection = "Provider=SQLOLEDB.1;Initial Catalog=;Data Source=;UID=;PWD=;Connect Timeout=15"
    ...
    El éxito consiste en una serie de pequeñas victorias día a día

    MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    5
    Rep Power
    0
    Here is good site for developer. http://www.codeproject.com/
    you can go find what you want. Don't be nervous, take it easy.
    Hope it helps.

    Jim

IMN logo majestic logo threadwatch logo seochat tools logo