i want to install a software at cli

[prasadalone]

i want to install a software at client place i used visual basic 6 and ms sql 7 for it. is it necessary to install ms sql at client place to run my software.or is there any ms sql runtimes are available through whcih i can run the software plz help me

 

[qoqoqoqo]

If I understand correctly you will need the application loaded on the client stations and a sql server database in place
From there you will not need client connectivity tools (probably just an ODBC connection) or install .... unless of course you wish to run remote queries or something of that nature
Hope I understood you correctly
Thanks

 

[prasadalone]

thanks for the reply, however i wish this to run like how we would run a MS-Access database, i.e. just the mdb file is to be provided in the setup program and MS-Access is not required on the client machine. Similarly, i do not wish to install MS-SQL on the client machine (stand-alone or server). Is it possible?

 

[qoqoqoqo]

Yup,
Well any SQL Server instance you create on an MS Server for instance if configured with the correct network libraries (which they ordinarily are by default) will then allow access from client machines that can see that machine
So just go ahead and install SQL Server and once the database has been established and you can set up a DSN from a client machine the only requirement is that you're application respect that DSN for connection to the DB

A SQL Server db will have two files ordinarily (data and log files) that will be created during db creation. However, these are not simple cut and pasteable files as in Access.

Also you will not need any client tools on the client machines (which version of SQL Server?)

 

[tlbroadbent]

Just to clarify... If the client already has SQL Server installed, you can create you database on the client's SQL Server and conect ot it. However, if the client doesn't already run SQL Server, it must be installed before you can use a program that accesses SQL Server. Check into MSDE, the SQL Server Desktop engine. It is distributable, provided you have the proper tools and licensing.

MSDE 2000:

http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp

MSDE and Visual Studio 6:

http://msdn.microsoft.com/library/en-us/dnmsde/html/msdeforvs.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.