Denis,
Thank you for your response. I was surprised and pleased that MI Tech
Support helped me with this issue as I was only using demo software.
Apparently you need the MapX 4.5.1 update to use SpatialWare for SQL
Server. Unfortunately 4.5.1 is not available as a demo version so I tried
the new MapX 5.0 Beta and it works (with a couple of known bugs).
I just got the MapInfo 7.0 demo and we will see if it works there as well.
- Brad
At 07:24 AM 5/6/2002 -0700, you wrote:
>Hi,
>
>Not sure if you got an answer to your questions but I
>noticed that you are using stored procedures. I sent
>an email to MapInfo Teck support a few months back
>about using SQL Stored procedures...this is the
>response I got:
>
>It appears that this is a limitation (sending stored
>procedures) in MapInfo
>6.5 and MapX 4.5. They are looking into this issue in
>Development and hope
>to have it fixed in the next version of our products.
>
>Cindy
>MapInfo Technical Support
>
>Hope that helps,
>
>Denis
>
>Denis Lalonde
>DBxGeomatics Inc.
>37 St-Joseph Boul. Floor 2
>819-772-2000
>Hull, QC, J8Y 3V8
>www.dbxgeomatics.com
>[EMAIL PROTECTED]
>
>
>--- Brad Mathews <[EMAIL PROTECTED]> wrote:
> > Me again,
> >
> > I am trying to access a SpatialWare SQL Server table
> > from MapX. I am
> > getting an error "1011, Unable to Access Dataset".
> > Any idea what I am doing
> > wrong here?
> >
> > Here is my code sample:
> >
> > Dim lInfo As Object
> > Dim SQL As String
> >
> > Form1.Show
> > Set lInfo = CreateObject("mapx.layerinfo.4")
> > lInfo.Type = 4 ' layer type is RDB
> > lInfo.AddParameter "NAME", "Sites" ' layer name
> > lInfo.AddParameter "TOOLKIT", "ODBC"
> > lInfo.AddParameter "CONNECTSTRING",
> > "DSN=SpatialTest"
> > SQL = "exec sp_spatial_query " & _
> > "'select List, Site_Name, sw_member,
> > sw_geometry,
> > HG_GetString(sw_geometry) as geometry " & _
> > " from bay where ST_Overlaps(sw_geometry, "
> > & _
> > "
> >
>ST_Spatial(''ST_POLYGON(HG_CIRCLE(-2258114.47,1908249.11,
> > 1600
> > ))''" & _
> > "))'"
> > 'SQL = "exec sp_spatial_query 'Select * from bay'"
> >
> > lInfo.AddParameter "QUERY", SQL
> > lInfo.AddParameter "CACHE", "ON"
> > lInfo.AddParameter "MBRSEARCH", "ON"
> > Map1.Layers.Add lInfo
> > Set lInfo = Nothing
> >
> > Thanks,
> >
> > Brad Mathews
> > CTO, Cypress Technology Solutions, Inc.
> > www.CypressSolutions.com
> >
> >
> >
>---------------------------------------------------------------------
> > List hosting provided by Directions Magazine |
> > www.directionsmag.com |
> > To unsubscribe, e-mail:
> > [EMAIL PROTECTED]
> > For additional commands, e-mail:
> > [EMAIL PROTECTED]
> >
>
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Health - your guide to health and wellness
>http://health.yahoo.com
Brad Mathews
CTO, Cypress Technology Solutions, Inc.
www.CypressSolutions.com
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
