Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ODBC Invalid cursor position

10 posts in General Discussion Last posting was on 2004-06-14 19:14:15.0Z
Carl Posted on 2004-06-03 07:27:31.0Z
Sender: 4fc4.409b4540.1804289383@sybase.com
From: Carl
Newsgroups: ianywhere.public.general
Subject: ODBC Invalid cursor position
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40bed325.edf.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 3 Jun 2004 00:28:37 -0700, 10.22.241.42
Lines: 25
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Jun 2004 00:25:34 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Jun 2004 00:27:31 -0700
X-Trace: forums-1-dub 1086247651 10.22.108.75 (3 Jun 2004 00:27:31 -0700)
X-Original-Trace: 3 Jun 2004 00:27:31 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3091
Article PK: 6552

The industry specific software my client has uses a frontend
written in Delphi, I believe, to access the database. The
workstations are all Win98 and the server is Linux (RH 7.2
running ASE 8.0). I am the systems admin and trying to find
the source of the problem. We have only been using the
software since the beginning of the year, but it had been
working with our 400MB db up until about two weeks ago. Then
an "invalid cursor position" error began to appear. It has
only come up on a few accounts, but once it shows on an
account, it can be consistently gotten. The software
company says they can't reproduce the problem at their
facility and they only run Win2000 servers so the
implication is that it is "the Linux box" that is causing
the problem. The server in question is older and due to be
replaced, but has run trouble free for 3 years. Can it be
the server or is it an improper client query? Or is there
too little information here to tell? The only other thing
that may or may not have any relevance is that about the
time this started there was a power surge. The server is on
a battery backup, but very few of the workstations are.
Since that time, the software company downloaded the
database, dumped it and reloaded it with no apparent effect
on the problem. Thanks for any light you can shed on this. I
am being put in the middle on this and am NOT a database
programmer.


Greg Fenton Posted on 2004-06-04 19:59:55.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 MultiZilla/1.6.2.0c
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Invalid cursor position
References: <40bed325.edf.1681692777@sybase.com>
In-Reply-To: <40bed325.edf.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <40c0d502$1@forums-2-dub>
X-Original-Trace: 4 Jun 2004 13:01:06 -0700, gfenton-xp.sybase.com
Lines: 41
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 4 Jun 2004 12:57:49 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 4 Jun 2004 12:59:55 -0700
X-Trace: forums-1-dub 1086379195 10.22.108.75 (4 Jun 2004 12:59:55 -0700)
X-Original-Trace: 4 Jun 2004 12:59:55 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3106
Article PK: 6568


Carl wrote:
> workstations are all Win98 and the server is Linux (RH 7.2
> running ASE 8.0).

I assume you mean AS_A_ 8.0 ??

If so, please post the exact version and build number (use the command
"dbeng8 -v")


> The software
> company says they can't reproduce the problem at their
> facility and they only run Win2000 servers so the
> implication is that it is "the Linux box" that is causing
> the problem.
> [...] Can it be
> the server or is it an improper client query? Or is there
> too little information here to tell?

The size of the database is likely not the problem. Neither is it
likely that a power outage would cause this kind of problem.

The problem also is likely not related to "the Linux box", but there
could be some differences in the behaviours of the Linux version of the
engine. However, there's no point in laying blame until we know the
actual cause of the problem.

Where are you seeing the error? What is the exact text of the error?
Is there an error number associated with it?

Can you tell us anything about the type of cursor being used by the
application?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Greg Fenton Posted on 2004-06-05 17:50:01.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 MultiZilla/1.6.2.0c
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Invalid cursor position
References: <40c0d502$1@forums-2-dub> <40c0e664.511a.1681692777@sybase.com>
In-Reply-To: <40c0e664.511a.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: cpe000625d8278c-cm.cpe.net.cable.rogers.com
Message-ID: <40c20815$1@forums-2-dub>
X-Original-Trace: 5 Jun 2004 10:51:17 -0700, cpe000625d8278c-cm.cpe.net.cable.rogers.com
Lines: 25
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Jun 2004 10:47:52 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Jun 2004 10:50:01 -0700
X-Trace: forums-1-dub 1086457801 10.22.108.75 (5 Jun 2004 10:50:01 -0700)
X-Original-Trace: 5 Jun 2004 10:50:01 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3111
Article PK: 6572


