VB 6 + sql server 2000

[khansaa]

Hi .

I developed a program in vb6 and database sql 2000. I created setup exe file CD by using " setup factory software "

Now where i want to use this software first i install sql server 2000, import my database then i install my vb6 programm which i created by using setup factory software.

It is too much lengthy to bring in work.

how can i make one CD setup exe file of my vb6 + sql server 2000 database. So as i install programe automatically they install in exact place ?

I have this program also in Microsoft Access. It is only one setup file. As i install it start to work.

But sql server 2000 i have to bring do many lengthy work. Can some one guide please.

Thanks.

[RhinoBull]

I didn't get the idea of how you use SQL Server but it "sounded" like you use ti as "local" database - if so then continue using MS Access...
However, if your database is intended for enterprise users then it's just one time setup on the server but you'd still need to install your program on every workstation.

[khansaa]

Thanks for detail Answer.

It mean I can not make setup file of database sql server 2000 like microsoft visual studio 6.0 tools -> Package & Deployment wizard does with MS access.

It mean there is no way to add sql server 2000 database in package so it automatically install to any workstation?

Or which software or control i should use to make it in one cd?

every time i have to install with seprate CD sql server in workstation.

is there way to make easy this process.

Any way thanks.

[GaryMazzone]

You can't give away SQL Server 2000...... That must be paid from from MS. You should not be includeing it in your setup

[khansaa]

Thanks for reply.

If i pay then how can i do this?

Please i found article but i need comments for assistence.

http://support.microsoft.com/kb/231923/EN-US/

http://support.microsoft.com/kb/325016

Thanks once again.

[GaryMazzone]

No.... they must buy it.

[khansaa]

I want to send email( vb6 exe file + sql 2000) zip file to my friend.

I send him full sql 2000 version also i send him my database and tell him how to import database etc. Then i send him vb6 program exe file.

He is not beleiving on my efforts, because he don't know these issues.

how to make executiable one setup even it is paid because i do't want my friend become angry on me as he not expert in computer or programming.

Thanks.

[khansaa]

Thanks for reply.

Buy mean not clear what buy?

I have registered vb6 and registered sql 2000 but developer edition.

How and what should i buy so it make my requirement fullfill

Thanks for valueable comments.

thanks once again.

[RhinoBull]

As already pointed out commercial databases like SQL Server, Oracle, Sybase, etc have to be purchased by every client separately directly from their respected vendords (Microsoft, Oracle, Sybase...).
To make their life easier you may however distribute some sql scripts so they can run to create all necessary objects - atbles, vies, stored procedures, etc, etc...
Those scripts can be included (or simply said "sent" to clients) with your vb setup - you may include addition files in the distribution but I would send scripts as a separate package.
Some clients (in case they don't have in-house expertise to setup databse and/or run scripts) may require vendor on site so you must be ready for that as well.

Good luck.

ps, this is more of a deployment question than database...

[khansaa]

Thank you so so much.

It cleared my every question.

Thank you very much once again.