Connection strings - Visual Basic .NET

Gary Brizard

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

Subscribe Reply

1686

Kevin Yu [MSFT]

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******@palac asino.com>
| From: "Gary Brizard" <gb******@palac asino.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.publi c.dotnet.langua ges.vb
| NNTP-Posting-Host: 216.190.36.99
| Path:
cpmsftngxa06.ph x.gbl!TK2MSFTNG XA06.phx.gbl!TK 2MSFTNGXA05.phx .gbl!TK2MSFTNGP 0
8.phx.gbl!tk2ms ftngp13.phx.gbl
| Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.vb:146738
| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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

Nice Chap

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.mic rosoft.com> wrote in message
news:Qg******** ******@cpmsftng xa06.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******@palac asino.com>
| From: "Gary Brizard" <gb******@palac asino.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.publi c.dotnet.langua ges.vb
| NNTP-Posting-Host: 216.190.36.99
| Path:
cpmsftngxa06.ph x.gbl!TK2MSFTNG XA06.phx.gbl!TK 2MSFTNGXA05.phx .gbl!TK2MSFTNGP 0 8.phx.gbl!tk2ms ftngp13.phx.gbl
| Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.vb:146738
| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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

Kevin Yu [MSFT]

Nov 20 '05 #4

Nice Chap

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.mic rosoft.com> wrote in message
news:PL******** ******@cpmsftng xa06.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******@Plasm aDyne.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.publi c.dotnet.langua ges.vb
| NNTP-Posting-Host: news.lynxfs.net 193.130.133.162
| Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP11.phx.g bl
| Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.vb:146865
| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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.mic rosoft.com> wrote in message
| news:Qg******** ******@cpmsftng xa06.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******@palac asino.com>
| > | From: "Gary Brizard" <gb******@palac asino.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.publi c.dotnet.langua ges.vb
| > | NNTP-Posting-Host: 216.190.36.99
| > | Path:
| >
|
cpmsftngxa06.ph x.gbl!TK2MSFTNG XA06.phx.gbl!TK 2MSFTNGXA05.phx .gbl!TK2MSFTNGP 0 | > 8.phx.gbl!tk2ms ftngp13.phx.gbl
| > | Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.vb:146738 | > | X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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

Kevin Yu [MSFT]

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******@Plasm aDyne.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.publi c.dotnet.langua ges.vb
| NNTP-Posting-Host: news.lynxfs.net 193.130.133.162
| Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP12.phx.g bl
| Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.vb:147200
| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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.mic rosoft.com> wrote in message
| news:PL******** ******@cpmsftng xa06.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******@Plasm aDyne.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.publi c.dotnet.langua ges.vb
| > | NNTP-Posting-Host: news.lynxfs.net 193.130.133.162
| > | Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP11.phx.g bl
| > | Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.vb:146865
| > | X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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.mic rosoft.com> wrote in message
| > | news:Qg******** ******@cpmsftng xa06.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******@palac asino.com>
| > | > | From: "Gary Brizard" <gb******@palac asino.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.publi c.dotnet.langua ges.vb
| > | > | NNTP-Posting-Host: 216.190.36.99
| > | > | Path:
| > | >
| > |
| >
|
cpmsftngxa06.ph x.gbl!TK2MSFTNG XA06.phx.gbl!TK 2MSFTNGXA05.phx .gbl!TK2MSFTNGP 0
| > | > 8.phx.gbl!tk2ms ftngp13.phx.gbl
| > | > | Xref: cpmsftngxa06.ph x.gbl
| microsoft.publi c.dotnet.langua ges.vb:146738
| > | > | X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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

Nice Chap

Thanks Kevin...

"Kevin Yu [MSFT]" <v-****@online.mic rosoft.com> wrote in message
news:PA******** ******@cpmsftng xa06.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******@Plasm aDyne.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.publi c.dotnet.langua ges.vb
| NNTP-Posting-Host: news.lynxfs.net 193.130.133.162
| Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP12.phx.g bl
| Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.vb:147200
| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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.mic rosoft.com> wrote in message
| news:PL******** ******@cpmsftng xa06.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******@Plasm aDyne.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.publi c.dotnet.langua ges.vb
| > | NNTP-Posting-Host: news.lynxfs.net 193.130.133.162
| > | Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP11.phx.g bl
| > | Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.vb:146865 | > | X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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.mic rosoft.com> wrote in message
| > | news:Qg******** ******@cpmsftng xa06.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******@palac asino.com>
| > | > | From: "Gary Brizard" <gb******@palac asino.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.publi c.dotnet.langua ges.vb
| > | > | NNTP-Posting-Host: 216.190.36.99
| > | > | Path:
| > | >
| > |
| >
|
cpmsftngxa06.ph x.gbl!TK2MSFTNG XA06.phx.gbl!TK 2MSFTNGXA05.phx .gbl!TK2MSFTNGP 0 | > | > 8.phx.gbl!tk2ms ftngp13.phx.gbl
| > | > | Xref: cpmsftngxa06.ph x.gbl
| microsoft.publi c.dotnet.langua ges.vb:146738
| > | > | X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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

Kevin Yu [MSFT]

You're welcome!

