[Qgis-user] How can i Connect an ACCESS 2007 file to QGIS?

Fridolin CHOULA fchoula at yahoo.fr
Wed Sep 4 06:31:11 PDT 2013


Hello
I'll like to connect a MSACCES 2007 file (*.accdb) to a Quantum projet but I don't know how to do it.
I tried eVis but only MSACCES 2003 file (*.mdb) work.
Please can someone help me?

 
CHOULA Fridolin 
Ingénieur des Eaux, Forêts et des Chasses 
POBox 15788 Yaoundé CAMEROON 
skype: fchoula
Mob: 00 237 99 59 22 41 




>________________________________
> De : Fridolin CHOULA <fchoula at yahoo.fr>
>À : "qgis-user at lists.osgeo.org" <qgis-user at lists.osgeo.org> 
>Envoyé le : Lundi 2 septembre 2013 10h38
>Objet : Connecter une base des données ACCESS 2007
> 
>
>
>Bonjour à Tous!
>J'aimerais avoir les procédure pour connecter une base des données MS ACCESS 2007 (*.accdb)à QGIS 1.8 avec eVis.
>Je parviens à le faire avec MS ACCESS 2003 (*.mdb). Mais ma base des données est sur la version 2007.
>Merci pour votre aide!
> 
>CHOULA Fridolin 
>Ingénieur des Eaux, Forêts et des Chasses 
>POBox 15788 Yaoundé CAMEROON 
>skype: fchoula
>Mob: 00 237 99 59 22 41 
>
>
>
>
>
>>________________________________
>> De : "qgis-user-request at lists.osgeo.org" <qgis-user-request at lists.osgeo.org>
>>À : qgis-user at lists.osgeo.org 
>>Envoyé le : Dimanche 1 septembre 2013 20h00
>>Objet : Qgis-user Digest, Vol 91, Issue 2
>> 
>>
>>Send Qgis-user mailing list submissions to
>>    qgis-user at lists.osgeo.org
>>
>>To subscribe or unsubscribe via the World Wide Web,
 visit
>>    http://lists.osgeo.org/mailman/listinfo/qgis-user
>>or, via email, send a message with subject or body 'help' to
>>    qgis-user-request at lists.osgeo.org
>>
>>You can reach the person managing the list at
>>    qgis-user-owner at lists.osgeo.org
>>
>>When replying, please edit your Subject line so it is more specific
>>than "Re: Contents of Qgis-user digest..."
>>
>>
>>Today's Topics:
>>
>>   1. Re: [Qgis-developer] About a 'directed' LINESTRING    (e.g. for
>>      oneway streets)? (Stefan Keller)
>>   2. Re: [Qgis-developer] About a 'directed' LINESTRING (e.g.
 for
>>      oneway streets)? (Anita Graser)
>>   3. Centroid error (Pat Brown)
>>   4. Error compiling qgis (Andrea Peri)
>>   5. Re: Error compiling qgis (Larry Shaffer)
>>
>>
>>----------------------------------------------------------------------
>>
>>Message: 1
>>Date: Sun, 1 Sep 2013 15:43:17 +0200
>>From: Stefan Keller <sfkeller at gmail.com>
>>To: Alexandre Neto <senhor.neto at gmail.com>
>>Cc: qgis-user <qgis-user at lists.osgeo.org>
>>Subject: Re: [Qgis-user] [Qgis-developer] About a 'directed'
>>    LINESTRING    (e.g. for oneway streets)?
>>Message-ID:
>>    <CAFcOn29+f1zZGYyRZG3Lt5aTqAuT44QOQ45BNKqLOOLUcmksCw at mail.gmail.com>
>>Content-Type: text/plain; charset="utf-8"
>>
>>Hi Alexandre
>>
>>Thanks for the quick answer and the hint to the plugin LineSwitch (from
>>Underdark?).
>>Besides that the plugin page is'nt online currently for me - I'd like to
>>emphasize that my main question is about the reliability through all
>>processing steps to maintain the direction.
>>I actually want to hear if anybody had issues when importing/exporting
>>directed lines with OGR or analysing them with fTools or Sextante.
>>
>>Yours, Stefan
>>
>>
>>2013/9/1 Alexandre Neto <senhor.neto at gmail.com>
>>
>>> Linestrings have a direction already, you can use marker lines with
 arrows
>>> to represent the original direction. For analysis you can revert the
>>> polyline direction using it's attributes, or using the switch the direction
>>> of polyline plugin [1] to actually invert vertex order.
>>>
>>> Alexandre Neto
>>>
>>>
>>> [1] http://plugins.qgis.org/plugins/lineswitch/
>>>
>>>
>>> On Sun, Sep 1, 2013 at 1:53 PM, Stefan Keller <sfkeller at gmail.com> wrote:
>>>
>>>> I'm designing a spatial database and like to introduce a LINESTRING where
>>>> the direction is important, e.g. to describe a oneway street or a water
>>>> pipe. I indicate this by another attribute, e.g. "direction: BOOLEAN", or
>>>> "direction: ENUM(both, as_is, reverse)
>>>>
>>>> A "directed line" means that the order
 of the coordinates of a linestring
