mahrayan
asked on
sql on standalone CD
hi experts.
examin that i have M.S. SQL database.
how can i create an application with VB that use SQL database and
this application will distribute on standalone CD.
some user had not sqlserver on its machine,
and my cd must be STANDALONE.
plz help me .
examin that i have M.S. SQL database.
how can i create an application with VB that use SQL database and
this application will distribute on standalone CD.
some user had not sqlserver on its machine,
and my cd must be STANDALONE.
plz help me .
ASKER
i think M.S. Access databade can used in standalone cd without installing it on user's machine.
and in Vb u can get data from it.
can i use sql database by programming in vb. and not install sql server on user's machine?
and in Vb u can get data from it.
can i use sql database by programming in vb. and not install sql server on user's machine?
Do you mean opening the DB _directly_ from the CD ??
Access can't do this, since he would try to open the .ldb file on the CD (that is impossible).
I use SQLite (http://www.sqlite.org/) that can be read directly from a CD, if needed.
HTH
Marco
Access can't do this, since he would try to open the .ldb file on the CD (that is impossible).
I use SQLite (http://www.sqlite.org/) that can be read directly from a CD, if needed.
HTH
Marco
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Bear in mind of course that any datastore that you have on CD will be Read-only (i.e you won't be able to add/edit/delete records)
ASKER
i want that it be readonly.
my database have some data and programme must search some data from it and show result to user.
consider some PAPER,
database has some feilds like Author,text,date and ...
and user can search some word of text and find PAPER.
my database have some data and programme must search some data from it and show result to user.
consider some PAPER,
database has some feilds like Author,text,date and ...
and user can search some word of text and find PAPER.
ASKER
>No simply because VB cannot talk directly to .mdf files
what about *.mdb?
and installing minimum files like "Microsoft Jet Database Engine " or ...
what about *.mdb?
and installing minimum files like "Microsoft Jet Database Engine " or ...
>>what about *.mdb?
The PC that will run your application will need to be ready for VB, MDAC (data access), Jet pack, any 3rd party you could use. Nothing else would be required.
The PC that will run your application will need to be ready for VB, MDAC (data access), Jet pack, any 3rd party you could use. Nothing else would be required.
ASKER
>The PC that will run your application will need to be ready for VB, MDAC (data access), Jet pack, any 3rd party you could use. Nothing else would be required.
yes for *.mdb
but for *mdf ???
yes for *.mdb
but for *mdf ???
>>but for *mdf ???
You need to install SQL Server first (in addition to all other setup applications)
You need to install SQL Server first (in addition to all other setup applications)
to have a database on a removable device:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_92hx.asp