[Qgis-developer] Native SQL Anywhere plugin+provider contributed
to trunk
Tim Sutton
lists at linfiniti.com
Wed Dec 22 14:17:48 EST 2010
Hi again
On Wed, Dec 22, 2010 at 9:10 PM, Tim Sutton <lists at linfiniti.com> wrote:
> Hi Dave
>
> Just getting around to test driving the new provider.
>
> What is the correct value for 'servername' in the dbisql gui (assuming
> having followed your instructions below and that the database I
> created is called 'gis').
>
Ok I came right by doing 'start and connect', and then leaving the
servername blank.
Regards
Tim
> Thanks
>
> Tim
>
>
> On Thu, Dec 16, 2010 at 12:00 AM, <Dave.DeHaan at sybase.com> wrote:
>>
>> Hello QGIS Devs,
>>
>> As per discussion on qgis-psc a couple of weeks ago, I have just
>> contributed (rev. 14918) a native plugin+provider for Sybase SQL Anywhere
>> (trunk/qgis/src/plugins/sqlanywhere; trunk/qgis/src/providers/sqlanywhere),
>> similar in functionality to the PostGIS and SpatiaLite providers. Due to a
>> legal technicality, this code needed to be released under GPL v3 rather
>> than the usual GPL v2 used by the rest of the QGIS project.
>>
>> I've tested the code under both Ubuntu 10.04 (gcc) and Windows XP (MSVC
>> 2008). If there are developers out there on other platforms, could you
>> please let me know if the plugin fails to either compile or load on your
>> platform (loading it should add a toolbar button and a couple menu
>> options)?
>>
>> If anyone is interested in taking the plugin/provider for a test drive,
>> here is a quick set of steps to get you started:
>>
>> 1. Download the free Developer's Edition of SQL Anywhere 12.0.0 here:
>> http://www.sybase.com/detail?id=1016644
>>
>> 2. Install the SQL Anywhere 12.0.0 engine on your database host
>>
>> 3. Install the SQL Anywhere 12.0.0 client libraries on your QGIS client
>> (only necessary if client and host are different machines)
>>
>> 4. Use 'dbinit my_database_name' to initialize a blank database on the
>> host. The default user/password is initialized to 'dba'/'sql'.
>>
>> 5. Use 'dbsrv12 my_database_name' to start the database server on the
>> host.
>>
>> 6. Populate the database with sample spatial data. To facilitate this
>> step, I have contributed the SQL script
>> src/providers/sqlanywhere/load_alaska_shapes.sql which loads the Alaska
>> VMap0 shapefiles into new tables. Use the 'Interactive SQL' tool (dbisql)
>> on the database host to open/execute this script (you will need to modify a
>> few variables at the top of the script to tell it where to find the
>> shapefiles, which are assumed to be on the filesystem of the database
>> host).
>>
>> 7. Start up QGIS, and load the SQL Anywhere plugin. This will add a
>> button to the data sources toolbar, as well as the menu entries 'Plugins->
>> SQL Anywhere' and 'Layer->Add SQL Anywhere Layer...'
>>
>> 8. Adding a SQL Anywhere layer should invoke a dialogue box for choosing
>> a connection and searching the database schema for geometry columns
>> (similar look/feel/functionality to the PostGIS and SpatiaLite toolbar
>> buttons). If you instead receive a message box, it means that it can't
>> find the SQL Anywhere client libraries installed in step 3 (or step 2 if
>> client=host).
>>
>> Please let me know if you have any questions/comments/suggestions/bugs...
>>
>> Thanks,
>> Dave
>>
>> ----
>> David DeHaan
>> SQL Anywhere Research and Development
>> Sybase iAnywhere
>> ddehaan at sybase.com
>>
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
>
>
>
> --
> Tim Sutton - QGIS Project Steering Committee Member (Release Manager)
> ==============================================
> Please do not email me off-list with technical
> support questions. Using the lists will gain
> more exposure for your issues and the knowledge
> surrounding your issue will be shared with all.
>
> Visit http://linfiniti.com to find out about:
> * QGIS programming and support services
> * Mapserver and PostGIS based hosting plans
> * FOSS Consulting Services
> Skype: timlinux
> Irc: timlinux on #qgis at freenode.net
> ==============================================
>
--
Tim Sutton - QGIS Project Steering Committee Member (Release Manager)
==============================================
Please do not email me off-list with technical
support questions. Using the lists will gain
more exposure for your issues and the knowledge
surrounding your issue will be shared with all.
Visit http://linfiniti.com to find out about:
* QGIS programming and support services
* Mapserver and PostGIS based hosting plans
* FOSS Consulting Services
Skype: timlinux
Irc: timlinux on #qgis at freenode.net
==============================================
More information about the Qgis-developer
mailing list