PHP COM for access

Dev Shed Forums Sponsor:

December 3rd, 2002, 02:02 PM

crazytrain81

Always Learning

Join Date: Oct 2002

Location: Port Neches, TX, USA

Posts: 1,173

Time spent in forums: 3 Days 7 h 45 m 43 sec
Reputation Power: 14

PHP COM for access

Seem to be having permissions trouble (best guess) getting some com stuff to work.

PHP Code:


		
			
 $db = new COM("ADODB.Connection") 

      or die("Could not start ADO"); 

$db->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\inetpub\wwwroot\accessDB\testDB.mdb;") 

      or die("Could not open connection");

I get "Could not open connection". The database file permissions are full control/everyone. in dcomcnfg, everyone has access to launch apps and special access in default configuration permissions. and everyone has full control on the folder as well.

This is 2k adv server btw, intel, newest php version.

In the path, it cuts out the backslashes , but they're there =)

__________________
David Fells
If my post helped you, please click the

above my post and leave a comment. Thanks

December 3rd, 2002, 02:48 PM

kicken

Wiser? Not exactly.

Join Date: May 2001

Location: Bonita Springs, FL

Posts: 5,551

Folding Points: 1493480 Folding Title: Super Ultimate Folder - Level 3

Time spent in forums: 2 Months 2 Weeks 15 h 7 m 7 sec
Reputation Power: 3285

My guess is that since you said devshed it cutting the back slashes, you are using something like this with a double backslash before the filename to avoid php thinking \t is a tab.

$db->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\inetpub\wwwroot\accessDB\\testDB.mdb;");

What you need to do, is use double backslashes everywhere, or use single quotes, so php will actually use the \ literally rather than take them out as escape characters.

PHP Code:


		
			
 $db->Open('Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\\inetpub\\wwwroot\\accessDB\\testDB.mdb;');

December 3rd, 2002, 02:56 PM

crazytrain81

Always Learning

Join Date: Oct 2002

Location: Port Neches, TX, USA

Posts: 1,173

Time spent in forums: 3 Days 7 h 45 m 43 sec
Reputation Power: 14

That wasn't the problem, I had the code there correct in my program, it was a permissions thing. New problem though =()

I run a query but can't print any results.

PHP Code:


		
			
 $db = new COM("ADODB.Connection") 

      or die("Could not start ADO"); 

$db->Open("testDB"); 

      or die("Could not open connection");



$rs = $db->execute("SELECT * FROM news")

          or die("Query Failed");

            

while (!$rs->EOF) {

      $user = $rs->Fields('user');

        print $user->value;

}



$rs->close();

$db->close();

No output. There is 1 row of data in the table.

December 3rd, 2002, 03:54 PM

pabloj

Modding: Oracle MsSQL Firebird

Dev Shed God 8th Plane (8500 - 8999 posts)

Join Date: Jun 2001

Location: Outside US

Posts: 8,526

Time spent in forums: 3 Months 1 Week 1 Day 3 h 1 m 2 sec
Reputation Power: 534

Why don't you simply use php's odbc functions? They seem to work well!

__________________
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)

December 3rd, 2002, 04:07 PM

crazytrain81

Always Learning

Join Date: Oct 2002

Location: Port Neches, TX, USA

Posts: 1,173

Time spent in forums: 3 Days 7 h 45 m 43 sec
Reputation Power: 14

never used them before, and i'm familiar with ADO from working in asp

December 3rd, 2002, 07:32 PM

micros_bytes

Contributing User

Join Date: Oct 2002

Posts: 790

Time spent in forums: 10 h 29 m 56 sec
Reputation Power: 13

I was able to connect to and query fields from an Access DB using the following code.

PHP Code:


		
			
 $db = new COM("ADODB.Connection");

$db->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\\inetpub\\wwwroot\\myDB\\JobSearch.mdb");

$rs = $db->execute("SELECT * FROM company");



 while (!$rs->EOF) {

      $user = $rs->Fields('Company');

        print $user->value."<br>\r\n";

          $rs->movenext();

}

$rs->close();

$db->close();

You may be able to get the results you're looking for by adding the $rs->movenext() to your while loop. The way you have it coded right now, it's only going to return the first record every time it loops through the recordset. If the field you're trying to print happens to be blank in that first record, you're not going to get anything.