My apologies if  i am in the wrong group...

As you can see from the snippet below i am using standard php odbc stuff to
connect to a dbisam odbc dsn.  Works fine. However.... is it possible to get
the DSN to point to a different catalog ( by using some parameters ) ?. Or
do I need to create a DSN for every catalog I wish to go to ?


Ed..

<?PHP

  $db_user        = "chmgr";
  $db_pass        = "chmgr";
  $dsn =        'DSN=dbisamGps;';
  $conn=odbc_connect($dsn, $db_user, $db_pass);
  $sql="SELECT surname FROM clients";
  $rs=odbc_exec($conn,$sql);
?>

Ed,

Use a fully qualified connection string instead of the DSN.
i.e.

$connect_id = odbc_connect("DRIVER={DBISAM 4 ODBC Driver};
ConnectionType=Remote;
UID=user;
PWD=user;
CatalogName=dbisam;
RemotePort=12005;
RemoteIPAddress=192.168.0.11",'','',SQL_CUR_USE_ODBC);

I broke it into pieces, but it would be expressed as one unbroken line,
or a series of concatenated line segments.

Nick

----------------------------------
"Edhrx" <ed@synergynewmedia.co.uk> wrote:

My apologies if  i am in the wrong group...

As you can see from the snippet below i am using standard php odbc stuff to
connect to a dbisam odbc dsn.  Works fine. However.... is it possible to get
the DSN to point to a different catalog ( by using some parameters ) ?. Or
do I need to create a DSN for every catalog I wish to go to ?


Ed..

<?PHP

  $db_user        = "chmgr";
  $db_pass        = "chmgr";
  $dsn =        'DSN=dbisamGps;';
  $conn=odbc_connect($dsn, $db_user, $db_pass);
  $sql="SELECT surname FROM clients";
  $rs=odbc_exec($conn,$sql);
?>

Ed,

This is an example from an application that is running using the built-in ODBC local data engine ...
no connection to a CS engine required ...


$connect_string ="DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Local;CatalogName="._sitebase."\PSCSVIEW\sc".$tgtyr.";";
$connect_id = odbc_connect($connect_string,'','',SQL_CUR_USE_ODBC);

Notes:
_sitebase is a defined constant associated with the current runtime environment
$tgtyr is a parameter being used to select a data content subdirectory


Nick

Nick,

many thanks works well

ed..


"Schoeneck (Nick) Howell" <showell bop gov> wrote in message
news:28D9882E-714D-48C6-95CD-8D2C40359734@news.elevatesoft.com...
> Ed,
>
> This is an example from an application that is running using the built-in
ODBC local data engine ...
> no connection to a CS engine required ...
>
>
> $connect_string ="DRIVER={DBISAM 4 ODBC
Driver};ConnectionType=Local;CatalogName="._sitebase."\PSCSVIEW\sc".$tgtyr."
;";
> $connect_id = odbc_connect($connect_string,'','',SQL_CUR_USE_ODBC);
>
> Notes:
> _sitebase is a defined constant associated with the current runtime
environment
> $tgtyr is a parameter being used to select a data content subdirectory
>
>
> Nick
>

Hello,

Could you please put the code to connect php to dbisam over odbc.


Thanks.

<< Could you please put the code to connect php to dbisam over odbc. >>

You would simply use the correct connection string along with the proper
odbc_connect() PHP code:

http://www.php.net/manual/en/function.odbc-connect.php

The connection strings for the DBISAM ODBC Driver are detailed here:

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4odbc&topic=Connection_Strings

--
Tim Young
Elevate Software
www.elevatesoft.com