which database is installed on every computer
-
Hello everyone, I've got a little problem. I made a project and it runs well. In the project I access a database, I create table and access them. The database I use is Microsoft SQL Server 2005, the free database from Microsoft. After I installed it, I enter a connectionstring like this: DERESEN\SQLEXPRESS and it will work fine. So I tried it with my friends computer and it didn't work, I had to change the name (DERESEN) in the computer's name, so I did it like this: Environment.MachineName + "\SQLEXPRESS". And it did work. Now the problem: I need to get it work on every (Windows-based) computer, so I let my girlfriend instal it at her computer (a computer no-no should be able to do it), but it didn't work. I let her instal SQL Server 2005 and it didn't work. So now my question: Is there any database which is ALWAYS installed on a windows computer which I can access. Or is there another way (which I didn't see) to get a database running? I hope you can help me, because I've been searching for days for an answer to this problem.
-
Hello everyone, I've got a little problem. I made a project and it runs well. In the project I access a database, I create table and access them. The database I use is Microsoft SQL Server 2005, the free database from Microsoft. After I installed it, I enter a connectionstring like this: DERESEN\SQLEXPRESS and it will work fine. So I tried it with my friends computer and it didn't work, I had to change the name (DERESEN) in the computer's name, so I did it like this: Environment.MachineName + "\SQLEXPRESS". And it did work. Now the problem: I need to get it work on every (Windows-based) computer, so I let my girlfriend instal it at her computer (a computer no-no should be able to do it), but it didn't work. I let her instal SQL Server 2005 and it didn't work. So now my question: Is there any database which is ALWAYS installed on a windows computer which I can access. Or is there another way (which I didn't see) to get a database running? I hope you can help me, because I've been searching for days for an answer to this problem.
Deresen wrote:
Is there any database which is ALWAYS installed on a windows computer which I can access.
No.
Deresen wrote:
Or is there another way (which I didn't see) to get a database running?
You could always use SQL Server Compact Edition[^]. This runs inside the process space of the application (it runs as a DLL) and it's free.
Deja View - the feeling that you've seen this post before.
-
Hello everyone, I've got a little problem. I made a project and it runs well. In the project I access a database, I create table and access them. The database I use is Microsoft SQL Server 2005, the free database from Microsoft. After I installed it, I enter a connectionstring like this: DERESEN\SQLEXPRESS and it will work fine. So I tried it with my friends computer and it didn't work, I had to change the name (DERESEN) in the computer's name, so I did it like this: Environment.MachineName + "\SQLEXPRESS". And it did work. Now the problem: I need to get it work on every (Windows-based) computer, so I let my girlfriend instal it at her computer (a computer no-no should be able to do it), but it didn't work. I let her instal SQL Server 2005 and it didn't work. So now my question: Is there any database which is ALWAYS installed on a windows computer which I can access. Or is there another way (which I didn't see) to get a database running? I hope you can help me, because I've been searching for days for an answer to this problem.
Use
.\SQLEXPRESSor(local)\SQLEXPRESSMore about connection strings[^] And make sure that the database is attached to the server. Sql server (not windows) has its system databases that you should not manipulate.Eslam Afifi
modified on Thursday, September 11, 2008 8:17 PM
-
Hello everyone, I've got a little problem. I made a project and it runs well. In the project I access a database, I create table and access them. The database I use is Microsoft SQL Server 2005, the free database from Microsoft. After I installed it, I enter a connectionstring like this: DERESEN\SQLEXPRESS and it will work fine. So I tried it with my friends computer and it didn't work, I had to change the name (DERESEN) in the computer's name, so I did it like this: Environment.MachineName + "\SQLEXPRESS". And it did work. Now the problem: I need to get it work on every (Windows-based) computer, so I let my girlfriend instal it at her computer (a computer no-no should be able to do it), but it didn't work. I let her instal SQL Server 2005 and it didn't work. So now my question: Is there any database which is ALWAYS installed on a windows computer which I can access. Or is there another way (which I didn't see) to get a database running? I hope you can help me, because I've been searching for days for an answer to this problem.
Deresen wrote:
Is there any database which is ALWAYS installed on a windows computer which I can access
No.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
-
Use
.\SQLEXPRESSor(local)\SQLEXPRESSMore about connection strings[^] And make sure that the database is attached to the server. Sql server (not windows) has its system databases that you should not manipulate.Eslam Afifi
modified on Thursday, September 11, 2008 8:17 PM
Eslam is correct, but SQL Server has to be installed with the "default instance" to be able to do that. If someone installs it using a "named instance" and calls it something else, it won't work.
-
Hello everyone, I've got a little problem. I made a project and it runs well. In the project I access a database, I create table and access them. The database I use is Microsoft SQL Server 2005, the free database from Microsoft. After I installed it, I enter a connectionstring like this: DERESEN\SQLEXPRESS and it will work fine. So I tried it with my friends computer and it didn't work, I had to change the name (DERESEN) in the computer's name, so I did it like this: Environment.MachineName + "\SQLEXPRESS". And it did work. Now the problem: I need to get it work on every (Windows-based) computer, so I let my girlfriend instal it at her computer (a computer no-no should be able to do it), but it didn't work. I let her instal SQL Server 2005 and it didn't work. So now my question: Is there any database which is ALWAYS installed on a windows computer which I can access. Or is there another way (which I didn't see) to get a database running? I hope you can help me, because I've been searching for days for an answer to this problem.
You can use SQLite[^] for your purposes. It's just a single file database. There is also ado.net managed provider for it: System.Data.SQLite[^]
Giorgi Dalakishvili #region signature my articles #endregion