connection from microsoft sql to visual basic 2005


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 9 of 9

Thread: connection from microsoft sql to visual basic 2005

  1. #1
    Join Date
    Jun 2007
    Posts
    13

    connection from microsoft sql to visual basic 2005

    Hi to all! i'm a newbie here, i've created a GUI in Visual Basic 2005 and i used MS SQL's query analyzer to create a database, is there any way for me to connect the GUI to my SQL database but my saved file is .sql? hmm,

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Yes, you can connect your GUI to your SQL database. I don't understand what you mean, however, by "my saved file is .sql." Can you be more specific about what you want to accomplish?
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    .sql is typically what the file extension is when a query from Query Analyser is saved as a text file. Is that what you are referring to badrat?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  4. #4
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Also, are you familiar with the SQLConnection Class in VB.NET?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  5. #5
    Join Date
    Jun 2007
    Posts
    13
    yah, it is what i'm exactly asking, so .sql is the text file or the query that i did in the query analyser, so means to say that where can you find the database? to link from the GUI? i'm using Visual Basic 2005.

  6. #6
    Join Date
    Jun 2007
    Posts
    13
    Quote Originally Posted by Hack
    Also, are you familiar with the SQLConnection Class in VB.NET?
    i'm not too sure with using sqlconnection class in VB.NET

  7. #7
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Quote Originally Posted by badrat
    yah, it is what i'm exactly asking, so .sql is the text file or the query that i did in the query analyser, so means to say that where can you find the database? to link from the GUI? i'm using Visual Basic 2005.
    Typically an SQL Server database is stored on a network file server or web server.

    In order to access it your code has to programmatically connect to it. That is where the SQLConnection class comes in handy.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  8. #8
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Quote Originally Posted by badrat
    i'm not too sure with using sqlconnection class in VB.NET
    Are you saying you do know what it is but you just don't know how to use it?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  9. #9
    Join Date
    Jun 2007
    Posts
    13
    Quote Originally Posted by Hack
    Are you saying you do know what it is but you just don't know how to use it?
    yup, i'm so lost right now, i had my tables in my visual project but i don't know how to link the data over at my table or specifically in putting what codes at the tables source codes.

Similar Threads

  1. find version & service packs
    By rperez in forum Database
    Replies: 5
    Last Post: 01-02-2009, 04:14 PM
  2. how to create sql database in visual basic
    By luca90 in forum Database
    Replies: 3
    Last Post: 01-12-2007, 03:25 AM
  3. ANN: SQL Tools V2.00 for Visual Basic
    By Eric Pearson in forum vb.announcements
    Replies: 0
    Last Post: 10-17-2001, 09:45 AM
  4. Ado Connection
    By Sok Y. Kim in forum VB Classic
    Replies: 4
    Last Post: 10-29-2000, 11:54 PM
  5. Re: Visual Basic & SQL server 7
    By Weilu Shi in forum VB Classic
    Replies: 0
    Last Post: 07-12-2000, 10:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center