Carl wrote:
>
> I am not a programmer nor do I have ready access to the code
> although I might be able to get that from the company. I
> could use a sniffer to get the transaction sent to the
> server if that would be helpful.

If you have the ability to start the database engine yourself, you might
try using the "-zr -zo c:\request_log.txt" options to start the
request-level logging. Then run the application and note the time that
the error occurs. The request log can then be analyzed to determine
what SQL requests were being made at the time.

But it sounds to me like this is a problem your vendor should be
involved with.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Carl Posted on 2004-06-11 18:11:15.0Z
Sender: 4dbc.40c9f4f6.1804289383@sybase.com
From: Carl
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Invalid cursor position
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40c9f619.4dc9.1681692777@sybase.com>
References: <40c20815$1@forums-2-dub>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-2-dub40c9f619"
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 11 Jun 2004 11:12:41 -0700, 10.22.241.42
Lines: 1692
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Jun 2004 11:08:22 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Jun 2004 11:11:15 -0700
X-Trace: forums-1-dub 1086977475 10.22.108.75 (11 Jun 2004 11:11:15 -0700)
X-Original-Trace: 11 Jun 2004 11:11:15 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3174
Article PK: 6634


> Carl wrote:
> >
> > I am not a programmer nor do I have ready access to the
> > code although I might be able to get that from the
> > company. I could use a sniffer to get the transaction
> > sent to the server if that would be helpful.
>
> If you have the ability to start the database engine
> yourself, you might try using the "-zr -zo
> c:\request_log.txt" options to start the request-level
> logging. Then run the application and note the time that
> the error occurs. The request log can then be analyzed to
> determine what SQL requests were being made at the time.
>

I've attached an archive of the logs. The title denotes what
the zr argument was and the good or bad tells what account
was accessed. I started the server, went to an account
without the problem and recorded the requests. I then shut
the serrver down, restarted and went to an account that
would dislplay the ODBC error when that record was requested
and recorded that. Sorry it took so long. Is it possible
that ODBC error could be generated, say, if the record
existed on hard disk media that was going bad? I would just
like to determine if this is my issue or the software
vendor's. All your help is appreciated.

> But it sounds to me like this is a problem your vendor
> should be involved with.
>
Until I can give them some sort of proof that it could be
their issue, they won't.

Carl


Greg Fenton Posted on 2004-06-13 03:34:50.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 MultiZilla/1.6.2.0c
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Invalid cursor position
References: <40c20815$1@forums-2-dub> <40c9f619.4dc9.1681692777@sybase.com>
In-Reply-To: <40c9f619.4dc9.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: vpn-concord-018.sybase.com
Message-ID: <40cbc9ac$1@forums-2-dub>
X-Original-Trace: 12 Jun 2004 20:27:40 -0700, vpn-concord-018.sybase.com
Lines: 70
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Jun 2004 20:31:58 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Jun 2004 20:34:50 -0700
X-Trace: forums-1-dub 1087097690 10.22.108.75 (12 Jun 2004 20:34:50 -0700)
X-Original-Trace: 12 Jun 2004 20:34:50 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3176
Article PK: 6633

I cannot be certain, as I don't know Delphi (I haven't use Pascal in
many, many moons...), but I believe the SQL causing your problem is likely:


