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,

[Juan T. Llibre]

re:

once I create DSN how do I use it in the code?
I don't think you can use it, Jim.

There's no way for the DSN or FILEDSN parameters to be inserted
into a SQLConnection or a SQLCommand object, at least as far as I know.

That is why when you asked earlier :Will this "SqlCommand sqlCmd = new SqlCommand(sqlS tr, myDSN);" work?
I replied : "No, it won't."

And, in the other thread you started on the same subject, I said :
Other than a DSN is not an property of SqlConnection,
and therefore you cannot use DSN with a SqlConnection
I just don't think that it can be done.
If you learn a way to do that, please post it and I will change my opinion.


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:EB******** *************** ***********@mic rosoft.com... 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

[JIM.H.]

Hi Juan,

I see your point, I am not just understanding if DSN definition is possible
in APS.Net, where and how I will use it?

Here is a connection string I can use it ASP;
Set objADODBConn = CreateObject("A DODB.Connection ")
strConn="DSN=" & MyODBC & ";UID=" & MyUsername & ";PWD=" & MyPassword & ";"
objADODBConn.Op en(strConn)

I could not believe that Microsoft does not allow this kind of thing in
ASP.Net for SQL connection. DSN is still using native SQL Server driver in
the system.
However thank you very much for your time.
"Juan T. Llibre" wrote:

re:

once I create DSN how do I use it in the code?

I don't think you can use it, Jim.

There's no way for the DSN or FILEDSN parameters to be inserted
into a SQLConnection or a SQLCommand object, at least as far as I know.

That is why when you asked earlier :

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

I replied : "No, it won't."

And, in the other thread you started on the same subject, I said :

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

I just don't think that it can be done.
If you learn a way to do that, please post it and I will change my opinion.


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:EB******** *************** ***********@mic rosoft.com...

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

[Juan T. Llibre]

You are trying to use ADO in ASP.NET.

For a zillion reasons that is not good.

re:

I could not believe that Microsoft does not allow
this kind of thing in ASP.Net for SQL connection.
Believe it.

Why would Microsoft include as an option something
which buries performance for web applications ?

Take a few minutes to see this ADO.NET presentation :
http://www.microsoft.com/seminar/sha...7/manifest.xml

Also, read the links on this page :
http://msdn.microsoft.com/library/de...withadonet.asp

Don't beat your head against the wall by trying to use ADO in ASP.NET.
You're only going to hurt yourself.


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:AE******** *************** ***********@mic rosoft.com... Hi Juan,

I see your point, I am not just understanding if DSN definition is possible
in APS.Net, where and how I will use it?

Here is a connection string I can use it ASP;
Set objADODBConn = CreateObject("A DODB.Connection ")
strConn="DSN=" & MyODBC & ";UID=" & MyUsername & ";PWD=" & MyPassword & ";"
objADODBConn.Op en(strConn)

I could not believe that Microsoft does not allow this kind of thing in
ASP.Net for SQL connection. DSN is still using native SQL Server driver in
the system.
However thank you very much for your time.
"Juan T. Llibre" wrote:

re:

> once I create DSN how do I use it in the code?

I don't think you can use it, Jim.

There's no way for the DSN or FILEDSN parameters to be inserted
into a SQLConnection or a SQLCommand object, at least as far as I know.

That is why when you asked earlier :

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

I replied : "No, it won't."

And, in the other thread you started on the same subject, I said :

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

I just don't think that it can be done.
If you learn a way to do that, please post it and I will change my opinion.


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:EB******** *************** ***********@mic rosoft.com...

> 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
>>
>>
>>

[logan]

in Version 1.1 you can use
using System.Data.Odb c;
I'm pretty sure that didn't exist in 1.0,
I don't know if it is still available in 2.0.
However as many have pointed out it is rather ineffcient.
I'm going to assume you probably have a reason that requires a dsn though.
"Juan T. Llibre" <no***********@ nowhere.com> wrote in message
news:OM******** ******@tk2msftn gp13.phx.gbl...

You are trying to use ADO in ASP.NET.

For a zillion reasons that is not good.

re:

I could not believe that Microsoft does not allow
this kind of thing in ASP.Net for SQL connection.

Believe it.

Why would Microsoft include as an option something
which buries performance for web applications ?

Take a few minutes to see this ADO.NET presentation :
http://www.microsoft.com/seminar/sha...7/manifest.xml

Also, read the links on this page :
http://msdn.microsoft.com/library/de...withadonet.asp

Don't beat your head against the wall by trying to use ADO in ASP.NET.
You're only going to hurt yourself.


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:AE******** *************** ***********@mic rosoft.com...

Hi Juan,

I see your point, I am not just understanding if DSN definition is
possible
in APS.Net, where and how I will use it?

Here is a connection string I can use it ASP;
Set objADODBConn = CreateObject("A DODB.Connection ")
strConn="DSN=" & MyODBC & ";UID=" & MyUsername & ";PWD=" & MyPassword &
";"
objADODBConn.Op en(strConn)

I could not believe that Microsoft does not allow this kind of thing in
ASP.Net for SQL connection. DSN is still using native SQL Server driver
in
the system.
However thank you very much for your time.

"Juan T. Llibre" wrote:

re:
> once I create DSN how do I use it in the code?

I don't think you can use it, Jim.

There's no way for the DSN or FILEDSN parameters to be inserted
into a SQLConnection or a SQLCommand object, at least as far as I know.

That is why when you asked earlier :
>Will this "SqlCommand sqlCmd = new SqlCommand(sqlS tr, myDSN);" work?

I replied : "No, it won't."

And, in the other thread you started on the same subject, I said :

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

I just don't think that it can be done.
If you learn a way to do that, please post it and I will change my
opinion.


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:EB******** *************** ***********@mic rosoft.com...
> 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
>>
>>
>>