Connection to ACT 2007 by PhP

[JordaneUK]

Hello,

I need to know whether there is any solution to connect the ACT database (ACT7) by PhP.
I have tried to create an ODBC connection but it failed.

Thank you all,

Regards,

Jordane.

 

[GLComputing]

Read only access or Read/Write?

Read Only access can be done via OLEDB (not ODBC) or directly bu purchasing the Actreader utility

Read/Write access can only be done by a .Net development platform and the ACT! SDK.

What exactly are you trying to do?

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[JordaneUK]

Hi Mike,

It's for a Read only access only.
I just need to get some data and put them on the website.

I'll try to set up an OLEDB connection.

Thanks a lot,

Regards,

Jordane.

 

[GLComputing]

This might help -

http://itdomino.act.com/act.nsf/docid/14023

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[JordaneUK]

Thank you for the link!

I have encountered a problem.
I tried to connect my database via PhP, however it seemed to be quite difficult.

I use ADODB (a PhP plugin) for accessing my database via OLEDB (ADO DB).
However I need a Provider and a Driver that I don't know exactly.
This is an example of my script:

<?php
include('..\adodb\adodb.inc.php');
print "<h1>Connecting DSN-less...</h1>";
$db = &ADONewConnection("ado_mssql");
$myDSN="PROVIDER=????;Driver={????};DBQ=C:\\ACT Data\\Databases\\act9demo.pad;DATABASE=ACT9demo;UID=Chris Huffman;PWD=;";
$db->Connect($myDSN);

print_r($db);

$rs = $db->Execute("select * from TBL_CONTACT");
$arr = $rs->GetArray();
print_r($arr);
?>


Thank you for all!

 

[GLComputing]

Sorry, I haven't used ADODB... if you can get it working, contact corp sales about the ACTReader utility and access the ACT! SQL tables directly

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[JordaneUK]

Hi Mike,
Just to let you know:
I have finally succeeded in connecting my ACT database (read-only) through PhP via the ADODB library.

Here are the settings needed:
Host = '127.0.0.1';
User ID = 'Chris Huffman;
Password = '';
Data Source = 'C:\...\ACT9demo.pad';
Provider = 'ACTOLEDB.1';

Thanks for all!

 

[GLComputing]

Chris Huffman is the Demo Database user

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[JordaneUK]

Yes,
So he is the perfect example!