PHP and a MSSQL database

[cwgeary]

Hi all, I am new to the site and was hoping to get some help here. I spent all day a work searching for an answer and was unable.

We use Deltek's Wind2 FMS for our accounting software. I don't want to modify the database only access it. The database has a main database called our company name. When I go into crystal reports to see where the information is linked to it has other databases. For example, one database is Wind2 Billing. When I go into my ODBC links, the Wind2 Billing is listed as a Visual Fox Pro. The main database is a MS sql database. My question is how do I access those database that is listed as a FoxPro? Any help would be appreciated or if you know where I could access the information, I would greatly appreciate it.

Thanks and great site!

Chris

[TheServant]

Well, I fail to see how this is php related? Did you plan on accessing the database using php? I don't know any of the database's you've listed, and if noone here does, you will have a much better chance posting in one of the databases forums on this site.

If you do want to do it with php, please post the code you have (whether it works or not) and we'll try and give you a hand.

[Atli]

Hi Chris. Welcome!

Visual FoxPro, appears to be some sort of a scripting language made by Microsoft, which includes it's own version of a SQL database. Read more about it here.

I have never heard of this before now and I doubt very much this can be used with, or by, PHP in any standard way.

For the MS SQL databases, however, check out PHP.net's manual on Microsoft SQL Server functions. (mssql_next_result has some example code you can check out to).

Hope this helps you in some way :)