Make .exe and attach SQL DataBase

Page 1 of 1

4 Replies - 184 Views - Last Post: 06 December 2012 - 02:40 PM Rate Topic: -----

#1 .net_Apprentice  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 14
  • Joined: 27-October 12

Make .exe and attach SQL DataBase

Posted 10 November 2012 - 07:35 PM

Hi:
My VB.net aplication works with an SQL Server 2008 data base.
BUT; it will work ON A SINGLE PC where NO SQL Server is installed now.
I have three questions:
How to make it .exe?
Does SQL Server 2008 has to be installed in the user's PC?
How to attach the database in my project?
Can you help me to do this?
Thanks in advance.
.net_apprentice
Is This A Good Question/Topic? 0
  • +

Replies To: Make .exe and attach SQL DataBase

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 6466
  • View blog
  • Posts: 23,511
  • Joined: 12-June 08

Re: Make .exe and attach SQL DataBase

Posted 10 November 2012 - 08:06 PM

Quote

How to make it .exe?

Unless your making a class library the exe should show up in the project's bin folder.

Quote

Does SQL Server 2008 has to be installed in the user's PC?

If you are trying to connect to MSSQL instance - yes... or have a sql server installed and alter the connection string to the sql server machine's information.

Quote

How to attach the database in my project?

You can do a file by right clicking your project -> add new -> local database.. or flip through the tutorials we have on database connections.
Was This Post Helpful? 1
  • +
  • -

#3 .net_Apprentice  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 14
  • Joined: 27-October 12

Re: Make .exe and attach SQL DataBase

Posted 11 November 2012 - 06:38 AM

I am very sorry but I said make it .exe when I should have asked how to plublish the project containing the Data Base.
Is there a tutorial?
Thanks in advance
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 6466
  • View blog
  • Posts: 23,511
  • Joined: 12-June 08

Re: Make .exe and attach SQL DataBase

Posted 11 November 2012 - 12:17 PM

You cannot publish something that some how contains a full install of MSSQL Server 2008. A local DB file sure.. but not an entire install.
Was This Post Helpful? 1
  • +
  • -

#5 .net_Apprentice  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 14
  • Joined: 27-October 12

Re: Make .exe and attach SQL DataBase

Posted 06 December 2012 - 02:40 PM

Thanks a lot for the help.
Thanks
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1