>>>> value is important - like in a directed graph - and needs to remain the
>>>> same whatever happens to it e.g. when importing, storing, retrieving,
>>>> analysing or rendering...
>>>>
>>>> Does anybody have had any issues to manage "directed lines" in QGIS (OGR,
>>>> extensions, etc.)?
>>>>
>>>> Yours, Stefan
>>>>
>>>>
>>>> _______________________________________________
>>>> Qgis-developer mailing list
>>>> Qgis-developer at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>>
>>>
>>>
>>-------------- next part --------------
>>An HTML attachment was scrubbed...
>>URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130901/da0273a2/attachment-0001.html>
>>
>>------------------------------
>>
>>Message: 2
>>Date: Sun, 01 Sep 2013 16:54:42 +0200
>>From: "Anita Graser" <anitagraser at gmx.at>
>>To: "Stefan Keller" <sfkeller at gmail.com>
>>Cc: qgis-user <qgis-user at lists.osgeo.org>
>>Subject: Re: [Qgis-user] [Qgis-developer] About a 'directed'
>>    LINESTRING (e.g. for oneway streets)?
>>Message-ID: <op.w2qmdgz2na7rjy at anita-pc>
>>Content-Type: text/plain; charset=iso-8859-15;
 format=flowed;
>>    delsp=yes
>>
>>Hi Stefan,
>>
>>Nathan developed the line direction switcher  
>>http://gis.stackexchange.com/questions/9261/how-can-i-switch-line-direction-in-qgis
>>
>>I do a lot of work with street networks where line direction is very  
>>important. So far, I haven't run into any problems due to the direction  
>>being messed up by any tools.
>>
>>Best wishes,
>>Anita
>>
>>
>>
>>Am 01.09.2013, 15:43 Uhr, schrieb Stefan Keller <sfkeller at gmail.com>:
>>
>>> Hi Alexandre
>>>
>>> Thanks for the quick answer and the hint to the plugin LineSwitch (from
>>> Underdark?).
>>> Besides that the plugin page is'nt online currently for me - I'd like to
>>> emphasize that my main
 question is about the reliability through all
>>> processing steps to maintain the direction.
>>> I actually want to hear if anybody had issues when importing/exporting
>>> directed lines with OGR or analysing them with fTools or Sextante.
>>>
>>> Yours, Stefan
>>>
>>>
>>> 2013/9/1 Alexandre Neto <senhor.neto at gmail.com>
>>>
>>>> Linestrings have a direction already, you can use marker lines with  
>>>> arrows
>>>> to represent the original direction. For analysis you can revert the
>>>> polyline direction using it's attributes, or using the switch the  
>>>> direction
>>>> of polyline plugin [1] to actually invert vertex order.
>>>>
>>>> Alexandre Neto
>>>>
>>>>
>>>> [1] http://plugins.qgis.org/plugins/lineswitch/
>>>>
>>>>
>>>> On Sun, Sep 1, 2013 at 1:53 PM, Stefan Keller <sfkeller at gmail.com>>>> wrote:
>>>>
>>>>> I'm designing a spatial database and like to introduce a LINESTRING  
>>>>> where
>>>>> the direction is important, e.g. to describe a oneway street or a water
>>>>> pipe. I indicate this by another attribute, e.g. "direction: BOOLEAN",  
>>>>> or
>>>>> "direction: ENUM(both, as_is, reverse)
>>>>>
>>>>> A "directed line" means that the order of the coordinates of a  
>>>>> linestring
>>>>> value is important - like in a directed graph - and needs to remain the
>>>>> same whatever happens to it e.g. when importing, storing,
 retrieving,
>>>>> analysing or rendering...
>>>>>
>>>>> Does anybody have had any issues to manage "directed lines" in QGIS  
>>>>> (OGR,
>>>>> extensions, etc.)?
>>>>>
>>>>> Yours, Stefan
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Qgis-developer mailing list
>>>>> Qgis-developer at lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>>>
>>>>
>>
>>
>>------------------------------
>>
>>Message: 3
>>Date: Sun, 1 Sep 2013 17:34:43 +0200
>>From: Pat Brown <mistyhaven at gmail.com>
>>To: QGIS Mailing List <qgis-user at lists.osgeo.org>
>>Subject: [Qgis-user] Centroid error
>>Message-ID:
>>    <CAJdnw=ifQAVmQAy6-i1J0Kxst=2f-0RRSSNHV0qiY0K8wEvEWA at mail.gmail.com>
>>Content-Type: text/plain; charset="iso-8859-1"
>>
>>Hi List,
>>I have a layer of around 17000 polygons, for which I want to derive the
>>centroid. Using the Vector/Geometry Tools/Polygon Centroid tool the process
>>progressed to around 45% when this message came up: "Error processing
>>specified tolerance. Please choose larger tolerance". Can anybody tell me
>>why this occurred and how does one set a larger tolerance?
>>
>>Thanks,
>>
>>Paddy
>>-------------- next
 part --------------
