ODBC idiot questions

[Judd Pickell]

Yes you will need some form of a server running, is Pervasive.SQL a server
style SQL solution or client type (like Access)? If it is a server based
one, then you don't need a bridge, just the ODBC client installed in your
UnixODBC setup (not sure how to do it as I haven't messed with UnixODBC
much).

Otherwise if Pervasive is like Access, you may need the bridge. However, if
that is the case, you could look at samba mounting the location of the
database so you can use the UnixODBC with the Pervasive.SQL ODBC client.

Sincerely,
Judd Pickell

On 12/12/06, fouldragon at aol.com <fouldragon at aol.com> wrote:
>
> The situation:
>
> I'm writing an app for a Linux (PHP) webserver which needs to speak to a
> Pervasive.SQL database (technically, the database from Sage Businessworks
> Gold v6) which sits on a Windows box.  (Yes, groan, but it's one of those
> 'client has their entire life in this database and will not be removed with
> a crowbar' situations)
>
> I've done some database work, but never before had to speak to a
> non-remote database.
>
> Pervasive.SQL speaks 'ODBC' apparently, and my copy of PHP was compiled to
> enable UnixODBC support.
>
> Question:
>
> In order to get the app speaking to the Windows box's database, it seems
> like I need something like the 'ODBC-ODBC Bridge driver' installed -- server
> on the Windows box, client on the Linux box(
> http://www.easysoft.com/products/data_access/odbc_odbc_bridge/index.html )
>
> Is this correct?  Or is there an alternative?  GBP 700 seems an awful lot.
>
> Also, I assume there's no problem having two distinct databases in play--
> a local MySQL one which stores additional information, and this remote one
> (which is honestly being queried just to find out current inventory)?
>
> Anything else I should know going in?
>  ------------------------------
> *Check out the new AOL*<http://pr.atwola.com/promoclk/1615326657x4311227241x4298082137/aol?redir=http%3A%2F%2Fwww%2Eaol%2Ecom%2Fnewaol>.
> Most comprehensive set of free safety and security tools, free access to
> millions of high-quality videos from across the web, free AOL Mail and more.
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change  you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20061212/90781f1f/attachment.htm