Hi!
I am new to programming with SQL so I really need help on this one. After I finish an application with no errors or bugs, i tried to launch it in different computers. However, most computers encouter SQL errors while loading the application, either a timeout error or the application simply crashes due to the inability to load the data from an SQL database.
My questions are the following:
1. Do you need an SQL server running in the computer where you will deploy the application? Though in some computers, the application worked even though they do not have an SQL Server.
2. Should I modify something in the connection string when I am already deploying the software? Is there a difference in the connection string when the program is running in my computer and in other computers?
My connection string is this:
[color=Blue]"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Integrated Security=True;User Instance=True";[/color]
I tried modifying the timeout but the error still remains.
3. Where could I have missed something?
Sorry if I am missing something trivial here.
Thanks in advance for those who will respond! You'll really be helping me a lot.
Thanx!
Comments
What you want to do is set up an actual SQL server with your database structure in it. Then, yes, you would change your deployed/production connection string to point to it.
So you will want to look up setting up an SQL server (or you might want to switch to MySql since it's free) AND you will want to look up how to connect to that instead of a database file.
If you are having trouble with connection strings at any point a really awesome resource is at www.connectionstrings.com.
However, i think i should have used a local database or an access database from the start for this purpose, but I already finished the application and I used a service-based SQL database. Is there any way to somehow let my database act as a local database and not like a database server? Sorry if my question is vague, or meaningless at worst, I am really new to SQL programming.
Thanx for the help!