[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