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

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: xfile (cou-cou_at_remove.nospam.com)
Date: 01/20/05 

Date: Fri, 21 Jan 2005 07:49:43 +0800

Hi:

Thanks, and that's what I am doing now :)

I always have Access with the Office programs from version 1.0 although I
don't use it much at all.

In addition to it's free, it also has nice wizard for DB that is commonly
used for personal or small business, such as contact management which is the
one I am using now.

But I found out recently, that scripting language (SQL specifically) is not
"quite" the same for Access and other more heavy-weight DB, such as MS SQL
and so on.

For example, I just learned that "store procedures" is the "query" in Access
and its query is not identical to the query meant by others. Of course,
there are other minor syntax differences. Also, thinking ahead, the
ultimate goal is to open up an online store, which I would doubt if Access
is enough.

For the above two reasons, and since I am new to learn this, I thought it
would be better for me to learn and start to use some sort of heavy-weight
DB.

Just one more question and appreciate if anyone could help:

Should I install SQL web data administrator into program files as other
applications or into inetpub/www?

I have installed, removed, and reinstalled and checked as many articles from
the net as possible, but still could not figure out how to properly use it.

One article says, it's pretty easy and just type"
http://webserver/webadmn/default.aspx after installation. Well, it did not
work.

If I copied and pasted the web folder from program files to www after
installation, and make the new folder in the web root as a FP sub web, it
gives me configuration error which I don't know how to correct.

If I retain it in its original folder, I've got another obvious error, can't
find the file.

I am really frustrated by this. By setting up mySQL and phpmyadmin is
somewhat less troublesome.

Anyway, thanks in advance.

"Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com>
???????:e8fvuRv$EHA.3424@TK2MSFTNGP11.phx.gbl...
> 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)>
>> ???????: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: HELP with OE
    ... Do point 3a below and then do a File | Folder | Compact all in OE. ... and then compact manually and frequently using File ... affect the ability of your antivirus software to block infections. ... Most of the problems with a faulty installation are due to other programs ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Compacte Files - Reading them
    ... > file to a backup folder. ... and then compact manually and frequently using File ... affect the ability of your antivirus software to block infections. ... Most of the problems with a faulty installation are due to other programs ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Sent items lost !
    ... I can see this folder contains all of the sent items cause it's ... Cannot Open E-Mail Attachments in Outlook Express After You Install SP1 ... affect the ability of your antivirus software to block infections. ... Most of the problems with a faulty installation are due to other programs ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: HELP with OE
    ... Do point 3a below and then do a File | Folder | Compact all in OE. ... and then compact manually and frequently using File ... affect the ability of your antivirus software to block infections. ... Most of the problems with a faulty installation are due to other programs ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Lost Mail Folder
    ... Search for *.dbx and *.dbt. ... If you find the file that corresponds to the folder, try running DBXpress or DBXtract on it. ... affect the ability of your antivirus software to block infections. ... Most of the problems with a faulty installation are due to other programs ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)