By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,682 Members | 1,387 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,682 IT Pros & Developers. It's quick & easy.

Connection strings

P: n/a
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.
Nov 20 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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.
|
|
|

Nov 20 '05 #2

P: n/a
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.
|
|
|

Nov 20 '05 #3

P: n/a
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.
| > |
| > |
| > |
| >
|
|
|

Nov 20 '05 #4

P: n/a
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.
| > |
| > |
| > |
| >
|
|
|

Nov 20 '05 #5

P: n/a
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.
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
|

Nov 20 '05 #6

P: n/a
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.
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
|

Nov 20 '05 #7

P: n/a
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.
| > | > | > |
| > | > | > |
| > | > | > |
| > | > | >
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
|

Nov 20 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.