How to provide data from windows database to php website

Posted on 2007-08-02
Last Modified: 2013-12-12
Hi, I have a database running in a windows environment and currently use to access data in the database.  I have a situation where I need to provide data from the database to a web server (in a separate location/data centre) which is Unix based using PHP.  Cab anyone suggest a secure way that this can be done.

Question by:nicksbell
    LVL 35

    Accepted Solution


    I'm not sure what your dilemma is,

    you can always use the - sql server extensions, or if it is mysql or access there are similar libraries for php to contact the database,

    This is a platform independant library.

    Or - are you suggesting that the link between the unix box and the windows one needs to be secure? in which case I would use .net to create a web service that pre-processes the data, goes to the database and returns result sets for php to format.
    LVL 2

    Author Comment

    yes, it definitely needs to be secure.  Previously, to provide data to an external windows environment I have used .Net remoting (actually something called GenuineChannels which provides additional security and encryption functionality).  I don't think this is possible as GenuineChannels doesn't support Unix/Linux.  Is it possible to use encryption through a windows service?
    LVL 35

    Expert Comment

    it is possible - alternativley can you create a vpn or ssl connection to the database on the windows box?
    LVL 2

    Author Comment

    I don't want to go the vpn route as access may be offered to other clients in the future and I want to keep connectivity simple without having to worry about vpn clients etc.  SSL is a possibility, although I'm new to that area so will have to do some research.

    Thanks for your help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
    Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now