mySQL and ASP, ASP.NET and FP server extension

X

xfile

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.
 
K

Kevin Spencer

MySQL is an ODBC-compliant database product. As such, it can be used as a
data source with the FrontPage Database tools, ASP, and ASP.Net. Seamlessly?
Well, that's largely up to you. And how you define "seamless."

However, from your question, I'm suspicious that your web site is hosted on
a Unix/Linux/Apache server. If so, you won't be able to use ASP or ASP.Net,
and hence, you won't be able to use FrontPage to write your code for you.
You will have to look at other server-side technologies, such as PHP, for a
solution.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
 
R

Ronx

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.
 
X

xfile

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.
 
Y

Yatendra Khandelwal

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/...98-c57a-419e-acbc-2a332cb7f959&displaylang=en)

-Yatendra
 
X

xfile

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.
 
K

Kevin Spencer

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.
 
X

xfile

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.
 
Y

Yatendra Khandelwal

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??
 
X

xfile

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.
 
X

xfile

Just an update:

For the very first time, I finally had a chance to see what does it look
like of my SQL database at the ISP site.

Yes, it took sometime (maybe Internet connection), but I can log in to ISP's
SQL database and see the one I have. I also see there are import, export,
query, and so on functions at there, so I am really going to learn it soon.

Many thanks again :)
 
K

Kevin Spencer

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

Don't know. I've never used it. I've always used SQL Enterprise Manager, or
Access, to manage SQL Server databases. You might want to check out Access
for interfacing with a SQL Server. The Access Database Project is just that.
As you're familiar with the Access interface, this makes working with SQL
Server more "familiar."

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
 
X

xfile

Hi Thanks!!!

Got it, still testing, but never knew about it.

Thanks for all the helps from all of you :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

asp.net programmer 4
MySQL & FP 7
Access, ASP and PHP, MySQL confussion 6
Frontpage and ASP.NET 10
FP 2003 and Mysql 1
Testing a New Website. (ASP / ASP.net) 5
dynamic web templates. 4
ASP.NET vs. FP 2003 ? 9

Top