[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 167
  • Last Modified:

How to provide data from windows database to php website

Hi, I have a database running in a windows environment and currently use VB.net 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.

Thanks
0
nicksbell
Asked:
nicksbell
  • 2
  • 2
1 Solution
 
Raynard7Commented:
Hi,

I'm not sure what your dilemma is,

you can always use the http://au.php.net/mssql - 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.
0
 
nicksbellAuthor Commented:
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?
0
 
Raynard7Commented:
it is possible - alternativley can you create a vpn or ssl connection to the database on the windows box?
0
 
nicksbellAuthor Commented:
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.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now