06/09 07:40:39.157 ** REQUEST conn: 134742496 CURSOR_OPEN
Stmt=3604629
06/09 07:40:39.157 ** HOSTVAR conn: 134742496 0 varchar '01-0031430'
06/09 07:40:39.157 ** HOSTVAR conn: 134742496 1 varchar '2B'
06/09 07:40:39.158 ** DONE conn: 134742496 CURSOR_OPEN
Crsr=1835169
06/09 07:40:39.159 ** REQUEST conn: 134742496 ROW_DESCRIPTOR
Crsr=1835169
06/09 07:40:39.160 ** DONE conn: 134742496 ROW_DESCRIPTOR
06/09 07:40:39.160 ** REQUEST conn: 134742496 CURSOR_FETCH
Crsr=1835169, Count=1, Offset=1 (relative)
06/09 07:40:39.160 ** DONE conn: 134742496 CURSOR_FETCH
06/09 07:40:39.161 ** REQUEST conn: 134742496 CURSOR_PREFETCH
Crsr=1835169
06/09 07:40:39.184 ** WARNING conn: 134742496 code: 100 "Row not found"
06/09 07:40:39.184 ** DONE conn: 134742496 CURSOR_PREFETCH
06/09 07:40:39.186 ** REQUEST conn: 134742496 CURSOR_GETDATA
Crsr=1835169
06/09 07:40:39.186 ** ERROR conn: 134742496 code: -197 "No current
row of cursor"
06/09 07:40:39.186 ** DONE conn: 134742496 CURSOR_GETDATA


This comes from attempting to get data from the statement:

06/09 07:40:39.005 ** REQUEST conn: 134742496 STMT_PREPARE
"SELECT * FROM AppointmentCAInspectionOtherRecommendation WHERE
Appointment = ? AND FindingLocation = ? "


with the values '01-0031430' and '2B' passed in.


Notice that there is an ERROR denoted in the trace. The cursor is
opened, a "row not found" is returned, yet a GETDATA is called on the
cursor.

I don't have much experience with analyzing traces for database issues,
but I believe what we're seeing is a data (i.e. application) problem,
not a database problem. The database is reporting that a cursor has no
rows, yet the application insists on fetching a row. The database
engine returns an error and (it appears) that the application isn't
handling the error.

First thing you should do is try to verify that the above data
corresponds with the occurance of the application error. I'd hate to
start chasing down an avenue only to find out that I've pinpointed the
wrong location in the log file (others feel free to jump in if my
analysis seems off).

Could you try copying the .db file from the Linux server to a Windows
server and see if the application gives you similar behaviour? This
would at least give you leverage to get the vendor involved.

Another thing you might do if you haven't already is to validate the
database just to discount the "bad media" issue.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Bryan Posted on 2004-06-14 16:58:31.0Z
Sender: 5b74.40cdd68a.1804289383@sybase.com
From: Bryan
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Invalid cursor position
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40cdd937.5be6.1681692777@sybase.com>
References: <40cbc9ac$1@forums-2-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 Jun 2004 09:58:31 -0700
X-Trace: forums-1-dub 1087232311 10.22.241.41 (14 Jun 2004 09:58:31 -0700)
X-Original-Trace: 14 Jun 2004 09:58:31 -0700, 10.22.241.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3178
Article PK: 6637

Greg,
Carl contaced me concerning the issue with the invalid
cursor position. I am a technical rep that supports the
software. I am just stepping in the middle here without
knowing all of the facts, but here is what I can tell. Our
application is running a query on the primary key of a
specific table, thus expecting only one record to be
returned. When we run this query on a Windows based dbsrv8
we get only one record returned. However running the same
query on the same database for the same record under Linux
returns two records. My first thought was a bad index so I
did and unload of the data, and a reload into a blank
database. I still had the same results.
We are a "Windows Shop" and we don't support Linux, so our
recommendation was to convert over to Windows, an
environment we are much more comforatble in. However, Carl
doesn't want to make the migration and so he approached you
guys for help. I hope this helps, and I appreciate you
working with him. We are on a support and maintenance with
Sybase so if this issue needs to be escalated please let me
or Carl know. Thanks again.


Robert Waywell Posted on 2004-06-14 17:47:46.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <40cbc9ac$1@forums-2-dub> <40cdd937.5be6.1681692777@sybase.com>
Subject: Re: ODBC Invalid cursor position
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <40cde440$1@forums-2-dub>
X-Original-Trace: 14 Jun 2004 10:45:36 -0700, rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 14 Jun 2004 10:44:38 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 14 Jun 2004 10:47:46 -0700
X-Trace: forums-1-dub 1087235266 10.22.108.75 (14 Jun 2004 10:47:46 -0700)
X-Original-Trace: 14 Jun 2004 10:47:46 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3180
Article PK: 6635

