[AccessD] Learning .Net -- PHP Instead?

Shamil Salakhetdinov shamil at smsconsulting.spb.ru
Tue Jun 23 12:15:53 CDT 2009


Hi Jim,

Most of the below tasks can be solved using built-in .NET and ASP.NET
features (starting ASP.NET 2.0) provided back-end database will be MS SQL.
I'd not try to "reinvent the wheel" here - have a look:

http://msdn.microsoft.com/en-us/library/yh26yfzy.aspx

I have working experience with that technology, and we can try to get your
tasks solved and developed as a set of sample generic components within our
(dba-VB) http://northwind.codeplex.com project.

The current attempt to develop there on http://northwind.codeplex.com a
(follow-up to Winform's Northwind.NET) WPF and SilverLight NorthWind sample
applications was only supported  by Gustav and Arthur but the team of three
people (including myself) is not enough for that WPF and SilverLight
project, thus it's on hold currently.

We can solve your tasks in "lazy mode" this summer time - let we try?
(Current guess here is that there should be less than 200-300 custom code
lines (not counting .aspx markup) to solve all five tasks but there will be
quite some reading/learning/testing/trying...).

Thank you.

--
Shamil

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Tuesday, June 23, 2009 9:03 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Learning .Net -- PHP Instead?

Shamil and Eric:

I am working on standardizing logging in to a web network. The item to
complete is:

1. Login interface with username, password, captcha and add if new user. 
2. Adding MS SQL server for validating passwords, allow no more than 8
incorrect attempts.
3. For new users, page for getting credentials. When completed final part of
validation will be to send new applicant a security coded email with a two
day time-out.
4. Validate new user acceptance email back and allowing limited access.
5. A system to monitor user logins and duration and pages viewed.

This interface has to be so designed as it can float anywhere on a website
page and perform and monitor all the above required tasks. I would like the
code to be generic and flexible enough to be easy to insert in any site with
a backend... So this module will need a full set of admin accessible
profiles. It is not to say that it will be for anyone but a programmer but
it should make my life easier.

There are of course some issues (a lot) I am having and some of my fixes
seem to be generating longer lists of errors rather the fixing anything.

As mentioned before I will have to put this project aside as I have recently
received a paying gig in MS Access...

When I get another chance and have resolved some of the basic issues I will
be asking some more point questions.

MTIA

Jim   

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eric Barro
Sent: Monday, June 22, 2009 7:09 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Learning .Net -- PHP Instead?

Jim,

What exactly is not working with your ASP.NET app?

Eric 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Monday, June 22, 2009 11:01 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Learning .Net -- PHP Instead?

Hi Arthur:

A very good reference site to get you started... and you do not have to be a
Class expert... to use the code... at least not right away. Fortunately for
me when ever I dabble in the language my son-in-law, who is a true guru in
the language, can resolve a problem which may take two today's to resolve on
my own, with one or two comments. (He works with the language 60 hours a
week and has been at it for years.)

ASP.Net is not anymore difficult, it is just that there is very few
passionate mentors out there, willing to spend their time freely, answering
the 'dumb' questions of a newbie, (I need another son-in-law mastering and
working in ASP.Net.) not like PHP which seems to have a very active
community willing to help. (JAVA is another such community...)

As ASP.Net matures I am sure a similar active community will evolve... but
it is not there yet. Microsoft has been doing its best to spread the word
with such cooperative sites as CodePlex, an open source community but it has
limited resources and is in business to make money.

Steering programmers into a brave new world is nearly as difficult as
getting rid of the ridiculous qwerty keyboard. 

So here I sit wondering why a simple password and new member sign-up module,
in ASP.Net is not working as planned... ;-)     

Jim


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Monday, June 22, 2009 9:48 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Learning .Net -- PHP Instead?

Anyone interested in following Ken's lead here is invited to visit
www.artfulsoftware.com and investigate our chapters on PHP and TheUsual().
Arthur

On Mon, Jun 22, 2009 at 12:37 PM, Kenneth Ismert <kismert at gmail.com> wrote:

> If you are interested in Web programming, I would suggest PHP. Per 
> unit of effort, I think most VBA programmers would get further with 
> PHP than with ASPX, especially if you are starting out from scratch.
>
> I'm developing a SOAP-based web service that will be used by Access
clients
> running the COM-based SOAP Library 3.0. The server backend is being
written
> in PHP, currently running under a local IIS7 development server. It is 
> stupid-simple to implement a SOAP server using PHP's built-in library. 
> It was lots harder getting the VBA side to work than the PHP side. 
> (The real challenge was getting a WSDL specification that both sides 
> could agree on, but that is a separate topic.)
>
> PHP Plusses:
>
> * Of all open-source languages, PHP is the closest to VBA in it's feel 
> and philosophy -- a pragmatic language that lets you get results fast
> * PHP 5.2+ works very well with Windows -- it installs with little 
> fuss under IIS7, and has native drivers for SQL Server
> * The upcoming release, 5.3, offers some very nice language 
> enhancements, like namespaces, late static binding, and closures. It even
adds goto!
> These
> features bring it up to rough parity with scripting languages like 
> Python or Ruby, and make it a much more expressive language than VBA.
> * There is an enormous ecosystem of open-source libraries, IDEs, CMS 
> sytems, and MVC frameworks to choose from.
> * Projects developed under Windows/IIS should work with little or no 
> changes under Linux/Apache.
>
> PHP Drawbacks:
>
> * PHP is a web-specific language. If you want something 
> general-purpose, use something else.
> * PHP's libraries are extensive and rapidly improving, but it doesn't 
> have the monolithic library integration that .NET enjoys with the CLR.
> * Comprehensive, transparent support for Unicode is still lacking, as 
> it
is
> with most scripting languages. PHP 6 will rectify this.
>
> -Ken
> aseadvisors.com <http://www.databaseadvisors.com>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4179 (20090622) __________

The message was checked by ESET NOD32 Antivirus.

http://www.esetnod32.ru






More information about the AccessD mailing list