Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 200003

RE: [PHP3] Remote ODBC From: Andrew Hill (ahill <email protected>)
Date: 03/21/00

Hi folks,

Our odbc_sv agent, as opposed to a databsae specific ones (sql6_sv for
example) allow an ODBC bridge across machine boundries, and allow one to
connect to a third party DSN. This is most useful when trying to connect to
a database that Openlink doesn't support (Lotus Notes) and you do not have a
driver for you client machine (linux) but you do for your database server
(MS Windows)

Folks most commonly use this odbc_sv database agent to connect from linux to
Access, FoxPro, etc., running on Windows, but it will allow _any_ third
party or native driver on the server side. These include native
communication protocols such as SQL*Net, etc.

Here is a breif architecture sketch:

Client box, Openlink Driver ------> Server, Openlink Request Broker ------>
Openlink odbc_sv agent -----> Third party or Native driver ---> Database.

It is an additional layer, and not recommended if you can use a specific
agent directly, but you still get the flexibilty, reporting and rules-based
security that our drivers give you. In addition, this is a way of enforcing
some SQL92 compliance on the back end system.

HTH!

Best regards,
Andrew
----------------------------------------------------
Andrew Hill
Technical Support Consultant
OpenLink Software
http://www.openlinksw.com
Universal Database Connectivity Technology Providers

-----Original Message-----
From: Deirdre Saoirse [mailto:deirdre <email protected>]
Sent: Monday, March 20, 2000 6:41 PM
To: Michael P. Korpics
Cc: php3 <email protected>
Subject: Re: [PHP3] Remote ODBC

On Mon, 20 Mar 2000, Michael P. Korpics wrote:

> Is it possible for make an ODBC connection from a linux box running php
> with apache to an NT machine running Lotus Notes?

Yes, via a driver like OpenLinkSW's ODBC driver for Linux. I've done it to
Sql Server, not sure about support for Lotus Notes, but I don't think
that'll be a problem. 

--
_Deirdre   *   http://www.linuxcabal.org   *   http://www.deirdre.net
       "In /dev/null, no one can hear you scream"

--
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to:
http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>