Hi Brian,
From Carl's most recent post, it appears that this behaviour is seen on
Linux but not Windows. It also sounds like this is reproducible. I would
recommend verifying that the problem still persists on the current 8.0.2 EBF
for Linux. If it does still reproduce, then either you or Carl submit the
reproducible case to Tech Support so that we can verify the problem and
submit it to Engineering.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
ug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Bryan> wrote in message news:40cdd937.5be6.1681692777@sybase.com...
> Greg,
> Carl contaced me concerning the issue with the invalid
> cursor position. I am a technical rep that supports the
> software. I am just stepping in the middle here without
> knowing all of the facts, but here is what I can tell. Our
> application is running a query on the primary key of a
> specific table, thus expecting only one record to be
> returned. When we run this query on a Windows based dbsrv8
> we get only one record returned. However running the same
> query on the same database for the same record under Linux
> returns two records. My first thought was a bad index so I
> did and unload of the data, and a reload into a blank
> database. I still had the same results.
> We are a "Windows Shop" and we don't support Linux, so our
> recommendation was to convert over to Windows, an
> environment we are much more comforatble in. However, Carl
> doesn't want to make the migration and so he approached you
> guys for help. I hope this helps, and I appreciate you
> working with him. We are on a support and maintenance with
> Sybase so if this issue needs to be escalated please let me
> or Carl know. Thanks again.


arl Posted on 2004-06-14 17:22:32.0Z
Sender: 5c26.40cdddbf.1804289383@sybase.com
From: arl
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Invalid cursor position
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40cdded8.5c35.1681692777@sybase.com>
References: <40cbc9ac$1@forums-2-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 Jun 2004 10:22:32 -0700
X-Trace: forums-1-dub 1087233752 10.22.241.41 (14 Jun 2004 10:22:32 -0700)
X-Original-Trace: 14 Jun 2004 10:22:32 -0700, 10.22.241.41
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3179
Article PK: 6641


>
> First thing you should do is try to verify that the above
> data corresponds with the occurance of the application
> error. I'd hate to start chasing down an avenue only to
> find out that I've pinpointed the wrong location in the
> log file (others feel free to jump in if my analysis
> seems off).
>

> Could you try copying the .db file from the Linux server
> to a Windows server and see if the application gives you
> similar behaviour? This would at least give you leverage
> to get the vendor involved.
>

The db was copied to a Windows machine and run from there
and did NOT produce the error.

> Another thing you might do if you haven't already is to
> validate the database just to discount the "bad media"
> issue.
>
I used Sybase Central to validate the db. It returned no
errors.

I talked to Bryan at the software compnay. He said he will
post more info on the problem in this thread. Thanks again
for your efforts.

Carl


Greg Fenton Posted on 2004-06-14 19:14:15.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 MultiZilla/1.6.2.0c
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Invalid cursor position
References: <40cbc9ac$1@forums-2-dub> <40cdded8.5c35.1681692777@sybase.com>
In-Reply-To: <40cdded8.5c35.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <40cdf907$1@forums-1-dub>
Date: 14 Jun 2004 12:14:15 -0700
X-Trace: forums-1-dub 1087240455 10.25.100.188 (14 Jun 2004 12:14:15 -0700)
X-Original-Trace: 14 Jun 2004 12:14:15 -0700, gfenton-xp.sybase.com
Lines: 31
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3181
Article PK: 6636


Carl wrote:
>
> The db was copied to a Windows machine and run from there
> and did NOT produce the error.
>

I concur with Rob Waywell's comment. You are using ASA 8.0.2.3608 which
is the first 8.0.2 release for Linux. Follow Rob's suggestion of
applying the most recent 8.0.2 EBF to your Linux install and try again.

If the problem persists, then I suggest opening a case with technical
support. Either you or Bryan can do so. We'll want either the entire
database (or a smaller sample set), the particular query (or queries),
the expected response and the improper response.

BTW: though the vendor is a "Windows shop", it's refreshing to see that
they are open to allowing you to use your choice of server platform.
Where possible, ASA on various platforms should behave identically. But
from time-to-time we run into a platform-specific (or build number
specific) bug.

Please post back if the EBF solves your problem,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/