Q: using DSN

[JIM.H.]

Hello,
I have the following lines to read connection string from web.config;

string cStr = ConfigurationSe ttings.AppSetti ngs["connectionStri ng"];
SqlConnection sqlConn = new SqlConnection(c Str);
this.sqlConnect ion1.Connection String = cStr;

How can replace this with a DSN (ODBC connection) I defined in my current
machine?
Thanks,

[Daniel Walzenbach]

Jim,

have a look at:
http://www.connectionstrings.com/

Regards

Daniel Walzenbach

"JIM.H." <JI**@discussio ns.microsoft.co m> schrieb im Newsbeitrag
news:8D******** *************** ***********@mic rosoft.com...

Hello,
I have the following lines to read connection string from web.config;

string cStr = ConfigurationSe ttings.AppSetti ngs["connectionStri ng"];
SqlConnection sqlConn = new SqlConnection(c Str);
this.sqlConnect ion1.Connection String = cStr;

How can replace this with a DSN (ODBC connection) I defined in my current
machine?
Thanks,

[JIM.H.]

Hi Daniel,
Thanks you for your reply. I was checking that site I did not really see
how I could use a DSN called myDSN for SQL server connection in there. Can
you give me specific example?
Thanks,
"Daniel Walzenbach" wrote:

Jim,

have a look at:
http://www.connectionstrings.com/

Regards

Daniel Walzenbach

"JIM.H." <JI**@discussio ns.microsoft.co m> schrieb im Newsbeitrag
news:8D******** *************** ***********@mic rosoft.com...

Hello,
I have the following lines to read connection string from web.config;

string cStr = ConfigurationSe ttings.AppSetti ngs["connectionStri ng"];
SqlConnection sqlConn = new SqlConnection(c Str);
this.sqlConnect ion1.Connection String = cStr;

How can replace this with a DSN (ODBC connection) I defined in my current
machine?
Thanks,

[Daniel Walzenbach]

Jim,

have you tried those entries?

a.. DSN:

"DSN=myDsn;Uid= username;Pwd=;"
a.. File DSN:

"FILEDSN=c:\myD ata.dsn;Uid=use rname;Pwd=;"
Daniel
"JIM.H." <JI**@discussio ns.microsoft.co m> schrieb im Newsbeitrag
news:5E******** *************** ***********@mic rosoft.com...

Hi Daniel,
Thanks you for your reply. I was checking that site I did not really see
how I could use a DSN called myDSN for SQL server connection in there. Can
you give me specific example?
Thanks,
"Daniel Walzenbach" wrote:

Jim,

have a look at:
http://www.connectionstrings.com/

Regards

Daniel Walzenbach

"JIM.H." <JI**@discussio ns.microsoft.co m> schrieb im Newsbeitrag
news:8D******** *************** ***********@mic rosoft.com...

> Hello,
> I have the following lines to read connection string from web.config;
>
> string cStr = ConfigurationSe ttings.AppSetti ngs["connectionStri ng"];
> SqlConnection sqlConn = new SqlConnection(c Str);
> this.sqlConnect ion1.Connection String = cStr;
>
> How can replace this with a DSN (ODBC connection) I defined in my
> current
> machine?
> Thanks,
>

[Venkat_KL]

Hi Dear JIM.H,

This is the sample where you give all your connection string values inside
the asp.net file (ie. for example: in code behind)

But in your case You have to give

either

"DSN=mySystemDS N;" & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

or

"FILEDSN=c:\som epath\mydb.dsn; " & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

in you web.config in <appSettings> </appSettings> section like below

<configuratio n>
<appSettings>
<add key="pubsDSN" value="DSN=mySy stemDSN;Uid=myU sername;Pwd=myP assword"
/>
</appSettings>
</configuration>

OR

<configuratio n>
<appSettings>
<add key="pubsFileDS N"
value="FILEDSN= c:\somepath\myd b.dsn;Uid=myUse rname;Pwd=myPas sword"/>
</appSettings>
</configuration>

and

in your code behind to access the web.config file DSN/FileDSN

Dim dsn As String = ConfigurationSe ttings.AppSetti ngs("pubsDSN")
or
Dim dsn As String = ConfigurationSe ttings.AppSetti ngs("pubsFileDS N")
ODBC DSN
=======
Using an ODBC DSN (Data Source Name) is a two step process.

1) You must first create the DSN via the "ODBC Data Source Administrator"
program found in your computer's Control Panel (or Administrative Tools menu
in Windows 2000). Make sure to create a SYSTEM DSN (not a USER DSN) when
using ASP(I think same thing holds good for ASP.NET).