>>An HTML attachment was scrubbed...
>>URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130901/8954f94d/attachment-0001.html>
>>
>>------------------------------
>>
>>Message: 4
>>Date: Sun, 1 Sep 2013 19:59:00 +0200
>>From: Andrea Peri <aperi2007 at gmail.com>
>>To: qgis-user <qgis-user at lists.osgeo.org>
>>Subject: [Qgis-user] Error compiling qgis
>>Message-ID:
>>    <CABqTJk8x_D64HMe8izEsnxcJKON3CANBYsyiQjM6nXWVpZC+zw at mail.gmail.com>
>>Content-Type: text/plain; charset="iso-8859-1"
>>
>>Hi,
>>compiling the
 last trunk version of qgis desktop,
>>
>>I have this error:
>>
>>[ 89%] Generating analysis/sipanalysispart0.cpp,
>>analysis/sipanalysispart1.cpp, analysis/sipanalysispart2.cpp,
>>analysis/sipanalysispart3.cpp
>>
>>sip: Unable to find file "QtCore/QtCoremod.sip"
>>make[2]: *** [python/analysis/sipanalysispart0.cpp] Error 1
>>make[1]: *** [python/CMakeFiles/python_module_qgis_analysis.dir/all] Error 2
>>make: *** [all] Error 2
>>
>>I don't understand what is missing.
>>The sip module I guess if available, but perhaps miss some other module .
>>
>>Any help is welcome.
>>
>>-- 
>>-----------------
>>Andrea Peri
>>. . . . . . . . .
>>qwerty ?????
>>-----------------
>>-------------- next part --------------
>>An HTML attachment was scrubbed...
>>URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130901/17800e01/attachment-0001.html>
>>
>>------------------------------
>>
>>Message: 5
>>Date: Sun, 1 Sep 2013 12:54:00 -0600
>>From: Larry Shaffer <larrys at dakotacarto.com>
>>To: Andrea Peri <aperi2007 at gmail.com>
>>Cc: qgis-user <qgis-user at lists.osgeo.org>
>>Subject: Re: [Qgis-user] Error compiling qgis
>>Message-ID:
>>    <CA+nQOR8jpyvb=j14XWjF8sNDiU_Xnw7JiTOGf7sRRvsjnpYk-g at mail.gmail.com>
>>Content-Type: text/plain;
 charset="iso-8859-1"
>>
>>Hi Andrea,
>>
>>On Sun, Sep 1, 2013 at 11:59 AM, Andrea Peri <aperi2007 at gmail.com> wrote:
>>
>>> Hi,
>>> compiling the last trunk version of qgis desktop,
>>>
>>> I have this error:
>>>
>>> [ 89%] Generating analysis/sipanalysispart0.cpp,
>>> analysis/sipanalysispart1.cpp, analysis/sipanalysispart2.cpp,
>>> analysis/sipanalysispart3.cpp
>>>
>>> sip: Unable to find file "QtCore/QtCoremod.sip"
>>> make[2]: *** [python/analysis/sipanalysispart0.cpp] Error 1
>>> make[1]: *** [python/CMakeFiles/python_module_qgis_analysis.dir/all] Error
>>> 2
>>> make: *** [all] Error 2
>>>
>>
>>That looks like a subsequent error. Is there and earlier sip-related error
>>in the output?
>>
>>Regards,
>>
>>Larry
>>
>>
>>> I don't understand what is missing.
>>> The sip module I guess if
 available, but perhaps miss some other module .
>>>
>>> Any help is welcome.
>>>
>>> --
>>> -----------------
>>> Andrea Peri
>>> . . . . . . . . .
>>> qwerty ?????
>>> -----------------
>>>
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>-------------- next part --------------
>>An HTML attachment was scrubbed...
>>URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130901/22dc1131/attachment-0001.html>
>>
>>------------------------------
>>
>>_______________________________________________
>>Qgis-user mailing list
>>Qgis-user at lists.osgeo.org
>>http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>>End of Qgis-user Digest, Vol 91, Issue 2
>>****************************************
>>
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130904/d480f0db/attachment.html>


More information about the Qgis-user mailing list