|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
use sql mdf from application folderHi,
I need to deploy my simple windows application to client's pc so that the database it requires is packaged along with it in the application folder. I have done it through the setup project but after installation it throws exception of being unable to acess the database. Please note that the client does not need to have SQL server installed. I have MS SQL Server Express and Developer Edition both installed on my m/c. I am using SQLEXPRESS for database connection strin in my project. My question is, does the client need to have SQL server installed on their system? TIA. Yup. That would be SQLExpress.
<aamirghan***@yahoo.com> wrote in message Show quote news:1136079006.936820.25090@g14g2000cwa.googlegroups.com... > Hi, > > I need to deploy my simple windows application to client's pc so that > the database it requires is packaged along with it in the application > folder. I have done it through the setup project but after installation > it throws exception of being unable to acess the database. Please note > that the client does not need to have SQL server installed. I have MS > SQL Server Express and Developer Edition both installed on my m/c. I am > using SQLEXPRESS for database connection strin in my project. > > My question is, does the client need to have SQL server installed on > their system? > > TIA. > On 31 Dec 2005 17:30:07 -0800, aamirghan***@yahoo.com wrote:
Show quote >Hi, You will need to install SQL server Express on the client's machine.> >I need to deploy my simple windows application to client's pc so that >the database it requires is packaged along with it in the application >folder. I have done it through the setup project but after installation >it throws exception of being unable to acess the database. Please note >that the client does not need to have SQL server installed. I have MS >SQL Server Express and Developer Edition both installed on my m/c. I am >using SQLEXPRESS for database connection strin in my project. > >My question is, does the client need to have SQL server installed on >their system? > >TIA. After doing this do the deploy as you did before. When the user runs your application the MDF file will be automatically attached to the SQL Server 2005 instance on the user's machine. Thank you for all the posts. Installing MS SQLEXP on every client m/c
just sounded too radical to me. The 2 data tables I was using were just for lookup pupose only (no insert,update) therefore I created 2 XMLs and load them into dataset. Other than MS SQL is there any database that does not need to have a server or engine pre installed on client m/c and all their data could still be accessed from my app. I have not checked MS Access. What is MDAC? thanks. You might want to look into creating .dbf freetables.
<aamirghan***@yahoo.com> wrote in message Show quote news:1136486809.135019.193640@g47g2000cwa.googlegroups.com... > Thank you for all the posts. Installing MS SQLEXP on every client m/c > just sounded too radical to me. > > The 2 data tables I was using were just for lookup pupose only (no > insert,update) therefore I created 2 XMLs and load them into dataset. > > Other than MS SQL is there any database that does not need to have a > server or engine pre installed on client m/c and all their data could > still be accessed from my app. I have not checked MS Access. What is > MDAC? > > thanks. > JET is overkill for what you describe.
Perhaps SQL Mobile would be better suited. Frankly, I would use neither. I would save to a delimited file. -- Show quote____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ "Earl" <brikshoe@newsgroups.nospam> wrote in message news:Ox07%23FUFGHA.2704@TK2MSFTNGP15.phx.gbl... > You might want to look into creating .dbf freetables. > > <aamirghan***@yahoo.com> wrote in message > news:1136486809.135019.193640@g47g2000cwa.googlegroups.com... >> Thank you for all the posts. Installing MS SQLEXP on every client m/c >> just sounded too radical to me. >> >> The 2 data tables I was using were just for lookup pupose only (no >> insert,update) therefore I created 2 XMLs and load them into dataset. >> >> Other than MS SQL is there any database that does not need to have a >> server or engine pre installed on client m/c and all their data could >> still be accessed from my app. I have not checked MS Access. What is >> MDAC? >> >> thanks. >> > >  |
|||||||||||||||||||||||
Other interesting topics