Visual studio connecting to sql server managment

Question

Visual studio connecting to sql server managment

behzad gerami 1

Hi,
My .net form and VS software work when I start it in visual studio debug and send data to SQL server management 2014 that I have table but if I use Extension in Vs and create windows installer project to make application for my code then it will stop connection to Microsoft Sql server mangment.
I have couple class that make connection to Sql.
this is my code in side class that make connetion to Sql server management.
then on main I have couple obj for each class.
String connectionString = "Data Source=" + DB_Path + "; Initial Catalog=Chillar;Integrated Security=True;TrustServerCertificate=True";
try
{
string sqlQuery = "INSERT INTO SCADA_"+Station+"_CH1 (SupplyTemp)value(@SupplyTemp)

            SqlConnection con = new SqlConnection(connectionString);  
            con.Open();  
            SqlCommand cmd = new SqlCommand(sqlQuery, con);

How can fix this
I even change my SQL to TCP/IP but didnt work.
all connection is correct and when I run test connection it said connection is succesful but the application doesnt work.

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2022-12-19T22:06:27.55+00:00

but the application doesnt work.

Which means what? Do you get an error message? Do you get unexpected results?

The one thing I can see from your code snippet is that you don't define the parameter @SupplyTemp. And for that matter, you are not executing the query. But I don't know if the above is the full code.

1 answer

Your answer

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2022-12-19T22:06:27.55+00:00

but the application doesnt work.

Which means what? Do you get an error message? Do you get unexpected results?

The one thing I can see from your code snippet is that you don't define the parameter @SupplyTemp. And for that matter, you are not executing the query. But I don't know if the above is the full code.

Answer 1

Bjoern Peters 8,921

Hi @behzad gerami

for me it sounds like your are using SQL LocalDB and not a real SQL Server... maybe LocalDB shuts down during Built-process

And only to make sure... your app is not connecting to the Management Studio (you'd called it SQL Server Management 2014)... normally, Visual studio brings a version of LocalDB and that one only runs if VSStudio is started... (afaik)

Maybe you try to install a SQL Server Express edition on your machine and migrate all structures/data to that db-engine... then it should also work with TCP and remotely.

I hope my answer is helpful to you,

Your
Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

behzad gerami 1 Reputation point

2022-12-20T00:05:34.033+00:00

Hi, You right! I have SQL as local DB At moment and its install in my computer. "microsoft sql server mangement studio".
My problem is after make application with setup file it stop connection with sql this is picture of part of my code make connection to sql but it work when i open mu VS and run the program by itself.
behzad gerami 1 Reputation point

2022-12-20T00:09:20.72+00:00

the data transfer from Main to class
class has server path to sql coneection and open connection
the path and parameter value pass thru obj to class
server path is setup inside .net as text box ,just in case the server name changes in future.
Jack J Jun 25,296 Reputation points

2022-12-20T06:38:28.93+00:00

@behzad gerami , Welcome to Microsoft Q&A, I guess that your connection string may be changed when you run it in the setup project. I recommend that you could add MessageBox.Show(connectionstring);
to check if the connection string is different from your initial connection string.
behzad gerami 1 Reputation point

2022-12-20T18:42:38.427+00:00

I did looks good same path as I expected and match with sql Local sign in name
Jack J Jun 25,296 Reputation points

2022-12-21T07:08:36.497+00:00

@behzad gerami , thanks for the feedback, If so, I recommend that you use SQL Server Profiler to check what happened when use the connection string in the setup project.

Share via

Visual studio connecting to sql server managment

1 answer

Your answer