You're welcome!
--------------------
| From: "Nice Chap" <Ni******@PlasmaDyne.com>
| References: <eo**************@tk2msftngp13.phx.gbl>
<Qg**************@cpmsftngxa06.phx.gbl>
<el**************@TK2MSFTNGP11.phx.gbl>
<PL**************@cpmsftngxa06.phx.gbl>
<u$**************@TK2MSFTNGP12.phx.gbl>
<PA**************@cpmsftngxa06.phx.gbl>
| Subject: Re: Connection strings
| Date: Thu, 16 Oct 2003 11:20:28 +0100
| Lines: 161
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <eN**************@TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.dotnet.languages.vb
| NNTP-Posting-Host: news.lynxfs.net 193.130.133.162
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:147232
| X-Tomcat-NG: microsoft.public.dotnet.languages.vb
|
| Thanks Kevin...
|
| "Kevin Yu [MSFT]" <v-****@online.microsoft.com> wrote in message
| news:PA**************@cpmsftngxa06.phx.gbl...
| > Hi Nice,
| >
| > It was too long and contains many images. I think you can search in
| >
http://msdn.microsoft.com for ".NET Data Access Architecture Guide".
| >
| > Kevin Yu
| > =======
| > "This posting is provided "AS IS" with no warranties, and confers no
| > rights."
| >
| > --------------------
| > | From: "Nice Chap" <Ni******@PlasmaDyne.com>
| > | References: <eo**************@tk2msftngp13.phx.gbl>
| > <Qg**************@cpmsftngxa06.phx.gbl>
| > <el**************@TK2MSFTNGP11.phx.gbl>
| > <PL**************@cpmsftngxa06.phx.gbl>
| > | Subject: Re: Connection strings
| > | Date: Thu, 16 Oct 2003 08:45:07 +0100
| > | Lines: 105
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | Message-ID: <u$**************@TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.dotnet.languages.vb
| > | NNTP-Posting-Host: news.lynxfs.net 193.130.133.162
| > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:147200
| > | X-Tomcat-NG: microsoft.public.dotnet.languages.vb
| > |
| > | Kevin, thanks for the link but unfortunately the page has restricted
| > access.
| > | Can you kindly copy and paste the article onto here pl ?
| > |
| > | "Kevin Yu [MSFT]" <v-****@online.microsoft.com> wrote in message
| > | news:PL**************@cpmsftngxa06.phx.gbl...
| > | > Thanks Nice.
| > | >
| > | > Gary, I've found an article in MSDN which contains how to store
| > connection
| > | > string in a .NET data access architecture.
| > | >
| > | > Please refer to the following link:
| > | >
| > | >
| > |
| >
|
http://msdn.microsoft.com/library/de...us/dnbda/html/
| > | > daag.asp
| > | >
| > | > Kevin Yu
| > | > =======
| > | > "This posting is provided "AS IS" with no warranties, and confers no
| > | > rights."
| > | >
| > | > --------------------
| > | > | From: "Nice Chap" <Ni******@PlasmaDyne.com>
| > | > | References: <eo**************@tk2msftngp13.phx.gbl>
| > | > <Qg**************@cpmsftngxa06.phx.gbl>
| > | > | Subject: Re: Connection strings
| > | > | Date: Wed, 15 Oct 2003 14:37:23 +0100
| > | > | Lines: 52
| > | > | X-Priority: 3
| > | > | X-MSMail-Priority: Normal
| > | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | > | Message-ID: <el**************@TK2MSFTNGP11.phx.gbl>
| > | > | Newsgroups: microsoft.public.dotnet.languages.vb
| > | > | NNTP-Posting-Host: news.lynxfs.net 193.130.133.162
| > | > | Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP11.phx.gbl
| > | > | Xref: cpmsftngxa06.phx.gbl
| microsoft.public.dotnet.languages.vb:146865
| > | > | X-Tomcat-NG: microsoft.public.dotnet.languages.vb
| > | > |
| > | > | Hi Gary, Kevin's idea of passing the Connection String as a
| Parameter
| > is
| > | a
| > | > | very good way of passing information as it reduces the degree of
| > | > 'surprise'
| > | > | in the DA behaviour and also gives the consumer of the DA more
| > control.
| > | > |
| > | > | "Kevin Yu [MSFT]" <v-****@online.microsoft.com> wrote in message
| > | > | news:Qg**************@cpmsftngxa06.phx.gbl...
| > | > | > Hi Gary,
| > | > | >
| > | > | > You can try to put the connection string in the app.config file
of
| > an
| > | > exe
| > | > | > file. When calling the DataAccess layer, you can pass the string
| as
| > a
| > | > | > parameter. Or you can save the connection string in a text or
XML
| > | file,
| > | > | > since it's just a string.
| > | > | >
| > | > | > Kevin Yu
| > | > | > =======
| > | > | > "This posting is provided "AS IS" with no warranties, and
confers
| no
| > | > | > rights."
| > | > | >
| > | > | > --------------------
| > | > | > | Reply-To: "Gary Brizard" <gb******@palacasino.com>
| > | > | > | From: "Gary Brizard" <gb******@palacasino.com>
| > | > | > | Subject: Connection strings
| > | > | > | Date: Tue, 14 Oct 2003 15:42:46 -0700
| > | > | > | Lines: 7
| > | > | > | Organization: Pala Casino
| > | > | > | X-Priority: 3
| > | > | > | X-MSMail-Priority: Normal
| > | > | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | > | > | Message-ID: <eo**************@tk2msftngp13.phx.gbl>
| > | > | > | Newsgroups: microsoft.public.dotnet.languages.vb
| > | > | > | NNTP-Posting-Host: 216.190.36.99
| > | > | > | Path:
| > | > | >
| > | > |
| > | >
| > |
| >
|
cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFT NGXA05.phx.gbl!TK2MSFTNGP0
| > | > | > 8.phx.gbl!tk2msftngp13.phx.gbl
| > | > | > | Xref: cpmsftngxa06.phx.gbl
| > | microsoft.public.dotnet.languages.vb:146738
| > | > | > | X-Tomcat-NG: microsoft.public.dotnet.languages.vb
| > | > | > |
| > | > | > | OK. For an n-tier architecture, where is the best place to
| store
| > | the
| > | > | > | connection string for the DA layer? I don't want to use the
| reg.
| > | > Can't
| > | > | > use
| > | > | > | a app.config for a dll. For other projects I exposed the DA
| layer
| > | > | > through a
| > | > | > | we service and store the connection string in the web.config
| file.
| > | > Any
| > | > | > | recommendations? Thanks.
| > | > | > |
| > | > | > |
| > | > | > |
| > | > | >
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
|
