|
|
Posted by Jerry Stuckle on 05/09/06 14:32
windandwaves wrote:
> Hi Folk
>
> I have been asked to create an e-commerce website, where we need to
> connect to an SQL database. The database is used to run their POS in
> several branches. As this database is on the company server and we are
> hosting the website with a webhost we have to solve an communication
> issue.
>
> Here are the options that I can see:
>
> a. create a branch like environment on the webserver and then directly
> access the branch database (OBDC??)
>
> b. run a script that sucks data from the SQL environment and then ftps
> it as a text file to a LAMP server. PHP and Mysql (my preferred
> platform), will then notice the new file and do something with it?
>
> c. have a direct OBDC connection between the website and the company's
> server
>
> What option do you recommend? What difficulties do you see?
>
> I would love to get some ideas from you and more ideas on the typical
> problems.
>
> TIA
>
> Nicolaas
>
Nicolaas,
Too little information for what you're asking.
What database are they going to have on their company server? Do they want you
to have direct access to this server (possible security issues)? How often is
the database updated? Do they need live data? If not, how old can the data be
and still be valid?
There are any number of possibilities beyond what you're asking. But there's
way too many variables to even have a reasonable list of possibilities.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|