| Author |
Topic |
|
cyberpd
Yak Posting Veteran
60 Posts |
 Posted - 2007-03-08 : 09:02:16
|
| My client wants a search program. I am to use VB6 and SQL Server 2000.The number of records will be not less than 500,000.Client's requirement is the program is going to run from a compact disc and not to be installed.That means I have to give the mdf file along with the program in the disc.My question : How am i going to connect with the mdf file as the user is not going to download anything, and maybe, in most of the cases, he will not have SQL server installed in his machine. What about the log file? As we can not write anything on the cd.. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-08 : 09:17:46
|
| Include SQL Server Express. Install it.Attach the database.Peter LarssonHelsingborg, Sweden |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-08 : 09:19:37
|
| Your requirement doesn't make sense. An .mdf file is useless without SQL server engine. You need at least MSDE (for SQL 2000) or SQL Express (for SQL 2005) and it has to be installed on the client machine.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-08 : 09:22:55
|
| The user is "not going to download anything", so installing from pre-downloaded sql server express would be fine?Peter LarssonHelsingborg, Sweden |
|
|
|
cyberpd
Yak Posting Veteran
60 Posts |
Posted - 2007-03-08 : 15:05:36
|
| Thanks so much for the fast response.From your suggestions what i gather are :-1. The user, in most of the cases, will not have sql server in his machine. So, I will have to distribute the MSDE/sql server express.. along with my program.2. when the program runs it will first install the MSDE/sql server express in the users' machine, attach the database, and will fetch record.I want to make one thing clear that the user will not make any entry/update/delete. He will run reports and see them in grid etc and take print.I have never installed only the DB engine. Is it possible that I can install only the DB engine in the users' machine, and that too remotely?Then I will have to do the following things..a) The user puts the Cd in the tray. Auto-play starts.b) My program installs the DB engine.c) I programmatically attach the Mdf filed) The program then is ready to run the reports.Is that right? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-08 : 22:01:47
|
| Yes. BTW, MSDE/SQL Express has it's own installation program which you can run. Also, there are certain limitation on database size etc. which you need to consider.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
cyberpd
Yak Posting Veteran
60 Posts |
Posted - 2007-03-09 : 01:29:10
|
| HarshIn my case , as I said the number of records will be approximately 500,000. If I install the DB engine will it be able to handle this database? Will I need any other components to run my application?thanks and regards. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-09 : 01:35:00
|
| Check this and this link for understanding limitations of MSDE/SQL Express.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-09 : 01:35:16
|
The client that you are referring to are all stand alone ? Not in a network ?Why not have a dedicated server for running SQL Server 2000 and your VB program connects to the server.
KH |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
client-server problem