--------------------
| From: "Nice Chap" <Ni******@Plasm aDyne.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.publi c.dotnet.langua ges.vb
| NNTP-Posting-Host: news.lynxfs.net 193.130.133.162
| Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP09.phx.g bl
| Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.vb:147232
| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.vb
|
| Thanks Kevin...
|
| "Kevin Yu [MSFT]" <v-****@online.mic rosoft.com> wrote in message
| news:PA******** ******@cpmsftng xa06.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******@Plasm aDyne.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.publi c.dotnet.langua ges.vb
| > | NNTP-Posting-Host: news.lynxfs.net 193.130.133.162
| > | Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP12.phx.g bl
| > | Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.vb:147200
| > | X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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.mic rosoft.com> wrote in message
| > | news:PL******** ******@cpmsftng xa06.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******@Plasm aDyne.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.publi c.dotnet.langua ges.vb
| > | > | NNTP-Posting-Host: news.lynxfs.net 193.130.133.162
| > | > | Path:
cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP11.phx.g bl
| > | > | Xref: cpmsftngxa06.ph x.gbl
| microsoft.publi c.dotnet.langua ges.vb:146865
| > | > | X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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.mic rosoft.com> wrote in message
| > | > | news:Qg******** ******@cpmsftng xa06.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******@palac asino.com>
| > | > | > | From: "Gary Brizard" <gb******@palac asino.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.publi c.dotnet.langua ges.vb
| > | > | > | NNTP-Posting-Host: 216.190.36.99
| > | > | > | Path:
| > | > | >
| > | > |
| > | >
| > |
| >
|
cpmsftngxa06.ph x.gbl!TK2MSFTNG XA06.phx.gbl!TK 2MSFTNGXA05.phx .gbl!TK2MSFTNGP 0
| > | > | > 8.phx.gbl!tk2ms ftngp13.phx.gbl
| > | > | > | Xref: cpmsftngxa06.ph x.gbl
| > | microsoft.publi c.dotnet.langua ges.vb:146738
| > | > | > | X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.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

Similar topics

4748

Oracle Connection Pooling

by: JWM | last post by:

I am trying to implement Oracle connection pooling for the following code, which was written by someone else. Here is my main question -- this java file creates code that is executed every hour, but once per week, the oracle server is brought down for backup. At that time, I get an error that looks like I have the wrong credentials for the database. For every subsequent attempt to run the hourly process, I am getting a broken pipe error,...

Oracle Database

5102

AS400 connection AGAIN....

by: Matthew Wells | last post by:

FIRST OF ALL, I APPRECIATE PEOPLE SENDIUNG ME LINKS TO WEB SITES FOR CONNECTION STRINGS BUT AS I'VE SAID BEFORE THAT IS NOT WHAT I NEED. I CAN EASILY OPEN AN ADO CONNECTION OBJECT TO AS400. I NEED TO REFRESH A DAO (Access) TABLEDEF OBJECT'S CONNECTION STRING WHICH MUST INCLUDE A CLAUSE FOR THE TABLE NAME. THIS IS WHAT I NEED. PLEASE READ AGAIN. Can someonne please tell me an ADO connection string to use to link an AS400 table to...

Microsoft Access / VBA

2865

SqlCacheDependency

by: stewart | last post by:

I've got the standard SqlCacheDependency working just fine , ie. I've defined (and encrypted) the connectionStrings section in the web.config, and I've also defined an an sqlCacheDependency in the caching section. So, in my code I add an item to the cache with an sqlCacheDependency, referencing the named sqlCacheDependency in the web.config and the database table it is to be based on (have enabled notificiations for that table). Fine. ...

ASP.NET

3505

Connection String in .config file - Security Concerns

by: WebMatrix | last post by:

Hello, I have developed a web application that connects to 2 different database servers. The connection strings with db username + password are stored in web.config file. After a code review, one developer suggested that it's a security flaw; therefore connection strings should be kept somewhere else or encrypted. My argument is that web.config file is protected by IIS and Windows security which is the case. And another argument is that...

C# / C Sharp

5381

Dyanically changing connection strings for SqlDataSource

by: Matt Colegrove | last post by:

I'm working on a web app that is published to a hosting service. I'm developing it on my local PC with VS 2005 and SQL Express. The hosting service DB is SQL Server 2000. I have two connectionStrings defined in my web.config file, one for the development db and another for the production db. When I publish my app to the hosting site, I rename the two connection strings so that the production string will be the active string in the...

.NET Framework

2130

Database Connection - Development to Production

by: Matt | last post by:

Hello, What is the best way to handle the database connection string for a class library project that will be compiled and used as a .dll? This .dll will be accessed via classic ASP and in the future by ASP.NET pages. I have created a constant that contains the connection string (as shown below).

.NET Framework

1993

Weird problem with connection strings

by: Harry Strybos | last post by:

Hi All I have a really strange problem occurring in my application. When I read in the application settings for connection strings the following happens: Here are my connection string settings - <connectionStrings> <add name="TRM8.UI.My.MySettings.TRM8" connectionString="Data Source=SQLDATA;Initial Catalog=TRM8_PROD;Integrated Security=True"

Visual Basic .NET

2776

connection strings in config file

by: =?Utf-8?B?Vmlua2k=?= | last post by:

Hello Everyone, I have a question about storing the connection strings to the database in a config file or database. My manager wants me to store all the connection strings in a database, but I think it is easier and faster to store the connection strings in the config file. I was wondering if anyone has any opinion on this issue so that I can convince my manager. Thanks.

C# / C Sharp

5392

Web.config and Connection String Management

by: Johnson | last post by:

I'm trying to fix a "sub optimal" situation with respect to connection string management. Your thoughtful responses will be appreciated. I just started with a new client who has a bunch of legacy ASP.NET applications that all manage connection strings in Web.config the same way, like this: This client has one Web.config file per application, and that one Web.config file is duplicated across all environments (i.e., dev machines, test,...

.NET Framework

9522

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9336

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10111

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8770

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7327

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5215

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5364

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3446

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2738

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General