Switch from MS Access to MySql

[theoryofben]

I designed my site using an MS Access database. But my site will be hosted on a Linux server. So I must use a MySql database. The hosting company has a utility to convert from Access to Sql. I have absolutely no knowledge of MySql. If I convert the database, what changes do I need to make to my ASP pages in dreamweaver? Thanks in advance.

Ben

"Whoever fights monsters, should see to it that in the process, they do not become one."-Friedrich Nietzsche

 

[schase]

PHP not ASP for mySQL "I like a man who grins when he fights."

-- Prime Minister Winston Churchill

Stuart

 

[theoryofben]

Thanks for the response. I've decided to just redo my database in MySql. Since I've already done so much of the site in ASP, and since I don't know anything about PHP, I guess I'll just see what happens when I upload my site. Thanks. Ben

"Whoever fights monsters, should see to it that in the process, they do not become one."-Friedrich Nietzsche

 

[schase]

As far as I know anyhow - I know there are some ASP modules for Apache servers. But I have not had very much luck with them - havnt tried Chilisoft though. "I like a man who grins when he fights."

-- Prime Minister Winston Churchill

Stuart

 

[theoryofben]

Chilisoft is what this server is running. It's through webmasters.com. This is my first foray into a database driven site, so it's kinda like learn as I go. Thanks for the help. Ben

"Whoever fights monsters, should see to it that in the process, they do not become one."-Friedrich Nietzsche

 

[schase]

May the force be with you
"I like a man who grins when he fights."

-- Prime Minister Winston Churchill

Stuart