StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POunixODBC + mdbTools + PHP
primarykey
Id
16914913
data
AcceptedAnswerId
16915529
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-06-04T10:00:35.023
FavoriteCount
2
LastActivityDate
2013-06-04T10:30:23.147
LastEditDate
LastEditorUserId
0
OwnerUserId
952576
ParentId
0
PostTypeId
1
Score
4
ViewCount
8905
LastEditorDisplayName
text
Body
<p>I need to connect a PHP script in a LAMP (Linux Ubuntu 12.10, Apache 2, MySQL 5, PHP 5.3) server to an Access MDB database (version 2003).</p> <h2>1. unixODBC and Driver installation</h2> <p>The Ubuntu 12.10 comes with unixodbc 2.2.14 package (<a href="http://packages.ubuntu.com/quantal/unixodbc" rel="nofollow">http://packages.ubuntu.com/quantal/unixodbc</a>). The installation was easy: apt-get install unixodbc libmdbodbc1 php5-odbc. This way I've unixODBC with the mdbTools driver and the ODBC PHP capability.</p> <p>I've edited /etc/odbcinst.ini with the mdbtools driver:</p> <pre><code>[MDBToolsODBC] Description = MDBTools Driver Driver = libmdbodbc.so.1 </code></pre> <p>I've edited /etc/odbc.ini with the Access datasource:</p> <pre><code>[FormPulmo] Description = FormulariCDRPulmo Driver = MDBToolsODBC Servername = localhost Database = /mnt/svrfit/cdr/bd_pulmo_hardlink.mdb UserName = Password = port = 5432 </code></pre> <p>Finally I tested from shell and it worked:</p> <pre><code>> isql -v formpulmo Connected! </code></pre> <h2>2. PHP connection</h2> <p>With PHP initialy all seems to work ok:</p> <pre><code>$link = odbc_connect ('formpulmo',"",""); $res = odbc_exec ($link,"SELECT * FROM exampleTable"); </code></pre> <p>The first problem was trying to access tables with spaces in their names. Example: "example Table". In Windows I've to put that between brackets ([example Table]) but it didn't worked. Finally I found the solution:</p> <pre><code>$res = odbc_exec ($link,"SELECT * FROM \"example Table\""); </code></pre> <p><b>Before this solutions all the browser response trying to do the odbc_exec were "Error 324 (net::ERR_EMPTY_RESPONSE)"</b></p> <h1>3. PHP problems !</h1> <p>But now I'm stuck with the UPDATE syntax. The normal query is:</p> <pre><code>$res = odbc_exec ($link,"UPDATE [Registre cancer de pulmo] SET CIP = 'example' WHERE CIP = 'example'"); </code></pre> <p>The browser response is: "Error 324 (net::ERR_EMPTY_RESPONSE)" (In Firefox: "The connection was reset").</p> <h2>3.1. Tried solutions</h2> <pre><code>UPDATE \"Registre cancer de pulmo\" SET CIP = 'example' WHERE CIP = 'example' UPDATE \"Registre cancer de pulmo\" SET \"CIP\" = 'example' WHERE \"CIP\" = 'example' UPDATE {Registre cancer de pulmo} SET {CIP} = 'example' WHERE {CIP} = 'example' </code></pre> <p>Connect with different cursors:</p> <pre><code>odbc_connect ($odbcFormPulmo,"","",SQL_CUR_USE_ODBC); odbc_connect($odbcFormPulmo,"","",SQL_CUR_USE_DRIVER); </code></pre> <p>I don't know what more I can try :-(</p>
Tags
<php><ms-access><ubuntu><odbc><unixodbc>
Title
unixODBC + mdbTools + PHP
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USDimas
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POunixODBC + mdbTools + PHP
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  POunixODBC + mdbTools + PHP
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  POunixODBC + mdbTools + PHP
  UserUserId
  USKonrad
  VoteTypeVoteTypeId
  VTFavorite
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.