2) Then use the following connection string - with your own DSN
name of course.

DSN
====
oConn.Open "DSN=mySystemDS N;" & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

File DSN
======
oConn.Open "FILEDSN=c:\som epath\mydb.dsn; " & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

Note:
====
The problem with DSN is that Users can (and will) modify or delete them by
mistake, then your program won't work so well. So it's better to use a
DSN-Less or OLE DB Provider connection string - with a Trusted Connection if
possible!

About ODBC data sources
=============== =
http://msdn.microsoft.com/library/de...ataSources.asp
Login System (ASP.NET)
=============== =
http://www.codeproject.com/Purgatory/Login_System.asp

For Anything & Everything, Please Let Me Know

Bye
Venkat_KL

[Juan T. Llibre]

Other than a DSN is not an property of SqlConnection,
and therefore you cannot use DSN with a SqlConnection,

(Click the "Read more" icon under "Data Shape", at http://www.connectionstrings.com/
and then click "All SqlConnection connectionstrin g properties", so that
the table of properties for the ADO.NET SqlConnection object opens.)

....the question I would ask is :

why would you want to use an OLEDB for ODBC provider
rather than the native SQL provider for SQL Server ?

Typically, this will result in slower performance, because you'd
have to go through an additional layer from OLEDB to ODBC.

You can use the OLEDB driver directly or, far more recommended, use the native
SQLConnection ADO.NET object, which uses native SQL Server methods to do
the job quite a bit more efficiently than either OLEDB or ODBC.


Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
=============== =============== ========
"JIM.H." <JI**@discussio ns.microsoft.co m> wrote in message
news:5E******** *************** ***********@mic rosoft.com...

Hi Daniel,
Thanks you for your reply. I was checking that site I did not really see
how I could use a DSN called myDSN for SQL server connection in there. Can
you give me specific example?
Thanks,
"Daniel Walzenbach" wrote:

Jim,

have a look at:
http://www.connectionstrings.com/

Regards

Daniel Walzenbach

"JIM.H." <JI**@discussio ns.microsoft.co m> schrieb im Newsbeitrag
news:8D******** *************** ***********@mic rosoft.com...

> Hello,
> I have the following lines to read connection string from web.config;
>
> string cStr = ConfigurationSe ttings.AppSetti ngs["connectionStri ng"];
> SqlConnection sqlConn = new SqlConnection(c Str);
> this.sqlConnect ion1.Connection String = cStr;
>
> How can replace this with a DSN (ODBC connection) I defined in my current
> machine?
> Thanks,

[JIM.H.]

Hi Venkat_KL,
Thank you very much for all this great help. Since I am using
“this.sqlConn ection1.Connect ionString� in many places such as “SqlCommand
sqlCmd = new SqlCommand(sqlS tr, connStr);� When I read my DSN from web.config
with the example you gave, how should I use it instead of
“this.sqlConn ection1.Connect ionString� in my code? Will this “SqlCommand
sqlCmd = new SqlCommand(sqlS tr, myDSN);� work? I am new in asp.net and do not
know all these details.
Thanks,


"Venkat_KL" wrote:

Hi Dear JIM.H,

This is the sample where you give all your connection string values inside
the asp.net file (ie. for example: in code behind)

But in your case You have to give

either

"DSN=mySystemDS N;" & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

or

"FILEDSN=c:\som epath\mydb.dsn; " & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

in you web.config in <appSettings> </appSettings> section like below

<configuratio n>
<appSettings>
<add key="pubsDSN" value="DSN=mySy stemDSN;Uid=myU sername;Pwd=myP assword"
/>
</appSettings>
</configuration>

OR

<configuratio n>
<appSettings>
<add key="pubsFileDS N"
value="FILEDSN= c:\somepath\myd b.dsn;Uid=myUse rname;Pwd=myPas sword"/>
</appSettings>
</configuration>

and

in your code behind to access the web.config file DSN/FileDSN

Dim dsn As String = ConfigurationSe ttings.AppSetti ngs("pubsDSN")
or
Dim dsn As String = ConfigurationSe ttings.AppSetti ngs("pubsFileDS N")
ODBC DSN
=======
Using an ODBC DSN (Data Source Name) is a two step process.

1) You must first create the DSN via the "ODBC Data Source Administrator"
program found in your computer's Control Panel (or Administrative Tools menu
in Windows 2000). Make sure to create a SYSTEM DSN (not a USER DSN) when
using ASP(I think same thing holds good for ASP.NET).

2) Then use the following connection string - with your own DSN
name of course.

DSN
====
oConn.Open "DSN=mySystemDS N;" & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

