Sql Server 7 on Client's PC?

[RohanP]

I have made an DBapplication using VB6 & Sql Server 7

next I have to install it on clients machine... is it necessary to have Sql Server 7 installed on the clients PC??

If not which supporting files I have to include while installation ?

Help will be appriciated ______________________________
- Regards Rohan (India,Mumbai)

 

[tlbroadbent]

The client should have MDAC installed. That is available for download from the Microsoft website (

http://www.microsoft.com/data/)

or from the SQL Server 7 installation CD. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[RohanP]

If a Project is made in VB6 - MSAccess.. it is not necessary to install MS-Access on clients machine. Some of the supporting files fetch data from Access DB the MDB file.. In the same way in case of single user application made in VB & Sql Server, is it necessary to install Sql-Server on clients PC?
Can the mdf & ldf files be accessed directly withou having Sql Server Installed? ______________________________
- Regards Rohan (India,Mumbai)

 

[tlbroadbent]

THe MDF and LDF files cannot be utilized unless they are loaded into SQL Server. SQL Server doesn't have to be installed or running locally. It can be installed on a server or another workstation but it must be running somewhere that is accessible to the client PCs. Clients connect to SQL Server through the Microsoft Data Access Components or MDAC. As I said, "The client should have MDAC installed." Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.