Re: Can one call an Access database on computer using the IP address?
- From: Adam <anon@xxxxxxxxxxx>
- Date: Sat, 30 Jul 2005 17:59:14 +1200
On 29 Jul 2005 20:11:16 -0700, NC wrote:
>lkrubner@xxxxxxxxxxxxx wrote:
>>
>> An old friend of mine recently approached me and said something like:
>> "I've a computer at my office that has an Access database running on
>> it. We've most of our company info in there. We'd like to put a portion
>> of it online as a dynamic site, but we don't want the database to leave
>> our office. Our office is connected to the Internet through a static
>> IP. Can you do it?"
>>
>> I said no, but I also said I'd look into it. Could a PHP script running
>> on a web server make a call to that database to get info? How does that
>> work?
>
>Sounds doable with ODBC, as other posters have noted already. Define
>the Access DB as an ODBC source, have the server running PHP connect
>via ODBC. Security would obviously be an issue, and, possibly, so
>would performance. The way the task is defined right now, ASP may
>end up delivering better performance compared to a non-Microsoft
>solution such as PHP.
I haven't used ASP for a while, but I have created a few ODBC/PHP
sites. None of them have been *mega* busy sites and performance was
absolutely no problem.
I suspect that, as it will only be available to a select few <??> then
performance (with respect to concurrent users) wouldn't be much of a
problem. The only differences may occur if your d/b is *huge* - but
then carefully designed queries can still help.
Adam.
.
- Follow-Ups:
- References:
- Prev by Date: Re: including file and output to browser
- Next by Date: Re: best php auction software???
- Previous by thread: Re: Can one call an Access database on computer using the IP address?
- Next by thread: Re: Can one call an Access database on computer using the IP address?
- Index(es):
Relevant Pages
|
