VB2005Express with Microsoft SQL Express (how to connect remotely)

DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: VB2005Express with Microsoft SQL Express (how to connect remotely)

  1. #1
    Join Date
    Feb 2008

    Post VB2005Express with Microsoft SQL Express (how to connect remotely)

    I've read the articles that I could find here and elsewhere on the web and still having a hard time finding answers on connecting remotely. I'm reading that Express cannot connect remotely and then reading that it can, etc etc.

    We have a client / server network at our office. (5 computers, 1 server) All XP Pro sp2 (yeah i know)

    I have Microsoft Visual Basic 2005 Express Edition installed on a client computer for programming, and then the sql server express installed on the server computer.

    From reading the other articles, I have the firewall set and sharing (along with the sql browser setup right.

    Problem is figuring out the visual basic part. I want to know.

    (1) How do I use the database explorer/data connections to add the remote database to my project so I can see it listed on the left column window for drag/drop needs into the project

    (2) If this is possible, then do I select 'data connections' then 'add connection' then in the choose data source window to find the remote sql server?? Because that area only links to 2 files (access or sql database file).

    (3) is there anyway to change the ".\SQLEXPRESS" link in the 'data source' window of #2 above?? Is it changeable from that window or is there another way I'm suppose to do this? reason asking, I can't change it from that window. it doesn't let me type anything there.

    Hopefully this isn't too confusing and someone has heard of a solution. Thanks for any help.

  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    Hopefully you will find this MSDN Blog helpful.


Similar Threads

  1. Replies: 2
    Last Post: 08-21-2007, 12:07 PM
  2. Problems to connect to SQL Server2000
    By sitoramos in forum Database
    Replies: 3
    Last Post: 11-29-2005, 07:38 AM
  3. Encryption & SQL Server 2005 Express
    By Geno in forum Database
    Replies: 0
    Last Post: 07-07-2005, 02:22 PM
  4. SQL Connectivity with Linked MS Access DB
    By David Croft in forum Database
    Replies: 0
    Last Post: 08-13-2003, 12:45 PM
  5. Microsoft Squashes SQL Benchmarks
    By Frustrated IT Worker in forum VB Classic
    Replies: 0
    Last Post: 03-07-2001, 04:28 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
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

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