Accessing MSDE

Can one access an MSDE database which is installed on a
m/c from an application which is running on some other m/c?
TIA,
Niranjan
Sorry, the term "m/c" is lost on me in this context. But if you are asking
if you can access a copy of MSDE on one computer from another computer, the
answer is yes. If you are asking if the database file(s) can be on a
different computer to the MSDE service (ie over a network share), the answer
is no.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Niranjan" <anonymous@.discussions.microsoft.com> wrote in message
news:095f01c539dc$c5adfeb0$a501280a@.phx.gbl...
> Can one access an MSDE database which is installed on a
> m/c from an application which is running on some other m/c?
> TIA,
> Niranjan
|||Thanks. What I am looking for is Whether I can run an
application (VC++ application) on one m/c on which I
create ODBC connection to the other machine which has MSDE
installed on it. Typical client server scenario where
client and server apps are running on 2 different
machines. Does MSDE support this kind of requirement? If
yes, what do I need to do on the client (and server side)?
TIA,
Niranjan

>--Original Message--
>Sorry, the term "m/c" is lost on me in this context. But
if you are asking
>if you can access a copy of MSDE on one computer from
another computer, the
>answer is yes. If you are asking if the database file(s)
can be on a
>different computer to the MSDE service (ie over a network
share), the answer
>is no.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"Niranjan" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:095f01c539dc$c5adfeb0$a501280a@.phx.gbl...
m/c?
>
>.
>
|||hi Niranjan,
Niranjan wrote:
> Thanks. What I am looking for is Whether I can run an
> application (VC++ application) on one m/c on which I
> create ODBC connection to the other machine which has MSDE
> installed on it. Typical client server scenario where
> client and server apps are running on 2 different
> machines. Does MSDE support this kind of requirement? If
> yes, what do I need to do on the client (and server side)?
please excuse my poor english, but I do not understand the term "m/c" too..
anyway, the scenario you are interested with is fully supported..
loosely speaking, on the server you have to install MSDE 2000 enabling the
required network protocols (you can check with the Server Network Utility,
svrnetcn.exe)..
on the client side, you typically have to installs only the connectivity
software, included in the MDAC distribution, including the desired driver
(ODBC , OLE DB), and verifying the preferred network protocol(s) to
communicate with the server is enabled via the Client Network Utility
(cliconfg.exe)... and network connections must be available
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply