473,326 Members | 2,023 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

A fairly new person at ASP.

Hey,

I'm a fairly new person at ASP, and MS technologies kinda in general.
I've been a big fan of PHP/MySQL, and unix environments for awhile. I
used to do VC++ and VB with VS6, and have for the most part no
experience at all with the .net framework.

To expand my knowledge, I'm hoping to get into ASP some - and to learn
VB.net and C# as well, to program in ASP. I was hoping that I could
ask a few questions that I had kinda right off, that I couldn't really
find the answer to in my ASP.net 2.0 Unleashed book, that I recently
bought.

The first question is about editors and compiling. Coming from a
unixtypeish background, I enjoy using more unix editors than windows
ones. This is mostly just personal preference, but is there ways of
doing ASP.net 2.0 pages and compile them from the command line (From
what I understand asp pages are compiled into a microsoft intermediate
language). I have VS.net, though, 2002 I think it was from the
university but I haven't really used it much.

The second question is about databases. I have experience mostly with
MySQL overall, and have it already setup on my mac. I'm running
windows through parallels workstation, which emulates a machine for the
most part. I was hoping not to increase the overhead of my setup if
possible - are there classes or anything available for connecting to a
MySQL database, over an SQL server one? I want to get experience in
both of course, but at this point I just want to take more baby steps
kinda.

Thanks for any help anyone can give on these questions, I really appreciate it.

-David

Jul 22 '06 #1
15 1250
The first question is about editors and compiling. Coming from a
unixtypeish background, I enjoy using more unix editors than windows ones.
This is mostly just personal preference, but is there ways of doing
ASP.net 2.0 pages and compile them from the command line (From what I
understand asp pages are compiled into a microsoft intermediate language).
I have VS.net, though, 2002 I think it was from the university but I
haven't really used it much.
You must have the .NET Framework on any machine where you will develop or
run .NET applications. The Framework comes with command line compilers for
each of the .NET languages, so yes, you could use any editor you wish and
manually compile.
The second question is about databases. I have experience mostly with
MySQL overall, and have it already setup on my mac. I'm running windows
through parallels workstation, which emulates a machine for the most part.
I was hoping not to increase the overhead of my setup if possible - are
there classes or anything available for connecting to a MySQL database,
over an SQL server one? I want to get experience in both of course, but
at this point I just want to take more baby steps kinda.
The are ODBC and OLEDB classes to access any ODBC or OLEDB compliant data
source. There are also dedicated SQL data classes.
One other minor note. To distinguish from the old ASP (now called "Classic
ASP" by many), the ASP that you work with in .NET is referred to as ASP.NET,
not ASP. Some folks will get confused if you mean .NET, but just say ASP
and not ASP.NET.

Jul 22 '06 #2

Użytkownik "Scott M." <s-***@nospam.nospamnapisał w wiadomo¶ci
news:OY**************@TK2MSFTNGP02.phx.gbl...
>The first question is about editors and compiling. Coming from a
unixtypeish background, I enjoy using more unix editors than windows
ones. This is mostly just personal preference, but is there ways of doing
ASP.net 2.0 pages and compile them from the command line (From what I
understand asp pages are compiled into a microsoft intermediate
language). I have VS.net, though, 2002 I think it was from the university
but I haven't really used it much.

You must have the .NET Framework on any machine where you will develop or
run .NET applications. The Framework comes with command line compilers
for each of the .NET languages, so yes, you could use any editor you wish
and manually compile.
I agree up to a point. In fact you do not need .Net Framework installed on
your machine
until you write script files. It is possible to write script file on Unix
system,
transfer it onto IIS web server and run. Pre-compiled dll files are not
required
in most cases, so you do not need any .net compiler on workstation.

Of course there is also .Net Framework available on Unix systems (the most
known
on Free BSD).
--
JS
BRE Bank Dev Team, Poland
Jul 22 '06 #3
"Scott M." <s-***@nospam.nospamwrote in message
news:OY**************@TK2MSFTNGP02.phx.gbl...
There are also dedicated SQL data classes.
Yes, but only because the people who make SQL Server also make the .NET
Framework. :-)

There are loads of native .NET data providers for other databases available

http://www.sqlsummit.com/DataProv.htm

including for mySQL.

http://dev.mysql.com/downloads/connector/net/1.0.html
http://www.connectionstrings.com/
Jul 22 '06 #4
I agree up to a point. In fact you do not need .Net Framework installed on
your machine
until you write script files. It is possible to write script file on Unix
system,
transfer it onto IIS web server and run. Pre-compiled dll files are not
required
in most cases, so you do not need any .net compiler on workstation.
But, let's be realistic. Without the .NET Framework, you might as well just
stick to Classic ASP, since you won't get to use any of the .NET classes or
work with compiled code.

While it is *possible* to create .aspx files and have them run without the
Framework, it is not realistic.
Jul 22 '06 #5
>There are also dedicated SQL data classes.
>
Yes, but only because the people who make SQL Server also make the .NET
Framework. :-)
What's your point?
There are loads of native .NET data providers for other databases
available
Well, they really aren't native, since they aren't included natively with
the .NET Framework. The Framework comes with the following *native*
providers

ODBC, OLE DB, Oracle, SQL
Jul 22 '06 #6
Well, they really aren't native, since they aren't included natively with
the .NET Framework. The Framework comes with the following *native*
providers

ODBC, OLE DB, Oracle, SQL
Incorrect. A "native provider" is a provider that works directly with the
database software, rather than via OLE DB OR ODBC, both of which are
intermediate technologies that provide a single unified programming API for
many database types. In fact, ODBC itself is a wrapper for OLE DB, which is
a low-level intermediate technology. The Hierarchy is something like this:

System.Data.ODBC
****************
|
ODBC (with specific database driver)
|
OLE DB
|
OLE DB-compliant Database

System.Data.OleDb
***************
|
OLE DB
|
OLE DB-compliant Database
When a native .Net data provider is used, the connection to the database is
immediate:

System.Data.SqlClient
*****************
|
SQL Server

System.Data.OracleClient
********************
|
Oracle

Therefore, a native provider is more efficient than either OLE DB or ODBC.
--
HTH,

Kevin Spencer
Microsoft MVP
Professional Chicken Salad Alchemist

What You Seek Is What You Get.
"Scott M." <s-***@nospam.nospamwrote in message
news:uD*************@TK2MSFTNGP04.phx.gbl...
>>There are also dedicated SQL data classes.

Yes, but only because the people who make SQL Server also make the .NET
Framework. :-)

What's your point?
>There are loads of native .NET data providers for other databases
available

Well, they really aren't native, since they aren't included natively with
the .NET Framework. The Framework comes with the following *native*
providers

ODBC, OLE DB, Oracle, SQL

Jul 23 '06 #7
Agreed. My use of the term *Native* was referring to *built-into* the
framework.
"Kevin Spencer" <uc*@ftc.govwrote in message
news:OY**************@TK2MSFTNGP05.phx.gbl...
>Well, they really aren't native, since they aren't included natively with
the .NET Framework. The Framework comes with the following *native*
providers

ODBC, OLE DB, Oracle, SQL

Incorrect. A "native provider" is a provider that works directly with the
database software, rather than via OLE DB OR ODBC, both of which are
intermediate technologies that provide a single unified programming API
for many database types. In fact, ODBC itself is a wrapper for OLE DB,
which is a low-level intermediate technology. The Hierarchy is something
like this:

System.Data.ODBC
****************
|
ODBC (with specific database driver)
|
OLE DB
|
OLE DB-compliant Database

System.Data.OleDb
***************
|
OLE DB
|
OLE DB-compliant Database
When a native .Net data provider is used, the connection to the database
is immediate:

System.Data.SqlClient
*****************
|
SQL Server

System.Data.OracleClient
********************
|
Oracle

Therefore, a native provider is more efficient than either OLE DB or ODBC.
--
HTH,

Kevin Spencer
Microsoft MVP
Professional Chicken Salad Alchemist

What You Seek Is What You Get.
"Scott M." <s-***@nospam.nospamwrote in message
news:uD*************@TK2MSFTNGP04.phx.gbl...
>>>There are also dedicated SQL data classes.

Yes, but only because the people who make SQL Server also make the .NET
Framework. :-)

What's your point?
>>There are loads of native .NET data providers for other databases
available

Well, they really aren't native, since they aren't included natively with
the .NET Framework. The Framework comes with the following *native*
providers

ODBC, OLE DB, Oracle, SQL


Jul 23 '06 #8
"Scott M." <s-***@nospam.nospamwrote in message
news:eI**************@TK2MSFTNGP02.phx.gbl...
Agreed. My use of the term *Native* was referring to *built-into* the
framework.
I can't help that...

v1.0 didn't have either "native" or "built-in" support for ODBC - instead,
it was available only as an add-on.
Jul 23 '06 #9
The ODBC Namespace and the classes therein have been part of the .NET
Framework since the beginning. Using it did not require any add-ins.
"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:Oq**************@TK2MSFTNGP03.phx.gbl...
"Scott M." <s-***@nospam.nospamwrote in message
news:eI**************@TK2MSFTNGP02.phx.gbl...
>Agreed. My use of the term *Native* was referring to *built-into* the
framework.

I can't help that...

v1.0 didn't have either "native" or "built-in" support for ODBC - instead,
it was available only as an add-on.

Jul 23 '06 #10
"Scott M." <s-***@nospam.nospamwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
The ODBC Namespace and the classes therein have been part of the .NET
Framework since the beginning.
Er...you sure...?
>Using it did not require any add-ins.
Apart, obviously, from the one you had to download from the Microsoft site
and install separately...
http://www.microsoft.com/downloads/d...displaylang=en

And then set about configuring machine.config manually, etc...
Jul 23 '06 #11
On 2006-07-22 17:57:30 -0500, "Scott M." <s-***@nospam.nospamsaid:
>I agree up to a point. In fact you do not need .Net Framework installed
on your machine
until you write script files. It is possible to write script file on
Unix system,
transfer it onto IIS web server and run. Pre-compiled dll files are not
required
in most cases, so you do not need any .net compiler on workstation.

But, let's be realistic. Without the .NET Framework, you might as well
just stick to Classic ASP, since you won't get to use any of the .NET
classes or work with compiled code.

While it is *possible* to create .aspx files and have them run without
the Framework, it is not realistic.
Thanks to both of you for your help in answering this question. In the
end, I'll probably just create a mount location to that directory, and
edit files that way, then run them. To my understanding that should
work, even if the debugging doesn't work fully.

Jul 23 '06 #12
On 2006-07-23 13:31:58 -0500, "Scott M." <s-***@nospam.nospamsaid:
The ODBC Namespace and the classes therein have been part of the .NET
Framework since the beginning. Using it did not require any add-ins.
"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:Oq**************@TK2MSFTNGP03.phx.gbl...
>"Scott M." <s-***@nospam.nospamwrote in message
news:eI**************@TK2MSFTNGP02.phx.gbl...
>>Agreed. My use of the term *Native* was referring to *built-into* the
framework.

I can't help that...

v1.0 didn't have either "native" or "built-in" support for ODBC -
instead, it was available only as an add-on.
Thanks to all of you for the help on this, and the answers to my
questions. It's a little over my head right now, hopefully within a
few months I'll understand ASP better. I got ASP .net 2.0 unleashed
yesterday, and it's a pretty good book - a bit over my head since I
dont' know VB.net or C#.net at all at this point. I used to use VB6
and VC++ 6, but not this.

Thanks again,

David

Jul 23 '06 #13
If you look at the publish date of the add-in you refer to, you will see
that it pre-dates the public release of VS.NET 2002.

