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
    Location
    Arizona
    Posts
    3

    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
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Hopefully you will find this MSDN Blog helpful.

    http://blogs.msdn.com/sqlexpress/arc...05/415084.aspx
    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

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
 
 
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