File DSN
======
oConn.Open "FILEDSN=c:\som epath\mydb.dsn; " & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

Note:
====
The problem with DSN is that Users can (and will) modify or delete them by
mistake, then your program won't work so well. So it's better to use a
DSN-Less or OLE DB Provider connection string - with a Trusted Connection if
possible!

About ODBC data sources
=============== =
http://msdn.microsoft.com/library/de...ataSources.asp
Login System (ASP.NET)
=============== =
http://www.codeproject.com/Purgatory/Login_System.asp

For Anything & Everything, Please Let Me Know

Bye
Venkat_KL

[Juan T. Llibre]

The only problem with that is that he didn't want to use <appSettings> .

;-)


Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
=============== =============== ========
"Venkat_KL" <Ve******@discu ssions.microsof t.com> wrote in message
news:D9******** *************** ***********@mic rosoft.com...

Hi Dear JIM.H,

This is the sample where you give all your connection string values inside
the asp.net file (ie. for example: in code behind)

But in your case You have to give

either

"DSN=mySystemDS N;" & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

or

"FILEDSN=c:\som epath\mydb.dsn; " & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

in you web.config in <appSettings> </appSettings> section like below

<configuratio n>
<appSettings>
<add key="pubsDSN" value="DSN=mySy stemDSN;Uid=myU sername;Pwd=myP assword"
/>
</appSettings>
</configuration>

OR

<configuratio n>
<appSettings>
<add key="pubsFileDS N"
value="FILEDSN= c:\somepath\myd b.dsn;Uid=myUse rname;Pwd=myPas sword"/>
</appSettings>
</configuration>

and

in your code behind to access the web.config file DSN/FileDSN

Dim dsn As String = ConfigurationSe ttings.AppSetti ngs("pubsDSN")
or
Dim dsn As String = ConfigurationSe ttings.AppSetti ngs("pubsFileDS N")
ODBC DSN
=======
Using an ODBC DSN (Data Source Name) is a two step process.

1) You must first create the DSN via the "ODBC Data Source Administrator"
program found in your computer's Control Panel (or Administrative Tools menu
in Windows 2000). Make sure to create a SYSTEM DSN (not a USER DSN) when
using ASP(I think same thing holds good for ASP.NET).

2) Then use the following connection string - with your own DSN
name of course.

DSN
====
oConn.Open "DSN=mySystemDS N;" & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

File DSN
======
oConn.Open "FILEDSN=c:\som epath\mydb.dsn; " & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

Note:
====
The problem with DSN is that Users can (and will) modify or delete them by
mistake, then your program won't work so well. So it's better to use a
DSN-Less or OLE DB Provider connection string - with a Trusted Connection if
possible!

About ODBC data sources
=============== =
http://msdn.microsoft.com/library/de...ataSources.asp
Login System (ASP.NET)
=============== =
http://www.codeproject.com/Purgatory/Login_System.asp

For Anything & Everything, Please Let Me Know

Bye
Venkat_KL

[Juan T. Llibre]

re:

Will this "SqlCommand sqlCmd = new SqlCommand(sqlS tr, myDSN);" work?
No, it won't. See my earlier reply.

Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
=============== =============== ========
"JIM.H." <JI**@discussio ns.microsoft.co m> wrote in message
news:28******** *************** ***********@mic rosoft.com... Hi Venkat_KL,
Thank you very much for all this great help. Since I am using
"this.sqlConnec tion1.Connectio nString" in many places such as "SqlCommand
sqlCmd = new SqlCommand(sqlS tr, connStr);" When I read my DSN from web.config
with the example you gave, how should I use it instead of
"this.sqlConnec tion1.Connectio nString" in my code? Will this "SqlCommand
sqlCmd = new SqlCommand(sqlS tr, myDSN);" work? I am new in asp.net and do not
know all these details.
Thanks,


"Venkat_KL" wrote:

Hi Dear JIM.H,

This is the sample where you give all your connection string values inside
the asp.net file (ie. for example: in code behind)

But in your case You have to give

either

"DSN=mySystemDS N;" & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

or

"FILEDSN=c:\som epath\mydb.dsn; " & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

in you web.config in <appSettings> </appSettings> section like below

<configuratio n>
<appSettings>
<add key="pubsDSN" value="DSN=mySy stemDSN;Uid=myU sername;Pwd=myP assword"
/>
</appSettings>
</configuration>

OR

<configuratio n>
<appSettings>
<add key="pubsFileDS N"
value="FILEDSN= c:\somepath\myd b.dsn;Uid=myUse rname;Pwd=myPas sword"/>
</appSettings>
</configuration>

and

