Setup file for my vb.net project with a SQL Server!

Question

Setup file for my vb.net project with a SQL Server!

Tadele Yigrem 21

I have built a small VB project(Vb.Net 2019) with a SQL server integrated. I created a setup package and install that to another PC and so far so good. But, when I try to open the installed app, it gives no response. Please, I really need to fix this!

Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff

2022-04-22T08:46:18.243+00:00

Hi @Tadele Yigrem ,

I have built a small VB project(Vb.Net 2019) with a SQL server integrated.

Could you please provide more information about your project and Integrate sql server in the project?
Tadele Yigrem 21 Reputation points

2022-04-22T11:32:53.877+00:00

Of course! The project only includes one form (Form1), which contains a PDF viewer (Adobe Acrobat PDF reader component) and a text box (TextBox1). Then I changed TextBox1's DataBindings attribute to a SQL server table that stores a PDF file location. And I write code on the Form1 load event so that the PDF viewer will use TextBox1.Text as the source and show the PDF file. Because it is a simple project, it has no bugs; that is, it runs flawlessly on the PC on which it was created. However, when I make a setup and install it on a different computer, it does not execute and produces no error message. Thank you for your response. And I am looking for help!

And btw, when I remove the data source from the project and update the codes to open PDF files using an OpenFileDialog, everything will become okay.
Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff

2022-04-25T06:59:46.753+00:00

Hi @Tadele Yigrem ,
Is the SQLserver database accessible on the different computer?
Tadele Yigrem 21 Reputation points

2022-04-25T08:01:18.383+00:00

No, I just want it to be a desktop app so that it could be installed in any PC.

Accepted answer

0 additional answers

Your answer

Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff

2022-04-22T08:46:18.243+00:00

Hi @Tadele Yigrem ,

I have built a small VB project(Vb.Net 2019) with a SQL server integrated.

Could you please provide more information about your project and Integrate sql server in the project?
Tadele Yigrem 21 Reputation points

2022-04-22T11:32:53.877+00:00

Of course! The project only includes one form (Form1), which contains a PDF viewer (Adobe Acrobat PDF reader component) and a text box (TextBox1). Then I changed TextBox1's DataBindings attribute to a SQL server table that stores a PDF file location. And I write code on the Form1 load event so that the PDF viewer will use TextBox1.Text as the source and show the PDF file. Because it is a simple project, it has no bugs; that is, it runs flawlessly on the PC on which it was created. However, when I make a setup and install it on a different computer, it does not execute and produces no error message. Thank you for your response. And I am looking for help!

And btw, when I remove the data source from the project and update the codes to open PDF files using an OpenFileDialog, everything will become okay.
Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff

2022-04-25T06:59:46.753+00:00

Hi @Tadele Yigrem ,
Is the SQLserver database accessible on the different computer?
Tadele Yigrem 21 Reputation points

2022-04-25T08:01:18.383+00:00

No, I just want it to be a desktop app so that it could be installed in any PC.

Answer 1

Jiachen Li-MSFT 34,221 Microsoft External Staff

Hi @Tadele Yigrem ,
If sqlserver is not installed on the client, the data of sqlserverdatatable cannot be read.
You can choose to use other methods to save table information, such as Save a dataset as XML.
Best Regards.
Jiachen Li

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Tadele Yigrem 21 Reputation points

2022-04-25T08:53:27.747+00:00

Thank you! But, there is a SQL server installed in the client PC, and even we can prompt the client to install what's required via the "prerequisite section". But while building the installation package, the companion files refused to be included while adding the Project Outputs. I gave it a try by changing the SQL database by a Microsoft Access Database and when I check the "Companion Files (Copy to Output Directory)" checkbox in the add project output section, the installer included the database in the installation package, and it works. But using access database challenges me on CURD operation and that's why I switched my direction to SQL database.
Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff

2022-04-25T09:08:02.557+00:00

Hi @Tadele Yigrem ,
Check the solution in the question below to attach the database to the SQLserver on the client computer.
https://social.msdn.microsoft.com/Forums/en-US/3c86b246-918e-4b22-be43-d15dc5abf01b/attaching-an-mdf-database-to-sql-server-and-sharing-that-database?forum=sqlexpress
Server.AttachDatabase Method
Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff

2022-04-28T07:45:12.107+00:00

Hi @Tadele Yigrem ,
May I know if you have got any chance to check my reply? I am glad to help if you have any other questions.
Tadele Yigrem 21 Reputation points

2022-04-28T08:10:15.357+00:00

Yes, my dear! I have checked all your replies. And I am trying to change my table storage in to an XML file as per your recommendation. Thank you for that. And I am learning about attaching and detaching databases from a SQL server. So, there might be a chance to attach the original database in to a clients' computer SQL server and the setup file created in computer A may be able to work in computer B (the client PC).

Share via

Setup file for my vb.net project with a SQL Server!

0 additional answers

Your answer