Re: MSDE newbie question: connection strings
From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 05/26/04
- Next message: Mary Chipman: "Re: Documenting MSDE"
- Previous message: dev: "ISV using SQL Authentication and a small concern"
- In reply to: Simon Elliott: "MSDE newbie question: connection strings"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 26 May 2004 16:37:26 +0200
hi Simon,
"Simon Elliott" <Simon at ctsn.co.uk> ha scritto nel messaggio
news:OuUGwZwQEHA.3580@TK2MSFTNGP11.phx.gbl...
> I installed MSDE on a Windows XP SP1 PC on our network. We don't have a
> domain controller.
>
> If I access this database via ADO, how do I construct the connection
> string? As I understand it, this is of the form:
>
> Provider=SQLOLEDB; Data Source=server_name; Initial
> Catalog=database_name; User ID=username; Password=password;
>
> Is the server name just the name or IP address of the PC running MSDE?
> Are there any other subtleties I should be aware of?
if the MSDE instance has been installed as the default intance, it's name
will just be the ComputerName and/or it's IP address... if it has been
installed as a named instance, it's name will be
ComputerName\InstanceName...
-- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
- Next message: Mary Chipman: "Re: Documenting MSDE"
- Previous message: dev: "ISV using SQL Authentication and a small concern"
- In reply to: Simon Elliott: "MSDE newbie question: connection strings"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
