dbTalk Databases Forums  

accesing SQL Base with PHP

comp.databases.gupta comp.databases.gupta


Discuss accesing SQL Base with PHP in the comp.databases.gupta forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
augustose
 
Posts: n/a

Default accesing SQL Base with PHP - 06-16-2006 , 09:00 PM






I finaly connected SQL Base with PHP.

Have some one experience about it ?

does any one use it ?

Regards,
Augusto Sosa Escalada


Reply With Quote
  #2  
Old   
AT
 
Posts: n/a

Default Re: accesing SQL Base with PHP - 06-22-2006 , 09:54 AM






Dear Mr. Escalada,

it is possible to access SQLBase from PHP.

We use the following method:
1. ODBC driver from SQLBase
2. System data source with the above ODBC driver (It is important to
use system data sources - computer data sources doesn't work!)
3. PEAR-DB in PHP

The connection string is:
odbc://<User>:<Password>@<DSN>/<DB>

<User> = Username and <Password> = password (e.g. SYSADM:SYSADM)
<DSN> is the name of your ODBC data source and <DB> is the wished
database you want to be connected with.

Here a short PHP-Script:

require_once "DB.php";
$dsn = 'odbc://SYSADM:SYSADM@CenturaDB/Test';
$conn = DB::connect($dsn, TRUE);
if (!DB::isError($conn))
{
// Perform some actions....
$conn->disconnect();
}
else
{
print "Connection error..."
}

Hope it helps.
With the best regards from Germany

Dr. Klaus-Dieter Remmler


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.