Re: mySQL and ASP, ASP.NET and FP server extension
From: xfile (cou-cou_at_remove.nospam.com)
Date: 01/21/05
- Next message: xfile: "Re: mySQL and ASP, ASP.NET and FP server extension"
- Previous message: xfile: "Re: mySQL and ASP, ASP.NET and FP server extension"
- In reply to: xfile: "Re: mySQL and ASP, ASP.NET and FP server extension"
- Next in thread: xfile: "Re: mySQL and ASP, ASP.NET and FP server extension"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 21 Jan 2005 11:38:39 +0800
For the very first time, I can see the default page of the web
datamanagement.
I am still learning how to use it, but it works just exactly as you said,
created a virtual directory and pointed to the sources of files and it has
done.
No, it did not create a virtual directory for me, and I wonder why. Now I
know how to makes it work and maybe I shall remove and reinstall it again to
see if such VD will be created.
Many many thanks to you.
"xfile" <cou-cou@remove.nospam.com>
???????:ueOet61$EHA.1904@TK2MSFTNGP14.phx.gbl...
> 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)>
> ???????: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.
>>> >>>> >>
>>> >>>> >>
>>> >>>> >
>>> >>>> >
>>> >>>>
>>> >>>>
>>> >>>>
>>> >>
>>> >>
>>> >
>>> >
>>>
>>>
>>>
>
>
- Next message: xfile: "Re: mySQL and ASP, ASP.NET and FP server extension"
- Previous message: xfile: "Re: mySQL and ASP, ASP.NET and FP server extension"
- In reply to: xfile: "Re: mySQL and ASP, ASP.NET and FP server extension"
- Next in thread: xfile: "Re: mySQL and ASP, ASP.NET and FP server extension"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
