<div>
Don't you need the SRID parameter? <br />
<br />
ST_Geometry::ST_GeomFromTe<wbr />xt( 'POINT(1 1), 0' )
</div>


Don't you need the SRID parameter?

ST_Geometry::ST_GeomFromText( 'POINT(1 1), 0' )

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am trying to plot some long and lats from a Sybase 16 database into a SSRS Map report using SQL Server spatial query.<br />
<br />
I am using the below code to generate the spatial data in Sybase:<br />

<pre><code id="code-10-29001702-1">ST_Geometry::ST_GeomFromText( 'POINT(1 1)' )</code></pre>
<br />
but when I click n next the wizard states that the dataset does not contain any spatial field.<br />
<br />
Please help.<br />
<br />
Thanks, Greg
</div>
</div>


Hi,

I am trying to plot some long and lats from a Sybase 16 database into a SSRS Map report using SQL Server spatial query.

I am using the below code to generate the spatial data in Sybase:
(CODE)

but when I click n next the wizard states that the dataset does not contain any spatial field.

Please help.

Thanks, Greg

SSRS 2016 Maps Spatial Query using Sybase Datasource

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Sybase Database

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.