Click here to Skip to main content
11,492,907 members (59,259 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL
hi,, please help me am battling with connection string for the sql database file of Vs,2012
the current connection is working on local database server which is :
Data Source=(localdb)\v11.0;AttachDbFilename=|DataDirectory|\Database1.mdf;..

I want to change it to be used remotely, to connect to this database file on different computer via network,, is it possible??
Posted 3-Oct-12 12:04pm
Comments
Wes Aday at 3-Oct-12 17:06pm
   
So change your data source to point to the database server that you want.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

ConnectionStrings.com[^] is a very useful website: add it to your favorites.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

I've tried to change
Data Source=(localdb)\v11.0;AttachDbFilename=|DataDirectory|\Database1.mdf;..

to

Data Source=(192.168.0.11)\v11.0;AttachDbFilename=|DataDirectory|\Database1.mdf;..
and even
Data Source=(192.168.0.11)\(localdb)\v11.0;AttachDbFilename=|DataDirectory|\Database1.mdf;..

but didn't find the server
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

thank you,, it is really nice website..
I think Sql data base file dosn't support remote servers , as far as I see in this website it is only support local files. or I must use SQL server instead of SQL database file
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 419
1 Maciej Los 286
2 F-ES Sitecore 224
3 KarstenK 210
4 CPallini 208
0 Sergey Alexandrovich Kryukov 10,132
1 OriginalGriff 8,630
2 Sascha Lefèvre 3,624
3 Maciej Los 3,392
4 Richard Deeming 2,500


Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 3 Oct 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100