Click here to Skip to main content
15,885,278 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Regarding to build a directory browser to get database path and past the path to sqlconnectionstring("C://")

hi Pros and Shifus out there,

i got 2 or 3 same self written window form applications using vb.net, running in different pc(s) but i want them to be able to connect to the same path, same database in a specified pc. and of course all the pc(s) are routed and sharing partitions.

so... pros and shifus any idea on how to start this?
Posted

1 solution

Instead of doing it with network resource sharing, just enter the IP-address of the machine running the SQL Server in the connection string (I chose 197.0.0.1 as an example here):

C#
connectionString = "Data Source=197.0.0.1;Initial Catalog=MyDatabaseName;User Id=MyUserName;Password=MyPassword;"
 
Share this answer
 
v2
Comments
donaldliaw87 28-Aug-13 20:33pm    
Hi Johnny J,

i was appreciate your given solution!!! you were good in sql server rite? may i ask a small help form you?

>i had installed sql server but how to host my application's database?, so my other computer able to access! i have no idea on this!

> any guides or links can recommend?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900