Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread 4.29+ODBC
Mon, Feb 8 2010 6:04 AMPermanent Link

"Max"
Forgive me my ignorance, it's a quite simple question:

can an external webapp (via internet) obtain the access to my dbisam 4.29b2
local database (on a static ip address pc) via ODBC, launch some queries and
obtain results?
I'm using both password protected tables and a custom engine signatures.

How to?

Greetings
Max
Mon, Feb 8 2010 6:32 AMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

Hi Max,

It will depend upon whether you can install the DBISAM ODBC Driver on
the web server. This is fine if you are hosting your own web server but
most hosting companies will not let you install 3rd part drivers.

I overcame this problem by using a VPS to host my web site (and my data)


Chris Holland
[Team Elevate]

On 08/02/2010 11:04, Max wrote:
> Forgive me my ignorance, it's a quite simple question:
>
> can an external webapp (via internet) obtain the access to my dbisam
> 4.29b2 local database (on a static ip address pc) via ODBC, launch some
> queries and obtain results?
> I'm using both password protected tables and a custom engine signatures.
>
> How to?
>
> Greetings
> Max

--
Mon, Feb 8 2010 6:43 AMPermanent Link

"Max"
> It will depend upon whether you can install the DBISAM ODBC Driver on the
> web server. This is fine if you are hosting your own web server but most
> hosting companies will not let you install 3rd part drivers.
>
> I overcame this problem by using a VPS to host my web site (and my data)

Thanks for your response, Chris.

In my case a customer should query his local database (dbisam 4.29b2,
normally used from a local application) from remote, through a php script on
a linux server.

Ideally, the php script should connect from remote to the odbc driver
(installed on the windows machine, with static ip), query the database and
obtain the results, keeping in mind that tables are encrypted and protected
with a custom engine signature.

My questions:

1) is it viable such a scenario?
2) has the ODBC driver be reconfigured/recompiled to support
encryption/custom signature?

Thanks
Max
Mon, Feb 8 2010 8:52 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Max,

<< Ideally, the php script should connect from remote to the odbc driver
(installed on the windows machine, with static ip), query the database and
obtain the results, keeping in mind that tables are encrypted and protected
with a custom engine signature. >>

So, the ODBC driver will be using a remote connection to connect from the
PHP web server machine to another Windows machine that is running a DBISAM
Database Server ?

<< 1) is it viable such a scenario? >>

Yes, certainly.

<< 2) has the ODBC driver be reconfigured/recompiled to support
encryption/custom signature? >>

Yes, it can re-compiled to support custom encryption and signatures.

As of 4.28 and higher, we now include a utility called the ODBC Driver
Configuration Utility (dbodbccfg.exe) in the \utils subdirectory of the
DBISAM ODBC Driver installation directory that allows you to configure the
driver to use custom configurations with file extensions, etc.  I can see
about modifying the driver and the utility to add support for custom
signatures and encryption passwords, thus saving you from having to
recompile the driver.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image