project fail

[cuks_babs]

I just finish make my project with sql 2000 as a database and the software already pack. but when I try to Install in other computer it the database cannot be read.should i use msde? i need to know how to develop using sql database and pack it to togeher and can be run in others computer. thanks

[Hack]

All computers running your software need to have SQL Server installed on a network server to which they have access prior to using your code.

You can not include an SQL Server database in an installation package like you can an MS Access database.

[si_the_geek]

Welcome to VBForums!

By "sql 2000" do you mean SQL Server 2000?
If so, you need to have a database server to use the database. MSDE can effectively be used as a local database server, so if there isn't a 'real' server at the client end then MSDE would be the way to go.

[cuks_babs]

Ok thanks,yes I mean SQL server 2000
I think all of you guys already knew it. Can you teach me specifically how to use MSDE as an implement for that? what should i do or may be you have simple example project for that? I try to find example... or explanation about it! thanks before......

HACK >>You can not include an SQL Server database in an installation package like you can an MS Access database.
ME >>so what should I do

[Hack]

HACK >>You can not include an SQL Server database in an installation package like you can an MS Access database.
ME >>so what should I do

As I said, they have to have it available, so if they don't have SQL Server then, before using your program, they would have to buy it and install it.

[cuks_babs]

[QUOTE]>>>If so, you need to have a database server to use the database. MSDE can effectively be used as a local database server, so if there isn't a 'real' server at the client end then MSDE would be the way to go.
It mean not necesary to have it! am I correct?
so what should I do ? should I include MSDE to the package?

[Hack]

[QUOTE=cuks_babs]

>>>If so, you need to have a database server to use the database. MSDE can effectively be used as a local database server, so if there isn't a 'real' server at the client end then MSDE would be the way to go.

Yes

It mean not necesary to have it! am I correct?

If you use MSDE in your program, then people using your program also need MSDE

so what should I do ? should I include MSDE to the package?

You can download it, but it comes with its own installation and setup package. Your customers would need to know how to do that.

[GaryMazzone]

They will also need to know how to create your database. Either how to attach the files you supply or how to create a new database and create the tables (probably though scripts that you will need to write).

[cuks_babs]

Ok...
so what i need is just to include the data file (student.mdf) in the package.and once MSDE install in other computer it will run automatically the student.mdf as a database?is something should I set before?

[GaryMazzone]

You will need to attach the file to a database in the MSDE enviorment. You should be able to do that with a batch file I belive (I have not tried it personnally)

[Hack]

You will need to attach the file to a database in the MSDE enviorment. You should be able to do that with a batch file I belive (I have not tried it personnally)

Yeah, me either.

However, it is important that you understand that what Gary is saying is that no matter what you do, something has to be done on the user end after MSDE is installed in order to get your database imported.

This

so what i need is just to include the data file (student.mdf) in the package.and once MSDE install in other computer it will run automatically the student.mdf as a database?

is not going to automatically happen without somekind of user interaction.

[cuks_babs]

Mazz1>>You will need to attach the file to a database in the MSDE enviorment
where can i locate it on vb or MSDE?and how bout in vb packaging?should i attach the student.mdf?

[cuks_babs]

garry>>You should be able to do that with a batch file
what do mean? i'm sorry i don't understand...

[GaryMazzone]

MSDE needs to be installed seperately. You can include the installation package on your CD then instruct the enduser to run that package. The other option is to include another application on the CD that will allow to end user to select the install they want to perform (ie the app or the MSDE install). After the MSDE installation is complete you then un a batch file that will copy the database file "student.mdf" to the directory yoy want and use OSQL to attach the database file to the database.