local database connection string
-
Hello everyone, I'm working with a database. Currently I am using the "Microsoft SQL Server 2005". But I would like to work with a database which is inside Visual studio. So I thought about using the "Local Database". In my solution I added a new item called "Local Database". I created a new table and tried to connect with it in the same way as I used with the SQL server, but it didn't work. I use this connectionstring with the SQL server: connectionString = "server=DERESEN\\SQLEXPRESS;Trusted_Connection=yes;database=master;" And I use this connection string for the local database: connectionString3 = "server=Datatbase.sdf;Trusted_Connection=yes;" The list in SQL server looks like this: DERESEN\SQLEXPRESS -> Databases -> System Databases -> master -> Tables -> myTable The list in server Explorer looks like this: Data Connections -> Database.sdf -> Tables -> myTable Does anyone know how to get this working? I cannot find it anywhere on internet.
-
Hello everyone, I'm working with a database. Currently I am using the "Microsoft SQL Server 2005". But I would like to work with a database which is inside Visual studio. So I thought about using the "Local Database". In my solution I added a new item called "Local Database". I created a new table and tried to connect with it in the same way as I used with the SQL server, but it didn't work. I use this connectionstring with the SQL server: connectionString = "server=DERESEN\\SQLEXPRESS;Trusted_Connection=yes;database=master;" And I use this connection string for the local database: connectionString3 = "server=Datatbase.sdf;Trusted_Connection=yes;" The list in SQL server looks like this: DERESEN\SQLEXPRESS -> Databases -> System Databases -> master -> Tables -> myTable The list in server Explorer looks like this: Data Connections -> Database.sdf -> Tables -> myTable Does anyone know how to get this working? I cannot find it anywhere on internet.
-
Connections to SQL Server don't work like that. Have a look at http://www.connectionstrings.com/[^]
Bob Ashfield Consultants Ltd
-
Well, I can allready connect to a database. But do you know how to use the Local Database which is embedded in visual studio?
-
AFAIK there is no database embedded within Visual studio - unless you are talking about datasets?
Bob Ashfield Consultants Ltd
Well I really am talking about a database. When you go to your project and add an item, there is also an item called "local database". This is the database I am talking about. I've never heard of dataset's though, does this has to do something with databases too?
-
Well I really am talking about a database. When you go to your project and add an item, there is also an item called "local database". This is the database I am talking about. I've never heard of dataset's though, does this has to do something with databases too?
The thing you are referring to is 'An empty SQL Server Compact Edition database for local data' So presumably you need to look at connection strings for that, but its not embedded within your app. Datasets are collections of datatables. Try Google.
Bob Ashfield Consultants Ltd