Results 1 to 2 of 2

Thread: how to connect??

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2005
    Posts
    9

    how to connect??

    I've a question.
    I have MS server 2005 running with a self created database cold OEE.
    How can i make a vb6 code that show me what tables i have, and put for example a new row into it.
    I have no idea how to put a new colum into it.

    Please need some help , i'm just a noob with sql programming.

  2. #2
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,692

    Re: how to connect??

    Can you connect to it with a standard connection string? If so, try this program at PlanetSourceCode. It uses ADOX to read a database and there's code in there for creating columns. (It actually generates VB6 code to recreate an existing database.) Adding rows is a SQL "Insert" statement.

Posting Permissions

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



Click Here to Expand Forum to Full Width