Re: Using ADOdb to connect to Zenworks DBs

I use adodb to connect zenworks sybase databases successfully.

$dbdriver = 'sqlanywhere';
$server = 'corpzen.teamfishel.com';
$user = 'mw_dba';
password = 'novell';
$database = 'nal';

include('adodb/adodb.inc.php');

$dsn = "Driver=Adaptive Server Anywhere 8.0;".
			 "CommLinks=tcpip(Host=$server);".
			 "ServerName=$server;".
			 "DatabaseName=$database;".
			 "uid=$user;pwd=$password";

$db  = NewADOConnection($dbdriver);
$db->debug = true;
$db->Connect( $dsn )
$rs = $db->Execute('select * from T_Info');

Hy.

Stuart Beckett ha scritto:
> hello,
>  
> Has anyone had any luck in connecting to Zenworks Sybase databases?  I 
> have just tried the ADOdb and it seems to just hang.
>  
> Here is the code that I am using:
>  
>  <?php  // This php section is for defining variables and connecting 
> with ADO to sybase server
>  
>     $dbdriver = 'sybase_ase';
>     $server = 'corpzen.teamfishel.com';
>     $user = 'mw_dba';
>     $password = 'novell';
>     $database = 'nal';
>  
>     include('adodb/adodb.inc.php');
>     $db = ADONewConnection($dbdriver); # eg 'mysql' or 'postgres'
>     $db->debug = true;
>     $db->Connect($server, $user, $password, $database);
>     $rs = $db->Execute('select * from T_Info');
>  
>  ?>
> Any help would be appreciated
>  
> Thanks
>