Add MySQL Database to Frontpage Site

Ok, first off I am a TOTAL newbie in the PHP/MySQL area. I've designed sites in Frontpage and used the Database wizard for a Access database in the past but this is got me stumped.

Problem: The hosting company I'm with now does NOT support .ASP so I'm forced to use MySql database that they provide.
I am making a site and need to have a simple box for the visitor to add their email address and click a submit button, have that add to the database. I was trying to add the SQL database to the site but it comes back with a error:

Server error: Unable to connect to a database from the Web server using the connection string 'DRIVER={SQL Server};SERVER=supremecenter.com;DATABASE=dezigns_ database;UID=********;PWD=********'.

The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)

The hosting company is about worthless and I dont expect any kind of answer there so I searched the net and found you guys. Can anyone help? I'll probably need it spelled out for me, Sorry

have a look at the following tutorial, as it may shed some light on your problem.

http://www.databasejournal.com/features/php/article.php/10898_1469211_1

I assume that you are also going to have to re-code all your .ASP pages in .PHP, so here is a link to the PHP site as well.

http://www.php.net

Take a look and if you have more questions, let us know.

You should specify more exactly what you need. You made your site in Frontpage. So it is only html site? Why is it important that your providare stoped to support ASP? Or will you remake your site in PHP and do you need to know how to connect to your database in PHP?

It's a new site I'm building now. It's in standard HTML so far. I've been playing with some PHP scripts to add to the site (ex. PHPBB forum) And gotten those to work, but not as "part" of the site its self yet. But again the site I'm working on is HTML.

They didn't drop .ASP, just dont offer it. I wans't aware of that when I bought the year of hosting.

Specifing what I need (thought I had sorry) is to find out what I'm doing wrong when I try to connect to the MySQL server in my Frontpage site. (You know, make a form, add a database.... Netwoek Database.. SQL....) It adds it but it's a broken link, I try to verify and get the erro messag eI posted before.

One other thing... At this point I have a database set up on the server, it's already got stuff in it from the Forum I was tinkering with. The page I'm working on wasn't .ASP yet becaus eI'd not added the form. I made the form, set up the database as I usualy do and when I went to post found that the server doens't support .ASP so I started looking for a solution

Ok, so if links posted by Blindeddie will not help, you should probably post code where you try to connect to database.

Found the problem.

I was doing it right, the Hosting company does not support outside connections to the database.

Ok, its fine you did it