Using php to connect to sevice manager

Dev Shed Forums Sponsor:

April 10th, 2006, 05:05 PM

chrisjokinen

Registered User

Join Date: Apr 2006

Location: Houston, Tx

Posts: 28

Time spent in forums: 6 h 53 m 51 sec
Reputation Power: 0

Using php to connect to sevice manager

Hello All,

I need to know if anyone has used the php function ibase_service_attach ( string host, string dba_username, string dba_password )

This is used to access the service manager needed in another function called ibase_add_user(). The manual does not have any information about its use. I have figured out that the function has an implied tcp connect so I have been tried setting the host parameter to 'localhost:service_mgr', this gives me the message:

Quote:

Warning: ibase_service_attach() [function.ibase-service-attach]: Cannot attach to services manager service service_mgr:service_mgr is not defined in C:\Program Files\Abyss Web Server\htdocs\dbAccess.php on line 18

ideas?

Thank You in advance

April 11th, 2006, 02:45 AM

pabloj

Modding: Oracle MsSQL Firebird

Dev Shed God 6th Plane (7500 - 7999 posts)

Join Date: Jun 2001

Location: Outside US

Posts: 7,907

Time spent in forums: 2 Months 3 Weeks 3 Days 9 h 21 m 6 sec
Reputation Power: 279

Seems to work for me

php Code:

Original - php Code
<?php $ibservhandler = ibase_service_attach ( 'localhost', 'sysdba', 'masterkey' ) or die (ibase_errmsg()); ?>

<?php
$ibservhandler = ibase_service_attach ( 'localhost', 'sysdba', 'masterkey' ) or die (ibase_errmsg());
?>

__________________
My blog
Tutorials about OSS databases, DBMonster ...
Contribute to OSS Development, fill bug reports!
Developer Shed eSupport
Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK)
An introduction to database normalization
Natural or Surrogate key
Custom ordering for your results
Correlated and uncorrelated subqueries
Don't turn your outer joins into inner joins
Random data (with a bias)

April 11th, 2006, 05:56 AM

pabloj

Modding: Oracle MsSQL Firebird

Join Date: Jun 2001

Location: Outside US

Posts: 7,907

Time spent in forums: 2 Months 3 Weeks 3 Days 9 h 21 m 6 sec
Reputation Power: 279

A better example, taken from ibWebAdmin source code:

php Code:

Original - php Code
<?php // get server version and implementation strings if (($service = ibase_service_attach('localhost', 'sysdba', 'masterkey')) != FALSE) { $server_info = ibase_server_info($service, IBASE_SVC_SERVER_VERSION) . ' / ' . ibase_server_info($service, IBASE_SVC_IMPLEMENTATION); ibase_service_detach($service); } else { $ib_error = ibase_errmsg(); } echo $server_info; ?>

<?php
    // get server version and implementation strings
    if (($service = ibase_service_attach('localhost', 'sysdba', 'masterkey')) != FALSE) {
        $server_info  = ibase_server_info($service, IBASE_SVC_SERVER_VERSION) 
                      . ' / '
                      . ibase_server_info($service, IBASE_SVC_IMPLEMENTATION);
        ibase_service_detach($service);
    }
    else {
        $ib_error = ibase_errmsg();
    }
echo $server_info;   
?>

Which in my case echoes

Quote:

WI-T2.0.0.12484 Firebird 2.0 Release Candidate 1 / Firebird/x86/Windows NT

April 11th, 2006, 11:55 AM

chrisjokinen

Registered User

Join Date: Apr 2006

Location: Houston, Tx

Posts: 28

Time spent in forums: 6 h 53 m 51 sec
Reputation Power: 0

Well that did work well. I think I'll add a note to the online php docs so another user does not have the same issues and lose a day and a half hunting for an answer.

Thanks Alot

Comments on this post

pabloj agrees!

April 11th, 2006, 12:01 PM

pabloj

Modding: Oracle MsSQL Firebird

Join Date: Jun 2001

Location: Outside US

Posts: 7,907

Time spent in forums: 2 Months 3 Weeks 3 Days 9 h 21 m 6 sec
Reputation Power: 279

Quote:

Originally Posted by chrisjokinen

Well that did work well. I think I'll add a note to the online php docs so another user does not have the same issues and lose a day and a half hunting for an answer.

Thanks Alot

Please do it.
Thanks

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: