Converting from asp to php

Hi-

I am trying to convert content on a site from asp to php. First I downloaded asp2php and converted all asp files. then I converted all the mdb files to sql.

Now, this site has been moved to a new server because the old webguy was unresponsive. On this new server, you need to create databases (name, user, pass) for php to function properly. So my question is this:

Where do I find the database name, user & pass word that these files are using to work. I'm guessing that they are in the sql files but when I look into them there are many id's, user, pass. Should there be one global database? Or do I need to set up separate ones for each of these?

Am I on the right path here at all? I've tried looking up how to convert but all websites point to asp2php and then that is it. Clearly that is not it. I haven't found a site that discusses a full move and conversion.

Anyone have some insight or direction?

Thanks
Frankie

I think using a tool like asp@php is not the right answer. I'm sure it is a great tool but it's just not the right way to set up a website. It might work, but stable it will not be. Not to mention maintenance.

Usernames and passwords could be anywhere. Are you talking about the ones to access the site, or to access the database?

The user names and passwords I am talking about are the ones that were created by the end users. this site has a bb, photo album & family tree. Its a nightmare.

Anyway, there were several mdb files that i converted to sql files. then I uploaded the php and sql files onto a new server. This server uses phpadmin and it requires that you enter a database name and then create a u&p for that database. My question is, Can I create any database name and then import all those sql files into that database or do each of those sql files already have a database name, u&p attached to them (thus allowing them to speak with the server)?? And if the later, How do I uncover what the original name was.

Do a site-wide string search using a robust text editor like Dreamweaver or Edit Plus. You're looking for a string along these lines:

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\path\filename.mdb; User ID=userName; Password=thisPass;