Installing VS.NET 2002 gives you the 1.0 Framework and the ODBC provider is
available immediately.

"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:O2**************@TK2MSFTNGP05.phx.gbl...
"Scott M." <s-***@nospam.nospamwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>The ODBC Namespace and the classes therein have been part of the .NET
Framework since the beginning.

Er...you sure...?
>>Using it did not require any add-ins.

Apart, obviously, from the one you had to download from the Microsoft site
and install separately...
http://www.microsoft.com/downloads/d...displaylang=en

And then set about configuring machine.config manually, etc...

Jul 23 '06 #14
"Scott M." <s-***@nospam.nospamwrote in message
news:ul****************@TK2MSFTNGP04.phx.gbl...
If you look at the publish date of the add-in you refer to, you will see
that it pre-dates the public release of VS.NET 2002.
LOL!
Installing VS.NET 2002 gives you the 1.0 Framework and the ODBC provider
is available immediately.
<rolls eyes>

http://support.microsoft.com/default...b;en-us;310985

Read the paragraph which begins "The ODBC .NET Data Provider is an add-on
component to the Microsoft .NET Framework..." very slowly and carefully, one
word at a time...

Here's another one: http://www.akadia.com/services/dotnet_dbaccess.html

Scroll down to point 6, and read aloud the paragraph beginning "Unlike the
two other .NET providers, the Odbc provider is not shipped with the .NET
Framework..."
Jul 23 '06 #15
I have read each of the articles, but neither addresses the point that we're
talking about the status of the Framework during the pre-release period.
"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:ev**************@TK2MSFTNGP02.phx.gbl...
"Scott M." <s-***@nospam.nospamwrote in message
news:ul****************@TK2MSFTNGP04.phx.gbl...
>If you look at the publish date of the add-in you refer to, you will see
that it pre-dates the public release of VS.NET 2002.

LOL!
>Installing VS.NET 2002 gives you the 1.0 Framework and the ODBC provider
is available immediately.

<rolls eyes>

http://support.microsoft.com/default...b;en-us;310985

Read the paragraph which begins "The ODBC .NET Data Provider is an add-on
component to the Microsoft .NET Framework..." very slowly and carefully,
one word at a time...

Here's another one: http://www.akadia.com/services/dotnet_dbaccess.html

Scroll down to point 6, and read aloud the paragraph beginning "Unlike the
two other .NET providers, the Odbc provider is not shipped with the .NET
Framework..."

Jul 23 '06 #16

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Remco Groot Beumer | last post by:
Hello I've created an ASP.NET page, which uses some variables which are set after login. When person A logs in, a new public object is instanced (i'm not sure if that is a correct word), after...
5
by: Jason | last post by:
I am running Exchange 2003 on a Windows 2003 Active Directory. I am trying to mailbox-enable a user account with VB.NET. Dim person As CDO.Person Dim mailbox As CDOEXM.IMailboxStore person =...
12
by: john_sips_tea | last post by:
I've got a fairly substantial webapp written in Java (plus Tomcat, Hibernate, Struts, JSP, MySQL) that is a bit of a bear to work with. I didn't write it. Much of it is only very sparsely...
26
by: Martin Jřrgensen | last post by:
Hi, I don't understand these errors I get: g++ Persort.cpp Persort.cpp: In function 'int main()': Persort.cpp:43: error: name lookup of 'j' changed for new ISO 'for' scoping Persort.cpp:37:...
1
by: Jamie J. Begin | last post by:
I'm very new to the world of Python and am trying to wrap my head around it's OOP model. Much of my OOP experience comes from VB.Net, which is very different. Let's say I wanted to create an...
21
by: phpCodeHead | last post by:
Code which should allow my constructor to accept arguments: <?php class Person { function __construct($name) { $this->name = $name; } function getName()
3
by: mProgramz | last post by:
//Specification: This program plays a version of //the card game of 21. //A human player is pitted against the computer. //The player who is the closest to 21 without //going over wins the hand. ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.