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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Fri, 21 Jan 2005 10:13:46 +0800

Hi:

Thanks for your kind information.
I finally remember where SqlWebAdmin in my www root came from ( i deleted it
later and forgot where did it come from due to failed tries too many times).

I will try your steps again and thanks a lot.

Initially, I was trying to learn and use (at later time) MS SQL (apart from
its performance) for two main reasons: (1) I "believe" MS SQL can work
better with MS Access especially for migration and/or work in conjunction.
Nothing else, just because they are in one family, and (2) My ISP already
offered me one MS SQL account to be used.

But during the past week of searching tools, I was so frustrated that seems
all MS SQL tools are for fee-basis. As a beginner and light user, I can't
and won't pay the cost. Besides, my ISP only provides help for setting up
the account and won't care if and how we use it or know how to use it.

So I finally turned to MySQL for consideration (along the time was searching
a possible new ISP). I then found out MySQL is free to download and does
come with or provided by others with many free GUI tools - especially
important for a rookie like me.

So I downloaded and installed MySQL on my local machine, and asked my ISP if
they can switch MS SQL to MySQL for my account (that is the reason I posted
this message initially). And they did.

Now I have set up MySQL on local with PHP and phpmyAdmin and the last one is
also used by my ISP (and many others), so I have successfully created a
table on the ISP account as well as on my local machine.

The next step is to learn and to do migration and so on, and I already
imported some testing Access DB data to MySQL. In short, I am getting to
see the picture now.

For the MS SQL part, I guess I am still at the ground level, thinking about
how to set up a tool.

As a beginner, I am hesitate to use all commands to do all database tasks,
such as creating DB, tables, fields, and so on. The good thing about Access
is easy to use, and I am getting used to those GUI or sort of web-based
interface.

So in summary, I try to use MS SQL if I can set up a tool to access and
managing ISP account in two days (my last try and tolerance). If not, I will
use MySQL with MS Access. My approach (as an amateur) is to use Access to
come up a ground design of the DB (since it has more templates available)
and then try to export it to SQL DB.

That's about it.

Thanks again, and really appreciate your help.

"Yatendra Khandelwal" <yatendra.khandelwal@ishisystems.com.(donotspam)> ¼¶¼g©ó¶l¥ó·s»D:2AF5C19A-B70B-43EA-AC54-27BF3379C27C@microsoft.com...
> hi,
> just install it in program files where it prompts you to. it will
> automaticallt create a virtual directory named 'webadmin'. neways its
> really
> strange but the compiled code of sql web data admin is an older buggy
> version. but good thing is it comes with the code. say you installed it in
> 'C:\Program Files\Microsoft SQL Server Tools\Microsoft SQL Web Data
> Administrator' you can find its code in 'C:\Program Files\Microsoft SQL
> Server Tools\Microsoft SQL Web Data Administrator\Samples\SqlWebAdmin'
> just
> open the project file build it and change the directory that virtual
> directory 'webadmin' points to, to this directory or add another virtual
> directory pointing to this one and use that. that woked for me. neways
> what
> database are you trying to use it with?? MSDE??
>
> "xfile" wrote:
>
>> 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