in your code behind to access the web.config file DSN/FileDSN

Dim dsn As String = ConfigurationSe ttings.AppSetti ngs("pubsDSN")
or
Dim dsn As String = ConfigurationSe ttings.AppSetti ngs("pubsFileDS N")
ODBC DSN
=======
Using an ODBC DSN (Data Source Name) is a two step process.

1) You must first create the DSN via the "ODBC Data Source Administrator"
program found in your computer's Control Panel (or Administrative Tools menu
in Windows 2000). Make sure to create a SYSTEM DSN (not a USER DSN) when
using ASP(I think same thing holds good for ASP.NET).

2) Then use the following connection string - with your own DSN
name of course.

DSN
====
oConn.Open "DSN=mySystemDS N;" & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

File DSN
======
oConn.Open "FILEDSN=c:\som epath\mydb.dsn; " & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

Note:
====
The problem with DSN is that Users can (and will) modify or delete them by
mistake, then your program won't work so well. So it's better to use a
DSN-Less or OLE DB Provider connection string - with a Trusted Connection if
possible!

About ODBC data sources
=============== =
http://msdn.microsoft.com/library/de...ataSources.asp
Login System (ASP.NET)
=============== =
http://www.codeproject.com/Purgatory/Login_System.asp

For Anything & Everything, Please Let Me Know

Bye
Venkat_KL

[JIM.H.]

Hi Juan,
Thanks for the reply. Ok. I understand it might be little bit slow through
DSN, once I create DSN how do I use it in the code? Is there any way I can
create SQLCommand through DSN.
Thanks,

"Juan T. Llibre" wrote:

re:

Will this "SqlCommand sqlCmd = new SqlCommand(sqlS tr, myDSN);" work?

No, it won't. See my earlier reply.

Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
=============== =============== ========
"JIM.H." <JI**@discussio ns.microsoft.co m> wrote in message
news:28******** *************** ***********@mic rosoft.com...

Hi Venkat_KL,
Thank you very much for all this great help. Since I am using
"this.sqlConnec tion1.Connectio nString" in many places such as "SqlCommand
sqlCmd = new SqlCommand(sqlS tr, connStr);" When I read my DSN from web.config
with the example you gave, how should I use it instead of
"this.sqlConnec tion1.Connectio nString" in my code? Will this "SqlCommand
sqlCmd = new SqlCommand(sqlS tr, myDSN);" work? I am new in asp.net and do not
know all these details.
Thanks,


"Venkat_KL" wrote:

Hi Dear JIM.H,

This is the sample where you give all your connection string values inside
the asp.net file (ie. for example: in code behind)

But in your case You have to give

either

"DSN=mySystemDS N;" & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

or

"FILEDSN=c:\som epath\mydb.dsn; " & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

in you web.config in <appSettings> </appSettings> section like below

<configuratio n>
<appSettings>
<add key="pubsDSN" value="DSN=mySy stemDSN;Uid=myU sername;Pwd=myP assword"
/>
</appSettings>
</configuration>

OR

<configuratio n>
<appSettings>
<add key="pubsFileDS N"
value="FILEDSN= c:\somepath\myd b.dsn;Uid=myUse rname;Pwd=myPas sword"/>
</appSettings>
</configuration>

and

in your code behind to access the web.config file DSN/FileDSN

Dim dsn As String = ConfigurationSe ttings.AppSetti ngs("pubsDSN")
or
Dim dsn As String = ConfigurationSe ttings.AppSetti ngs("pubsFileDS N")
ODBC DSN
=======
Using an ODBC DSN (Data Source Name) is a two step process.

1) You must first create the DSN via the "ODBC Data Source Administrator"
program found in your computer's Control Panel (or Administrative Tools menu
in Windows 2000). Make sure to create a SYSTEM DSN (not a USER DSN) when
using ASP(I think same thing holds good for ASP.NET).

2) Then use the following connection string - with your own DSN
name of course.

DSN
====
oConn.Open "DSN=mySystemDS N;" & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

File DSN
======
oConn.Open "FILEDSN=c:\som epath\mydb.dsn; " & _
"Uid=myUsername ;" & _
"Pwd=myPassword "

Note:
====
The problem with DSN is that Users can (and will) modify or delete them by
mistake, then your program won't work so well. So it's better to use a
DSN-Less or OLE DB Provider connection string - with a Trusted Connection if
possible!

About ODBC data sources
=============== =
http://msdn.microsoft.com/library/de...ataSources.asp
Login System (ASP.NET)
=============== =
http://www.codeproject.com/Purgatory/Login_System.asp

For Anything & Everything, Please Let Me Know

Bye
Venkat_KL