Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-28 : 13:31:39
|
| Justin writes "Hi there,We are writing a VB application that requires copying, deleting and creating database functionality. (Some of our users will be connecting to SQL server 7.0 and some SQL Server 2000.)We want to use SQL-DMO to do this. This works fine when the host machine is running SQL server or the SQL server desktop engine. However we have been having problems installing SQL-DMO on machines that have only client connectivity components.Is it actually possible run SQL-DMO without an installed instance of SQL server on the machine? If so what merge modules should we use to install SQL-DMO on the client?Thanks in advance for your help.Justin HuntUNIONSOFT, Nagasaki, Japan" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-28 : 14:50:09
|
| When you say "client connectivity components" do you mean SQL Query Analyzer and Enterprise Manager? Or just MDAC? It is my understanding that SQL Enterprise Manager uses SQL-DMO, so if you have the full client tools installed (but not the server tools/engine) then I would expect it to work.If that doesn't solve your problem, post back here for more ideas.<edit>But then again, if they have the Enterprise Manager installed, do they need your application?</edit>--------------------------------------------------------------1000 Posts, Here I come! I wonder what my new title will be...Edited by - AjarnMark on 12/28/2001 14:51:54 |
 |
|
|
jhunt
Starting Member
21 Posts |
Posted - 2001-12-28 : 20:14:40
|
| No, the users will just have MDAC2.6 installed on their machine. It is a client - server app. When the client and server reside on the same machine (MSDE + App -Standalone version), it is easy enough to get SQL-DMO to work. The question really refers to a client that connects to a non local SQL server, and requests the creation of a new database or copying / backing up of an existing database. It is possible to do these things without SQL-DMO, and if it is not possible to use SQL-DMO, I guess thats we will do.Is it possible to use SQL-DMO on a client without an instance of SQL server?Justin HuntUNIONSOFT, Nagasaki, Japan |
|
|
|
|
|
|
|
|
Installing DMO on an SQL Server client