Re: mySQL and ASP, ASP.NET and FP server extension

From: Kevin Spencer (kevin_at_DIESPAMMERSDIEtakempis.com)
Date: 01/20/05


Date: Thu, 20 Jan 2005 08:32:03 -0500

If you're hosted on a Windows server, you can use MS Access, which is free,
and easy to use. By "free" I mean the licensing of using the .mdb database
files, not the Access program.

-- 
HTH,
Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.
"xfile" <cou-cou@remove.nospam.com> wrote in message 
news:OcM9REo$EHA.2076@TK2MSFTNGP15.phx.gbl...
> Hi:
>
> Thanks and it's really informative which would help me to find a even 
> better ISP in the future.
>
> For the SQL web data admin, I have to apologize and confess that I am a 
> true beginner for everything involved in DB.  I downloaded and installed 
> it as another expert had told me a few days ago.  But I don't know how to 
> use it.
>
> When I open it, it just has a box for server configuration and no matter 
> which one I checked, it will just stay there.
>
> And there are just class documentation but no help file, so I was ....
>
> Maybe it's just because I am a rookie.
>
>
> "Yatendra Khandelwal" <yatendra.khandelwal@ishisystems.com.(donotspam)> 
> ¼¶¼g©ó¶l¥ó·s»D:F576818B-298E-4823-B3C7-FFA99D4E3958@microsoft.com...
>> mySql work with asp.net on unix and linux using mono ( 
>> http://www.go-mono.com
>> ) they have a module mod_mono that can work with apche. They also have c# 
>> and
>> vb.net compiler as well as an IDE called MonoDevelope. It supports 
>> ASP.net,
>> ADo.Net etc. One major thing that they do not support is mobile controls. 
>> so
>> most of the asp.net websites can be hosted on apache on linux or unix
>> anyways on windows you can use MSDE with SQL web data administrator (
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en)
>>
>> -Yatendra
>>
>> "xfile" wrote:
>>
>>> Hi:
>>>
>>> Thanks for both of your reply.
>>>
>>> Indeed, I was not thinking mySQL before, because Windows-based platform 
>>> are
>>> usually comes with MS SQL and ASP and so on.  But I have had enough with 
>>> the
>>> technical support of the current ISP and started a new research.
>>>
>>> I found some, as you mentioned, do offer ASP on Unix or Apache server 
>>> and
>>> come with generous offer of mySQL DB.
>>>
>>> I am not using .NET at this point, since I started out the learning not 
>>> too
>>> long ago with ASP.  I did download PHP, mySQL, and PHPAdmin just now and
>>> installed.
>>>
>>> Frankly speaking, my choice of DB is not based on its performance, but 
>>> how
>>> easy it can be learned.  In the case of MS SQL, I still have problem 
>>> finding
>>> a friendly tool to access it, needless to say, get a copy installed in 
>>> the
>>> local machine to learn it.
>>>
>>> Just before finishing this message, my current ISP offered me one mySQL
>>> account instead of MS SQL, which is nice.
>>>
>>> I can use it with current Windows-based platform :)
>>>
>>> Thanks again.
>>>
>>>
>>> "Ronx" <ronx917@hotmail.com>
>>> ???????:%231OYqLj$EHA.3616@TK2MSFTNGP11.phx.gbl...
>>> > mySQL is mostly offered on Unix servers, which do not support ASP.NET, 
>>> > but
>>> > a few do support ASP (either through Chillisoft or iASP).  There are 
>>> > not
>>> > many hosts that offer mySQL on Windows servers.
>>> >
>>> > My own experience with mySQL and ASP on Windows is not promising - 
>>> > success
>>> > in reading data, but not adding records, on one server and total 
>>> > failure
>>> > on another.  In both cases, I used PHPadmin to set the databases up 
>>> > and
>>> > add initial records.  But if you can get the database connection to 
>>> > work,
>>> > it does not matter which database you are using.
>>> >
>>> > FPextensions do not come into the equation, since they do not interact
>>> > with the database at all.
>>> >
>>> > -- 
>>> > Ron Symonds   (Microsoft MVP - FrontPage)
>>> > Reply only to group - emails will be deleted unread.
>>> >
>>> >
>>> > "xfile" <cou-cou@remove.nospam.com> wrote in message
>>> > news:u9pZR5i$EHA.2876@TK2MSFTNGP12.phx.gbl...
>>> >> Hi:
>>> >>
>>> >> Will mySQL work seamlessly well with ASP, ASP.NET, and FP Server
>>> >> Extension?
>>> >>
>>> >> I wish to retain most MS platform except for the DB part, which mySQL 
>>> >> is
>>> >> easily to get and installed on the local machine for development and
>>> >> testing, as well as offered by many ISPs with much less costs.
>>> >>
>>> >> But I am not sure how does it work with the above mentioned scripts, 
>>> >> and
>>> >> appreciate if anyone can advise.
>>> >>
>>> >>
>>> >
>>> >
>>>
>>>
>>>
>
> 


Relevant Pages

  • Re: Using Access for web application?
    ... Any suggestions as to which newsgroup would be more ... The server that the web app will use in this case, ... > which technology you will decide to use as the Web server (Linux or Windows) ... Instead MySQL is being ...
    (microsoft.public.access.dataaccess.pages)
  • RE: ASP, Wscript.Shell on a Windows 2003 Server Web Edition
    ... could have something to do with a different set of server environment/account ... > In this group we typically deal with issues related to migrating Windows ... > migrate the current ASP code to this new environment. ... > In one of the ASP pages, a scheduled task is set up via Wscript.Shell ...
    (microsoft.public.windows.server.migration)
  • Re: Using Access for web application?
    ... My about the server running the web app was stemming from the following ... decision of using Windows or Linux has been made. ... If you are using DreamWeaver and ASP; the fact of using Access or MySQL as ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Recommended Windows Hosts
    ... It can be done (although I don't understand all the server side ... How do you do PHP and ASP on same server? ... "Jim Cheshire" wrote in message ... | You never weighed-in with any recommended hosts for Windows Servers. ...
    (microsoft.public.frontpage.client)
  • Re: Recommended Windows Hosts
    ... How do you do PHP and ASP on same server? ... Jimco is ... | You never weighed-in with any recommended hosts for Windows Servers. ...
    (microsoft.public.frontpage.client)