freelanceprogrammers.org Forum Index » ASP
Sticky Wicket: C#.NET calling ADODB
Joined: 09 Jan 2006
Posts: 27
Sticky Wicket: C#.NET calling ADODB
I am converting a web site from classic asp to asp.net
The boss wants to keep the ADODB in place until the new sql database
is ready. I want to know is it possible to do this?
I never used adodb before. I only know data.sqlclient
Let me know if it isp possible to rewrite all the adodb connections
and calls from vbscript to C#. I tried this morning but could not
get the Command.Execute to work
Joined: 07 Jan 2006
Posts: 63
Sticky Wicket: C#.NET calling ADODB
The person is not making any sense. if what you mean is they want to
keep MS access in lace just use System.Data.OleDb instead of SQLClient
and talk to Access.
http://www.learnasp.com/quickstart/howto/doc/adoplus/adorstodataset.aspx
shows how to convert a Recordset to a .net style entity
But ADODB recordsets are for ASP code not ASP.net code
Everything that can be done with Recordset is done cheaper and faster
with ExecuteReader or DataTables.
On Fri, 07 Jan 2005 16:33:45 -0000, scaevola637 <scaevola637@...> wrote:
>
> I am converting a web site from classic asp to asp.net
> The boss wants to keep the ADODB in place until the new sql database
> is ready. I want to know is it possible to do this?
> I never used adodb before. I only know data.sqlclient
>
> Let me know if it isp possible to rewrite all the adodb connections
> and calls from vbscript to C#. I tried this morning but could not
> get the Command.Execute to work
Joined: 09 Jan 2006
Posts: 27
Sticky Wicket: C#.NET calling ADODB
HERE is one function that needs converting from vbscript to C#.
the namespace is ADODB, which is guess is what everyone used in
Classic ASP before ASP.NET. I guess I need a book on Classic ADO.
The instructions are to Keep using ADO but rewrite into C#.NET. I
am not sure it can be done.
function OpenAFCPT()
set adoAFCPT = server.createobject("ADODB.Connection")
adoAFCPT.commandtimeout = dbCommandTimeOut
adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
set cmdAFCPT = Server.CreateObject("ADODB.Command")
cmdAFCPT.ActiveConnection = adoAFCPT
cmdAFCPT.CommandTimeout = dbCommandTimeOut
cmdAFCPT.CommandType = adCmdStoredProc
end function
Joined: 11 Jan 2006
Posts: 38
Sticky Wicket: C#.NET calling ADODB
Doesn`t look possible to me, without a lot of misplaced effort
anyway.
I`m sure you`re right about what he said, but this guy does NOT
need to be giving technical instructions in an environment that he
doesn`t understand. He`s the manager, you`re the programmer. Anyone
with a day of experience with .NET database operations would tell you to
rewrite this function for OleDb (it would take about 15 minutes if you
use the examples on LearnASP.com).
-----Original Message-----
From: scaevola637 [mailto:scaevola637@...]
HERE is one function that needs converting from vbscript to C#. the
namespace is ADODB, which is guess is what everyone used in
Classic ASP before ASP.NET. I guess I need a book on Classic ADO. The
instructions are to Keep using ADO but rewrite into C#.NET. I
am not sure it can be done.
function OpenAFCPT()
set adoAFCPT = server.createobject("ADODB.Connection")
adoAFCPT.commandtimeout = dbCommandTimeOut
adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
set cmdAFCPT = Server.CreateObject("ADODB.Command")
cmdAFCPT.ActiveConnection = adoAFCPT
cmdAFCPT.CommandTimeout = dbCommandTimeOut
cmdAFCPT.CommandType = adCmdStoredProc
end function
Joined: 11 Jan 2006
Posts: 46
Sticky Wicket: C#.NET calling ADODB
Amen. No point to doing this -- if you are going to use .NET, use
.NET, don`t saddle yourself having to call COM objects, just for the
sake of calling COM objects. You will waste hours/days/weeks
attempting to meet this unnecessary technical requirement.
The database doesn`t know/care what access technology you use, so use
the .NET data objects.
On Fri, 7 Jan 2005 11:49:24 -0600, Peter Brunone <peterlists@...> wrote:
>
>
> Doesn`t look possible to me, without a lot of misplaced effort
> anyway.
>
> I`m sure you`re right about what he said, but this guy does NOT
> need to be giving technical instructions in an environment that he
> doesn`t understand. He`s the manager, you`re the programmer. Anyone
> with a day of experience with .NET database operations would tell you to
> rewrite this function for OleDb (it would take about 15 minutes if you
> use the examples on LearnASP.com).
>
>
> -----Original Message-----
> From: scaevola637 [mailto:scaevola637@...]
>
> HERE is one function that needs converting from vbscript to C#. the
> namespace is ADODB, which is guess is what everyone used in
> Classic ASP before ASP.NET. I guess I need a book on Classic ADO. The
> instructions are to Keep using ADO but rewrite into C#.NET. I
> am not sure it can be done.
>
> function OpenAFCPT()
> set adoAFCPT = server.createobject("ADODB.Connection")
> adoAFCPT.commandtimeout = dbCommandTimeOut
> adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> set cmdAFCPT = Server.CreateObject("ADODB.Command")
> cmdAFCPT.ActiveConnection = adoAFCPT
> cmdAFCPT.CommandTimeout = dbCommandTimeOut
> cmdAFCPT.CommandType = adCmdStoredProc
>
> end function
>
> Yahoo! Groups Links
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com
Joined: 07 Jan 2006
Posts: 63
Sticky Wicket: C#.NET calling ADODB
Its just setting up calling a SPROC.
You have dozens of examples of calling Sprocs in the walther book.
This just sets up the connection to call a Sproc.
On Fri, 07 Jan 2005 17:41:14 -0000, scaevola637 <scaevola637@...> wrote:
>
> HERE is one function that needs converting from vbscript to C#.
> the namespace is ADODB, which is guess is what everyone used in
> Classic ASP before ASP.NET. I guess I need a book on Classic ADO.
> The instructions are to Keep using ADO but rewrite into C#.NET. I
> am not sure it can be done.
>
> function OpenAFCPT()
> set adoAFCPT = server.createobject("ADODB.Connection")
> adoAFCPT.commandtimeout = dbCommandTimeOut
> adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> set cmdAFCPT = Server.CreateObject("ADODB.Command")
> cmdAFCPT.ActiveConnection = adoAFCPT
> cmdAFCPT.CommandTimeout = dbCommandTimeOut
> cmdAFCPT.CommandType = adCmdStoredProc
>
> end function
>
>
>
>
>
>
> ________________________________
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
> AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Joined: 09 Jan 2006
Posts: 27
Sticky Wicket: C#.NET calling ADODB
I am missing something. I do not see a connection string in any of
the code. I do not understnad how to get a connection string to the
com object. I will look at the example.
You are telling me I can use OLE DB and not have a connection string?
--- In AspNetAnyQuestionIsOk@yahoogroups.com, Dean Fiala
<dfiala@g...> wrote:
> Amen. No point to doing this -- if you are going to use .NET, use
> .NET, don`t saddle yourself having to call COM objects, just for
the
> sake of calling COM objects. You will waste hours/days/weeks
> attempting to meet this unnecessary technical requirement.
>
> The database doesn`t know/care what access technology you use, so
use
> the .NET data objects.
>
>
> On Fri, 7 Jan 2005 11:49:24 -0600, Peter Brunone <peterlists@b...>
wrote:
> >
> >
> > Doesn`t look possible to me, without a lot of misplaced
effort
> > anyway.
> >
> > I`m sure you`re right about what he said, but this guy
does NOT
> > need to be giving technical instructions in an environment that
he
> > doesn`t understand. He`s the manager, you`re the programmer.
Anyone
> > with a day of experience with .NET database operations would
tell you to
> > rewrite this function for OleDb (it would take about 15 minutes
if you
> > use the examples on LearnASP.com).
> >
> >
> > -----Original Message-----
> > From: scaevola637 [mailto:scaevola637@y...]
> >
> > HERE is one function that needs converting from vbscript to C#.
the
> > namespace is ADODB, which is guess is what everyone used in
> > Classic ASP before ASP.NET. I guess I need a book on Classic
ADO. The
> > instructions are to Keep using ADO but rewrite into C#.NET. I
> > am not sure it can be done.
> >
> > function OpenAFCPT()
> > set adoAFCPT = server.createobject("ADODB.Connection")
> > adoAFCPT.commandtimeout = dbCommandTimeOut
> > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> > set cmdAFCPT = Server.CreateObject("ADODB.Command")
> > cmdAFCPT.ActiveConnection = adoAFCPT
> > cmdAFCPT.CommandTimeout = dbCommandTimeOut
> > cmdAFCPT.CommandType = adCmdStoredProc
> >
> > end function
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
>
> --
> Dean Fiala
> Very Practical Software, Inc
> http://www.vpsw.com
Joined: 09 Jan 2006
Posts: 27
Sticky Wicket: C#.NET calling ADODB
Charles,
Thanks. I guess you are still in Japan. Looking at the example I
do not have a connection string, I do not even know the name of the
box sql is running on. Com is doing all this somewhere that I do
not see.
>
>
http://www.learnasp.com/quickstart/howto/doc/adoplus/adorstodataset.a
spx
> shows how to convert a Recordset to a .net style entity
>
> But ADODB recordsets are for ASP code not ASP.net code
>
> Everything that can be done with Recordset is done cheaper and
faster
> with ExecuteReader or DataTables.
>
> On Fri, 07 Jan 2005 16:33:45 -0000, scaevola637 <scaevola637@y...>
wrote:
> >
> > I am converting a web site from classic asp to asp.net
> > The boss wants to keep the ADODB in place until the new sql
database
> > is ready. I want to know is it possible to do this?
> > I never used adodb before. I only know data.sqlclient
> >
> > Let me know if it isp possible to rewrite all the adodb
connections
> > and calls from vbscript to C#. I tried this morning but could
not
> > get the Command.Execute to work
Joined: 07 Jan 2006
Posts: 63
Sticky Wicket: C#.NET calling ADODB
function OpenAFCPT()
set adoAFCPT = server.createobject("ADODB.Connection")
adoAFCPT.commandtimeout = dbCommandTimeOut
adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
set cmdAFCPT = Server.CreateObject("ADODB.Command")
cmdAFCPT.ActiveConnection = adoAFCPT
cmdAFCPT.CommandTimeout = dbCommandTimeOut
cmdAFCPT.CommandType = adCmdStoredProc
end function
what you are looking at is a function that opens a connection. It is
written by someone with very limited programming skills as they forgot
to return a value from that function.
adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
opens the connection
you need to find out (by searching code) what the variables are
dnsAFCPT = the variable they stuffed the connection string in
usrAFCPT = the variable they stuffed the user name in
pasAFCPT = the variable they stuffed the user password in
adding 3 lines to that code will determine that.
adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
response.write "dnsAFCPT=" & dnsAFCPT & "<br>"
response.write "userAFCPT=" & userAFCPT & "<br>"
response.write "pasAFCPT=" & pasAFCPT & "<br>"
Anyone who demands that ADODB still be used is not capable of givng
credible technical advice PERIOD and anyone who let the code above get
written and used should not be dispensing technical advice that you
take seriously although diplonmatically you may smile and say thanks
and that you will take the advice but you need to be taling to experts
at places like this not taking yoru cues from someone who does not
understand anything about ADODB..
http://www.learnasp.com/freebook/learn/cs_dbtable.aspx
shows how to connect to an access DB from C# -- it is first example we
did in class.
Anything ADO can do ADO.net does 10 x better and faster.
On Fri, 07 Jan 2005 18:21:28 -0000, scaevola637 <scaevola637@...> wrote:
>
> I am missing something. I do not see a connection string in any of
> the code. I do not understnad how to get a connection string to the
> com object. I will look at the example.
> You are telling me I can use OLE DB and not have a connection string?
Joined: 09 Jan 2006
Posts: 27
Sticky Wicket: C#.NET calling ADODB
Charles,
You alone are the holy one. Thanks, When you speak everything
becomes flooded with light.
I know how to do all this using ado.net. Is there any way for me to
tell what is the name of the sql box on the network all these
queries are going against? Can I still get premium membership for
$500?
--- In AspNetAnyQuestionIsOk@yahoogroups.com, Charles Carroll
<911@l...> wrote:
> function OpenAFCPT()
> set adoAFCPT = server.createobject("ADODB.Connection")
> adoAFCPT.commandtimeout = dbCommandTimeOut
> adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> set cmdAFCPT = Server.CreateObject("ADODB.Command")
> cmdAFCPT.ActiveConnection = adoAFCPT
> cmdAFCPT.CommandTimeout = dbCommandTimeOut
> cmdAFCPT.CommandType = adCmdStoredProc
> end function
>
> what you are looking at is a function that opens a connection. It
is
> written by someone with very limited programming skills as they
forgot
> to return a value from that function.
>
> adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
>
> opens the connection
>
> you need to find out (by searching code) what the variables are
> dnsAFCPT = the variable they stuffed the connection string in
> usrAFCPT = the variable they stuffed the user name in
> pasAFCPT = the variable they stuffed the user password in
>
> adding 3 lines to that code will determine that.
> adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> response.write "dnsAFCPT=" & dnsAFCPT & "<br>"
> response.write "userAFCPT=" & userAFCPT & "<br>"
> response.write "pasAFCPT=" & pasAFCPT & "<br>"
>
> Anyone who demands that ADODB still be used is not capable of givng
> credible technical advice PERIOD and anyone who let the code above
get
> written and used should not be dispensing technical advice that you
> take seriously although diplonmatically you may smile and say
thanks
> and that you will take the advice but you need to be taling to
experts
> at places like this not taking yoru cues from someone who does not
> understand anything about ADODB..
>
> http://www.learnasp.com/freebook/learn/cs_dbtable.aspx
> shows how to connect to an access DB from C# -- it is first
example we
> did in class.
>
> Anything ADO can do ADO.net does 10 x better and faster.
>
> On Fri, 07 Jan 2005 18:21:28 -0000, scaevola637 <scaevola637@y...>
wrote:
> >
> > I am missing something. I do not see a connection string in
any of
> > the code. I do not understnad how to get a connection string
to the
> > com object. I will look at the example.
> > You are telling me I can use OLE DB and not have a connection
string?
Joined: 07 Jan 2006
Posts: 63
Sticky Wicket: C#.NET calling ADODB
Paypal me $500 and its a done deal
On Sat, 8 Jan 2005 04:13:15 +0900, Charles Carroll
<charlesmarkcarroll@...> wrote:
> http://www.learnasp.com/learn/connectioninfo.asp
> will tell you what you want.
>
>
> On Fri, 07 Jan 2005 18:50:15 -0000, scaevola637 <scaevola637@...> wrote:
> >
> > Charles,
> > You alone are the holy one. Thanks, When you speak everything
> > becomes flooded with light.
> > I know how to do all this using ado.net. Is there any way for me to
> > tell what is the name of the sql box on the network all these
> > queries are going against? Can I still get premium membership for
> > $500?
> >
> >
> > --- In AspNetAnyQuestionIsOk@yahoogroups.com, Charles Carroll
> >
> > <911@l...> wrote:
> > > function OpenAFCPT()
> > > set adoAFCPT = server.createobject("ADODB.Connection")
> > > adoAFCPT.commandtimeout = dbCommandTimeOut
> > > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> > > set cmdAFCPT = Server.CreateObject("ADODB.Command")
> > > cmdAFCPT.ActiveConnection = adoAFCPT
> > > cmdAFCPT.CommandTimeout = dbCommandTimeOut
> > > cmdAFCPT.CommandType = adCmdStoredProc
> > > end function
> > >
> > > what you are looking at is a function that opens a connection. It
> > is
> > > written by someone with very limited programming skills as they
> > forgot
> > > to return a value from that function.
> > >
> > > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> > >
> > > opens the connection
> > >
> > > you need to find out (by searching code) what the variables are
> > > dnsAFCPT = the variable they stuffed the connection string in
> > > usrAFCPT = the variable they stuffed the user name in
> > > pasAFCPT = the variable they stuffed the user password in
> > >
> > > adding 3 lines to that code will determine that.
> > > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> > > response.write "dnsAFCPT=" & dnsAFCPT & "<br>"
> > > response.write "userAFCPT=" & userAFCPT & "<br>"
> > > response.write "pasAFCPT=" & pasAFCPT & "<br>"
> > >
> > > Anyone who demands that ADODB still be used is not capable of givng
> > > credible technical advice PERIOD and anyone who let the code above
> > get
> > > written and used should not be dispensing technical advice that you
> > > take seriously although diplonmatically you may smile and say
> > thanks
> > > and that you will take the advice but you need to be taling to
> > experts
> > > at places like this not taking yoru cues from someone who does not
> > > understand anything about ADODB..
> > >
> > > http://www.learnasp.com/freebook/learn/cs_dbtable.aspx
> > > shows how to connect to an access DB from C# -- it is first
> > example we
> > > did in class.
> > >
> > > Anything ADO can do ADO.net does 10 x better and faster.
> > >
> > > On Fri, 07 Jan 2005 18:21:28 -0000, scaevola637 <scaevola637@y...>
> >
> > wrote:
> > > >
> > > > I am missing something. I do not see a connection string in
> > any of
> > > > the code. I do not understnad how to get a connection string
> > to the
> > > > com object. I will look at the example.
> > > > You are telling me I can use OLE DB and not have a connection
> > string?
> >
> >
> >
> >
> >
> > ________________________________
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
> >
> > To unsubscribe from this group, send an email to:
> > AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
Joined: 07 Jan 2006
Posts: 63
Sticky Wicket: C#.NET calling ADODB
http://www.learnasp.com/learn/connectioninfo.asp
will tell you what you want.
On Fri, 07 Jan 2005 18:50:15 -0000, scaevola637 <scaevola637@...> wrote:
>
> Charles,
> You alone are the holy one. Thanks, When you speak everything
> becomes flooded with light.
> I know how to do all this using ado.net. Is there any way for me to
> tell what is the name of the sql box on the network all these
> queries are going against? Can I still get premium membership for
> $500?
>
>
> --- In AspNetAnyQuestionIsOk@yahoogroups.com, Charles Carroll
>
> <911@l...> wrote:
> > function OpenAFCPT()
> > set adoAFCPT = server.createobject("ADODB.Connection")
> > adoAFCPT.commandtimeout = dbCommandTimeOut
> > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> > set cmdAFCPT = Server.CreateObject("ADODB.Command")
> > cmdAFCPT.ActiveConnection = adoAFCPT
> > cmdAFCPT.CommandTimeout = dbCommandTimeOut
> > cmdAFCPT.CommandType = adCmdStoredProc
> > end function
> >
> > what you are looking at is a function that opens a connection. It
> is
> > written by someone with very limited programming skills as they
> forgot
> > to return a value from that function.
> >
> > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> >
> > opens the connection
> >
> > you need to find out (by searching code) what the variables are
> > dnsAFCPT = the variable they stuffed the connection string in
> > usrAFCPT = the variable they stuffed the user name in
> > pasAFCPT = the variable they stuffed the user password in
> >
> > adding 3 lines to that code will determine that.
> > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> > response.write "dnsAFCPT=" & dnsAFCPT & "<br>"
> > response.write "userAFCPT=" & userAFCPT & "<br>"
> > response.write "pasAFCPT=" & pasAFCPT & "<br>"
> >
> > Anyone who demands that ADODB still be used is not capable of givng
> > credible technical advice PERIOD and anyone who let the code above
> get
> > written and used should not be dispensing technical advice that you
> > take seriously although diplonmatically you may smile and say
> thanks
> > and that you will take the advice but you need to be taling to
> experts
> > at places like this not taking yoru cues from someone who does not
> > understand anything about ADODB..
> >
> > http://www.learnasp.com/freebook/learn/cs_dbtable.aspx
> > shows how to connect to an access DB from C# -- it is first
> example we
> > did in class.
> >
> > Anything ADO can do ADO.net does 10 x better and faster.
> >
> > On Fri, 07 Jan 2005 18:21:28 -0000, scaevola637 <scaevola637@y...>
>
> wrote:
> > >
> > > I am missing something. I do not see a connection string in
> any of
> > > the code. I do not understnad how to get a connection string
> to the
> > > com object. I will look at the example.
> > > You are telling me I can use OLE DB and not have a connection
> string?
>
>
>
>
>
> ________________________________
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
> AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Joined: 09 Jan 2006
Posts: 27
Sticky Wicket: C#.NET calling ADODB
I ran the code and :
"Provider=MSDASQL.1"
Does this mean there is a box on the network called MSDASQL.1"?
what exactly is provider. I want the equivalent of "server="
> will tell you what you want.
>
>
> On Fri, 07 Jan 2005 18:50:15 -0000, scaevola637 <scaevola637@y...>
wrote:
> >
> > Charles,
> > You alone are the holy one. Thanks, When you speak
everything
> > becomes flooded with light.
> > I know how to do all this using ado.net. Is there any way for
me to
> > tell what is the name of the sql box on the network all these
> > queries are going against? Can I still get premium membership
for
> > $500?
> >
> >
> > --- In AspNetAnyQuestionIsOk@yahoogroups.com, Charles Carroll
> >
> > <911@l...> wrote:
> > > function OpenAFCPT()
> > > set adoAFCPT = server.createobject("ADODB.Connection")
> > > adoAFCPT.commandtimeout = dbCommandTimeOut
> > > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> > > set cmdAFCPT = Server.CreateObject("ADODB.Command")
> > > cmdAFCPT.ActiveConnection = adoAFCPT
> > > cmdAFCPT.CommandTimeout = dbCommandTimeOut
> > > cmdAFCPT.CommandType = adCmdStoredProc
> > > end function
> > >
> > > what you are looking at is a function that opens a
connection. It
> > is
> > > written by someone with very limited programming skills as
they
> > forgot
> > > to return a value from that function.
> > >
> > > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> > >
> > > opens the connection
> > >
> > > you need to find out (by searching code) what the variables
are
> > > dnsAFCPT = the variable they stuffed the connection string
in
> > > usrAFCPT = the variable they stuffed the user name in
> > > pasAFCPT = the variable they stuffed the user password in
> > >
> > > adding 3 lines to that code will determine that.
> > > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> > > response.write "dnsAFCPT=" & dnsAFCPT & "<br>"
> > > response.write "userAFCPT=" & userAFCPT & "<br>"
> > > response.write "pasAFCPT=" & pasAFCPT & "<br>"
> > >
> > > Anyone who demands that ADODB still be used is not capable of
givng
> > > credible technical advice PERIOD and anyone who let the code
above
> > get
> > > written and used should not be dispensing technical advice
that you
> > > take seriously although diplonmatically you may smile and say
> > thanks
> > > and that you will take the advice but you need to be taling
to
> > experts
> > > at places like this not taking yoru cues from someone who
does not
> > > understand anything about ADODB..
> > >
> > > http://www.learnasp.com/freebook/learn/cs_dbtable.aspx
> > > shows how to connect to an access DB from C# -- it is first
> > example we
> > > did in class.
> > >
> > > Anything ADO can do ADO.net does 10 x better and faster.
> > >
> > > On Fri, 07 Jan 2005 18:21:28 -0000, scaevola637
<scaevola637@y...>
> >
> > wrote:
> > > >
> > > > I am missing something. I do not see a connection string
in
> > any of
> > > > the code. I do not understnad how to get a connection
string
> > to the
> > > > com object. I will look at the example.
> > > > You are telling me I can use OLE DB and not have a
connection
> > string?
> >
> >
> >
> >
> >
> > ________________________________
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
> >
> > To unsubscribe from this group, send an email to:
> > AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
Joined: 09 Jan 2006
Posts: 27
Sticky Wicket: C#.NET calling ADODB
I cannot find the link to platinum membership. Is in on the winpro
site?
--- In AspNetAnyQuestionIsOk@yahoogroups.com, Charles Carroll
<911@l...> wrote:
> Paypal me $500 and its a done deal
>
>
> On Sat, 8 Jan 2005 04:13:15 +0900, Charles Carroll
> <charlesmarkcarroll@g...> wrote:
> > http://www.learnasp.com/learn/connectioninfo.asp
> > will tell you what you want.
> >
> >
> > On Fri, 07 Jan 2005 18:50:15 -0000, scaevola637
<scaevola637@y...> wrote:
> > >
> > > Charles,
> > > You alone are the holy one. Thanks, When you speak
everything
> > > becomes flooded with light.
> > > I know how to do all this using ado.net. Is there any way
for me to
> > > tell what is the name of the sql box on the network all these
> > > queries are going against? Can I still get premium
membership for
> > > $500?
> > >
> > >
> > > --- In AspNetAnyQuestionIsOk@yahoogroups.com, Charles Carroll
> > >
> > > <911@l...> wrote:
> > > > function OpenAFCPT()
> > > > set adoAFCPT = server.createobject("ADODB.Connection")
> > > > adoAFCPT.commandtimeout = dbCommandTimeOut
> > > > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> > > > set cmdAFCPT = Server.CreateObject("ADODB.Command")
> > > > cmdAFCPT.ActiveConnection = adoAFCPT
> > > > cmdAFCPT.CommandTimeout = dbCommandTimeOut
> > > > cmdAFCPT.CommandType = adCmdStoredProc
> > > > end function
> > > >
> > > > what you are looking at is a function that opens a
connection. It
> > > is
> > > > written by someone with very limited programming skills as
they
> > > forgot
> > > > to return a value from that function.
> > > >
> > > > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> > > >
> > > > opens the connection
> > > >
> > > > you need to find out (by searching code) what the variables
are
> > > > dnsAFCPT = the variable they stuffed the connection
string in
> > > > usrAFCPT = the variable they stuffed the user name in
> > > > pasAFCPT = the variable they stuffed the user password in
> > > >
> > > > adding 3 lines to that code will determine that.
> > > > adoAFCPT.open dnsAFCPT, usrAFCPT, pasAFCPT
> > > > response.write "dnsAFCPT=" & dnsAFCPT & "<br>"
> > > > response.write "userAFCPT=" & userAFCPT & "<br>"
> > > > response.write "pasAFCPT=" & pasAFCPT & "<br>"
> > > >
> > > > Anyone who demands that ADODB still be used is not capable
of givng
> > > > credible technical advice PERIOD and anyone who let the
code above
> > > get
> > > > written and used should not be dispensing technical advice
that you
> > > > take seriously although diplonmatically you may smile and
say
> > > thanks
> > > > and that you will take the advice but you need to be taling
to
> > > experts
> > > > at places like this not taking yoru cues from someone who
does not
> > > > understand anything about ADODB..
> > > >
> > > > http://www.learnasp.com/freebook/learn/cs_dbtable.aspx
> > > > shows how to connect to an access DB from C# -- it is first
> > > example we
> > > > did in class.
> > > >
> > > > Anything ADO can do ADO.net does 10 x better and faster.
> > > >
> > > > On Fri, 07 Jan 2005 18:21:28 -0000, scaevola637
<scaevola637@y...>
> > >
> > > wrote:
> > > > >
> > > > > I am missing something. I do not see a connection
string in
> > > any of
> > > > > the code. I do not understnad how to get a connection
string
> > > to the
> > > > > com object. I will look at the example.
> > > > > You are telling me I can use OLE DB and not have a
connection
> > > string?
> > >
> > >
> > >
> > >
> > >
> > > ________________________________
> > > Yahoo! Groups Links
> > >
> > > To visit your group on the web, go to:
> > > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
> > >
> > > To unsubscribe from this group, send an email to:
> > > AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
> > >
> > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
> >
Joined: 09 Jan 2006
Posts: 27
Sticky Wicket: C#.NET calling ADODB
On your site this line is:
String constr = "server=(local)\NetSDK;Integrated
Security=SSPI;database=Northwind;provider=sqloledb";
do i put ""Provider=MSDASQL.1...
--- In AspNetAnyQuestionIsOk@yahoogroups.com, Charles Carroll
<911@l...> wrote:
> The person is not making any sense. if what you mean is they want
to
> keep MS access in lace just use System.Data.OleDb instead of
SQLClient
> and talk to Access.
>
>
http://www.learnasp.com/quickstart/howto/doc/adoplus/adorstodataset.a
spx
> shows how to convert a Recordset to a .net style entity
>
> But ADODB recordsets are for ASP code not ASP.net code
>
> Everything that can be done with Recordset is done cheaper and
faster
> with ExecuteReader or DataTables.
>
> On Fri, 07 Jan 2005 16:33:45 -0000, scaevola637 <scaevola637@y...>
wrote:
> >
> > I am converting a web site from classic asp to asp.net
> > The boss wants to keep the ADODB in place until the new sql
database
> > is ready. I want to know is it possible to do this?
> > I never used adodb before. I only know data.sqlclient
> >
> > Let me know if it isp possible to rewrite all the adodb
connections
> > and calls from vbscript to C#. I tried this morning but could
not
> > get the Command.Execute to work
All times are GMT
Page 1 of 2
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help
China Wholesale - Electronics Products
Character Studio - Tutorials and Help