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.
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
By riyaz in forum Database
Last Post: 08-21-2007, 12:07 PM
By sitoramos in forum Database
Last Post: 11-29-2005, 07:38 AM
By Geno in forum Database
Last Post: 07-07-2005, 02:22 PM
By David Croft in forum Database
Last Post: 08-13-2003, 12:45 PM
By Frustrated IT Worker in forum VB Classic
Last Post: 03-07-2001, 04:28 AM
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center