MySQL Connection Using HTML

[fdsouth]

I'm trying to have my web page post certain database entries depending on a user modified SELECT statement. I got everything working fine on my computer at home running NT and PWS. I was using .ASP and VBScript to accomplish this.

When I went to post it to my ISP it wouldn't work. The ISP told me that the "free webspace" they provide for their customers is on a UNIX machine which can't process .ASP pages. OK, so I migrated the Access database to MySQL which is compatible with UNIX. How do I change my script to connect to the MySQL database and run the SELECT statement?

 

[Cagliostro]

try some changes in the DSN connection string
"driver = {MySQL};....." John Fill

ivfmd@mail.md

 

[steve1]

The previous answer is not an answer to the problem.

Your REAL problem is probably that it is legally probably impossible. It is VERY rare, at best, that free services give you ANY access to dynamic pages.

As for the UNIX thing? This is what M/S REALLY wants! To trick guys like you into doing non standard things, so you end up using THEIR products. The fact is that ASP servers for UNIX DO exist, like chilisoft. Unfortunately, the chances of your host having that are also probably unlikely.

UNIX IS better for services like this. Why?

More Standard.
Not a monopoly, so it won't change on a whim.
Better remote access.
Better browser support.
DLLS won't cause problems.
Scales better.
Cheaper.
Better security verification, and faster fixes.
Better support.
an Industry standard dating back to 1969! WOW, I was only a kid!

The following techniques are provided by MOST UNIX hosts, that provide ANY utility to create dynamic scripts:

PHP -- the ASP equivalent. An HTTP scripting language.
PERL -- An O/S scripting language MADE for reports, that is the most widely supported HTML generation language. Whole programs can be replaced by a few lines of code.

Less popular:

JSP -- A special scripting language that looks like ASP, but works like JAVA and is compiled as able. It uses a special JSP server. (look at tomcat for apache)
JAVA -- You know about this, right? A general programming language more commonly used for applets, but also used for servletts.

BTW, you can get ALL of the above for FREE, and it runs on Windows AND UNIX! What a concept, huh!

Steve