RE: [PHP-DB] microsoft access
Hi Trevor ODBTP is a technology that allows you to remotely access a Win32 machine's ODBC facilities to connect to a database. IF provides faster and more advanced support for ODBC than PHP's native support. For example, ODBTP connects to a database using ODBC 3, while PHP's native ODBC support uses ODBC 2. -- bob On Fri, 1 Oct 2004, Gryffyn, Trevor wrote: > Thanks for the clarification, Bob. ADOdb is one of those things that I > use, but don't really think about much so terms like "abstraction layer" > didn't come immediately to mind. So in the interest of not sounding > like a dumbass and using the wrong terms, I just kept my response vague > :) > > At any rate, COM is still going to require Access to be installed. ODBC > I have experience with, so that sounds like the best route for general > use. And I have no experience with odbtp, so can't really judge on that > one. > > Anyway, thanks again Bob, input is goood. > > -TG > > > -Original Message- > > From: Robert Twitty [mailto:[EMAIL PROTECTED] > > Sent: Friday, October 01, 2004 2:27 PM > > To: Gryffyn, Trevor > > Cc: [EMAIL PROTECTED]; Matt M.; Matthew Perry > > Subject: RE: [PHP-DB] microsoft access > > > > > > ADODB is a PHP abstraction layer class. In other words it > > hides the fact > > that it is using the odbc extension to connect to Access. And, it has > > another driver that uses the COM extension to connect to Accesss > > (ado_access). > > > > Basically there are only 3 options for connecting to Access > > from PHP. They > > are odbc, COM and odbtp. So, the comparison must be done > > amongst them, and > > not with an abstraction layer that uses them. > > > > -- bob > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] microsoft access
Thanks for the clarification, Bob. ADOdb is one of those things that I use, but don't really think about much so terms like "abstraction layer" didn't come immediately to mind. So in the interest of not sounding like a dumbass and using the wrong terms, I just kept my response vague :) At any rate, COM is still going to require Access to be installed. ODBC I have experience with, so that sounds like the best route for general use. And I have no experience with odbtp, so can't really judge on that one. Anyway, thanks again Bob, input is goood. -TG > -Original Message- > From: Robert Twitty [mailto:[EMAIL PROTECTED] > Sent: Friday, October 01, 2004 2:27 PM > To: Gryffyn, Trevor > Cc: [EMAIL PROTECTED]; Matt M.; Matthew Perry > Subject: RE: [PHP-DB] microsoft access > > > ADODB is a PHP abstraction layer class. In other words it > hides the fact > that it is using the odbc extension to connect to Access. And, it has > another driver that uses the COM extension to connect to Accesss > (ado_access). > > Basically there are only 3 options for connecting to Access > from PHP. They > are odbc, COM and odbtp. So, the comparison must be done > amongst them, and > not with an abstraction layer that uses them. > > -- bob > > On Fri, 1 Oct 2004, Gryffyn, Trevor wrote: > > > I'm guessing that COM is going to be overkill for this. I > thought some > > systems like ADOdb let you get to Access tables directly > without COM. > > > > I'm imaginging that COM might not always be a viable way to > go anyway, > > if you have an Access .MDB file on a server where your PHP stuff is > > hosted, they probably don't have Access installed on their > server (why > > would they?). > > > > If I have time later, I'll double-check ADOdb and such, but I'd look > > into something like that before I'd use COM. > > > > -TG > > > > > -Original Message- > > > From: Matt M. [mailto:[EMAIL PROTECTED] > > > Sent: Friday, October 01, 2004 11:54 AM > > > To: Matthew Perry > > > Cc: [EMAIL PROTECTED] > > > Subject: Re: [PHP-DB] microsoft access > > > > > > > > > > Does anyone know of a good online source for using php > and microsoft > > > > access. > > > > I don't want to have to use asp. > > > > Thank you for your time. > > > > > > you could use com objects with Microsoft ADO > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] microsoft access
ADODB is a PHP abstraction layer class. In other words it hides the fact that it is using the odbc extension to connect to Access. And, it has another driver that uses the COM extension to connect to Accesss (ado_access). Basically there are only 3 options for connecting to Access from PHP. They are odbc, COM and odbtp. So, the comparison must be done amongst them, and not with an abstraction layer that uses them. -- bob On Fri, 1 Oct 2004, Gryffyn, Trevor wrote: > I'm guessing that COM is going to be overkill for this. I thought some > systems like ADOdb let you get to Access tables directly without COM. > > I'm imaginging that COM might not always be a viable way to go anyway, > if you have an Access .MDB file on a server where your PHP stuff is > hosted, they probably don't have Access installed on their server (why > would they?). > > If I have time later, I'll double-check ADOdb and such, but I'd look > into something like that before I'd use COM. > > -TG > > > -Original Message- > > From: Matt M. [mailto:[EMAIL PROTECTED] > > Sent: Friday, October 01, 2004 11:54 AM > > To: Matthew Perry > > Cc: [EMAIL PROTECTED] > > Subject: Re: [PHP-DB] microsoft access > > > > > > > Does anyone know of a good online source for using php and microsoft > > > access. > > > I don't want to have to use asp. > > > Thank you for your time. > > > > you could use com objects with Microsoft ADO > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] microsoft access
I'm guessing that COM is going to be overkill for this. I thought some systems like ADOdb let you get to Access tables directly without COM. I'm imaginging that COM might not always be a viable way to go anyway, if you have an Access .MDB file on a server where your PHP stuff is hosted, they probably don't have Access installed on their server (why would they?). If I have time later, I'll double-check ADOdb and such, but I'd look into something like that before I'd use COM. -TG > -Original Message- > From: Matt M. [mailto:[EMAIL PROTECTED] > Sent: Friday, October 01, 2004 11:54 AM > To: Matthew Perry > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] microsoft access > > > > Does anyone know of a good online source for using php and microsoft > > access. > > I don't want to have to use asp. > > Thank you for your time. > > you could use com objects with Microsoft ADO > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] microsoft access
> Does anyone know of a good online source for using php and microsoft > access. > I don't want to have to use asp. > Thank you for your time. you could use com objects with Microsoft ADO -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] microsoft access
A very good solution for connecting to an MS Access database is the odbtp extension. You can get it at http://odbtp.sourceforge.net. It provides support for many of Access's features, such as UNICODE text data and query processing, and stored query execution. An example on how to connect to a MS Access database is located at http://odbtp.sourceforge.net/storedqry_php.html. There are also odbtp drivers available for the PHP database abstraction layers ADODb and PEAR DB. I would not recommend using the odbc extension with MS Access. The ODBC driver for MS Access is not thread-safe. Thus, it may cause unpredictable results if your script is run under IIS or Apache 2. The odbc extension is also considerably slower, and less capable in regards to MS Access. The odbtp ext will allow you to remotely connect to your Access database from any platform, such as Linux, Solaris, MacOS X and Novell. -- bob On Thu, 30 Sep 2004, Matthew Perry wrote: > Does anyone know of a good online source for using php and microsoft > access. > I don't want to have to use asp. > Thank you for your time. > > Matthew Perry > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] microsoft access
On Thu, 30 Sep 2004 23:53:38 -0400, Bastien Koert <[EMAIL PROTECTED]> wrote: > Here is a basic connect script. I would stringly recommend against using > access, use mysql instead. Or Firebird -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] microsoft access
Here is a basic connect script. I would stringly recommend against using access, use mysql instead. // Program to test connecting to a Microsoft Access ODBC Data Source $connection = odbc_connect("postcard", "", ""); print "Connected to datasource"; if ($result = odbc_exec($connection, "SELECT * FROM postcard")) print "Command executed successfully"; else print "Error while executing command"; // Print results while(odbc_fetch_row($result)) print odbc_result($result, 1) . " " . odbc_result($result, 2) . " " . odbc_result($result, 3) . " " . odbc_result($result, 4) . " " . odbc_result($result, 5) . ""; odbc_close($connection); print "Connection closed."; ?> bastien From: Matthew Perry <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] microsoft access Date: Thu, 30 Sep 2004 21:28:48 -0500 Does anyone know of a good online source for using php and microsoft access. I don't want to have to use asp. Thank you for your time. Matthew Perry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ MSNĀ® Calendar keeps you organized and takes the effort out of scheduling get-togethers. http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines Start enjoying all the benefits of MSNĀ® Premium right now and get the first two months FREE*. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Microsoft Access & PHP
Correction on that, I removed the wrong parentheses: "SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of Paper], ExamPapers.Course, ExamPapers.School, ExamPapers.Year, ExamPapers.Jan/Summer], ExamPapers.[Module Code], ExamPapers.Stage, ExamPapers.[Storage Location], ExamPapers.[Add to Webpage] FROM ExamPapers WHERE (ExamPapers.School=\"Colour and Imaging Institute\" AND ExamPapers.[Add to Webpage]=True)"; HTH Maureen Maureen <[EMAIL PROTECTED]> said: > If you are putting this in a web page, I assume you are putting quotes around > the select statement. If so, are you escaping the quotes around "Colour and > Imaging Institute" by putting \"Colour and Imaging Institute\" instead (or > using single quotes instead of double quotes)? If not, that may be part of > the problem. You may also need to put quotes around True in the second part > of the WHERE clause. > Another thing to try is to take the 2 sets of extra paratheses off around > ExamPapers.School and ExamPapers.[Add to Webpage] in the WHERE clause, I > don't believe they are necessary. > > So this should be: > > "SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of > Paper], ExamPapers.Course, ExamPapers.School, ExamPapers.Year, ExamPapers. > [Jan/Summer], ExamPapers.[Module Code], ExamPapers.Stage, ExamPapers. [Storage > Location], ExamPapers.[Add to Webpage] FROM ExamPapers WHERE > (ExamPapers.School=\"Colour and Imaging Institute\") AND (ExamPapers.[Add to > Webpage]=True)"; > > HTH > > Maureen > > > Daniel J Owen-Mcgee <[EMAIL PROTECTED]> said: > > > Hi, > > > > I'm gleaning microsoft SQL from queries within a MS Access database, for > insertion into my PHP pages. This has been working fine but the example below > just refuses to work, > > > > SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of > Paper], ExamPapers.Course, ExamPapers.School, ExamPapers.Year, ExamPapers. > [Jan/Summer], ExamPapers.[Module Code], ExamPapers.Stage, ExamPapers. [Storage > Location], ExamPapers.[Add to Webpage] > > FROM ExamPapers > > WHERE (((ExamPapers.School)="Colour and Imaging Institute") AND > ((ExamPapers.[Add to Webpage])=True)); > > > > I want to pull records from 1 table (ExamPapers). > > The WHERE line is causing problems i.e if I remove it, my php pages > actually show. Can anyone see what I'm doing wrong? > > > > Thanks, > > > > Daniel Owen-McGee > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Microsoft Access & PHP
If you are putting this in a web page, I assume you are putting quotes around the select statement. If so, are you escaping the quotes around "Colour and Imaging Institute" by putting \"Colour and Imaging Institute\" instead (or using single quotes instead of double quotes)? If not, that may be part of the problem. You may also need to put quotes around True in the second part of the WHERE clause. Another thing to try is to take the 2 sets of extra paratheses off around ExamPapers.School and ExamPapers.[Add to Webpage] in the WHERE clause, I don't believe they are necessary. So this should be: "SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of Paper], ExamPapers.Course, ExamPapers.School, ExamPapers.Year, ExamPapers. [Jan/Summer], ExamPapers.[Module Code], ExamPapers.Stage, ExamPapers.[Storage Location], ExamPapers.[Add to Webpage] FROM ExamPapers WHERE (ExamPapers.School=\"Colour and Imaging Institute\") AND (ExamPapers.[Add to Webpage]=True)"; HTH Maureen Daniel J Owen-Mcgee <[EMAIL PROTECTED]> said: > Hi, > > I'm gleaning microsoft SQL from queries within a MS Access database, for insertion into my PHP pages. This has been working fine but the example below just refuses to work, > > SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of Paper], ExamPapers.Course, ExamPapers.School, ExamPapers.Year, ExamPapers. [Jan/Summer], ExamPapers.[Module Code], ExamPapers.Stage, ExamPapers.[Storage Location], ExamPapers.[Add to Webpage] > FROM ExamPapers > WHERE (((ExamPapers.School)="Colour and Imaging Institute") AND ((ExamPapers.[Add to Webpage])=True)); > > I want to pull records from 1 table (ExamPapers). > The WHERE line is causing problems i.e if I remove it, my php pages actually show. Can anyone see what I'm doing wrong? > > Thanks, > > Daniel Owen-McGee > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Microsoft Access & PHP
Just a thought. Try putting quotes around the 'True'. George (no expert - not even a novice - yet) - Original Message - From: "Daniel J Owen-Mcgee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 04, 2002 2:29 PM Subject: [PHP-DB] Microsoft Access & PHP Hi, I'm gleaning microsoft SQL from queries within a MS Access database, for insertion into my PHP pages. This has been working fine but the example below just refuses to work, SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of Paper], ExamPapers.Course, ExamPapers.School, ExamPapers.Year, ExamPapers.[Jan/Summer], ExamPapers.[Module Code], ExamPapers.Stage, ExamPapers.[Storage Location], ExamPapers.[Add to Webpage] FROM ExamPapers WHERE (((ExamPapers.School)="Colour and Imaging Institute") AND ((ExamPapers.[Add to Webpage])=True)); I want to pull records from 1 table (ExamPapers). The WHERE line is causing problems i.e if I remove it, my php pages actually show. Can anyone see what I'm doing wrong? Thanks, Daniel Owen-McGee -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Microsoft Access DB & PHP
Well, PHP has a odbc funcions, all the reference located in www.php.net by the way, ASPEdit 2000 tool has a complete referene about these funcions and PHP, ASP, Perl and others. Try to use this. Is Good. Regards Fernando -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Microsoft Access DB & PHP
I should have classified it a bit more. The server is currently Unix but I have an option (one that I don't really want to take) of having the whole website, etc being moved to one of the NT servers. I read something about iODBC or something like that, but I'm not too familiar on that topic. I would like a simple solution if possible - if not, looks like I might change to one of the NT servers and the IIS/PHP solution. James At 08:13 AM 5/04/2001 -0400, Andrew Hill wrote: >James, > >Sure - just connect via ODBC and use the odbc_functions in PHP. > >Best regards, >Andrew >-- >Andrew Hill - OpenLink Software >Director Technology Evangelism >Universal Data Access Integration >http://www.openlinksw.com > > >> -Original Message- >> From: James Kneebone [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday, April 04, 2001 11:47 PM >> To: [EMAIL PROTECTED] >> Subject: [PHP-DB] Microsoft Access DB & PHP >> >> >> Hello List, >> >> I have a query in regards to using PHP to only retrieve records from a >> Microsoft Access Database. I would like to know whether it is possible to >> do so with PHP and not have to change completely and use ASP. >> >> Cheers, >> >> James >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> To contact the list administrators, e-mail: [EMAIL PROTECTED] >> >> > * James Kneebone researching KNEEBONE, WILLIAMS, SNELL, NOELL, LEANE, NICHOLLS (Cornwall) researching ALLAN, WHITTET, McNAUGHTON, NISBET (Scotland) researching THOMPSON (Ireland) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Microsoft Access DB & PHP
James, Sure - just connect via ODBC and use the odbc_functions in PHP. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com > -Original Message- > From: James Kneebone [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 04, 2001 11:47 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Microsoft Access DB & PHP > > > Hello List, > > I have a query in regards to using PHP to only retrieve records from a > Microsoft Access Database. I would like to know whether it is possible to > do so with PHP and not have to change completely and use ASP. > > Cheers, > > James > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]