PB 11.5.1 and SqlAnywhere 5.5

When I open a datawindow in the datawindow painter and click
Design>Data Source I get the following error message: SQLSTATE = 37000
[Sybase][ODBC Driver] Syntax error: unknown function 'user_id'

The heading on the message is GetTriggers. I do not have any triggers
on this database. I get the same error regardless of the datawindow I
open when I click Data Source. I click OK and it seems to be okay but
not 100% sure. Any help would be appreciated.

Thanks
Jerry
0
Jerry
11/30/2009 5:07:36 PM
sybase.powerbuilder.datawindow 28057 articles. 5 followers. Follow

1 Replies
1063 Views

Similar Articles

[PageSpeed] 0
Get it on Google Play
Get it on Apple App Store

SQL Anywhere 5.5 has not been tested against PB 11.5.1. However, there 
is no reason that I can think that this would not work.

What specific version and build of SA5.5 and PB 11.0.1 are you using? I 
am testing with 5.5.05 Build #2817 and PB 11.0.1.4011 and I am not able 
to reproduce the behaviou using the steps to repro that you provided.

NOTE: it is not the PB internal change to UNICODE in case someone 
attempts to claim that to be the issue :-)

-chris

Jerry wrote:
> When I open a datawindow in the datawindow painter and click
> Design>Data Source I get the following error message: SQLSTATE = 37000
> [Sybase][ODBC Driver] Syntax error: unknown function 'user_id'
> 
> The heading on the message is GetTriggers. I do not have any triggers
> on this database. I get the same error regardless of the datawindow I
> open when I click Data Source. I click OK and it seems to be okay but
> not 100% sure. Any help would be appreciated.
> 
> Thanks
> Jerry
0
Chris
11/30/2009 6:19:35 PM
Reply:

Similar Artilces:

PB 10.5 to PB 11.5 and EAserver 5.5
What are the steps to migrate from PB 10.5 to PB 11.5? I migrated the source code. What do I need to do on the serverside - I assume regenerating the proxies. Anything else? Where is the correct place for the PBVMs? 10.5's are located in the shared folder. TIA, Kevin Deploy to the server and regenerate the proxies. You can do a pbvm-only install of 11.5. Alternatively, copying the pbvm's into the shared folder shoulod work, though. -- Regards, Millard[TeamSybase] "Kevin Berez" <kaberezNOSPAM@mindspring.com> wrote in message news:...

OpenSuSE 11.4 -> 11.5 with myaql upgrade from 5.1 to 5.5
Hi! I have upgraded my OpenSuSE-11.4 to 12.1 which includes an upgrade of my mysql from 5.1 to 5.5 and I have made a big mistake and not made an mysqldump of my database. Unfortunately now my mysql isn't starting and I get the message: 120409 16:27:38 InnoDB: The InnoDB memory heap is disabled 120409 16:27:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120409 16:27:38 InnoDB: Compressed tables use zlib 1.2.5 120409 16:27:38 InnoDB: Initializing buffer pool, size = 128.0M 120409 16:27:38 InnoDB: Completed initialization of buffer pool 120409 16:27:38 InnoDB: highe...

Intellisync 5.1.1 and GroupWise 5.5.5
I am trying to sychronize my Palm to-do list with Groupwise. When I sync I get one of two error messages in a dialog labled "Pilot connector." The messages are "Unable to read application data" or "Unable to complete translataion. I tried the solution in "Answer ID 1737" (clearing "log" file etc and resyncing). I also cleared all the tasks out of Groupwise and ran GWCHK32 and made sure the account database was not corrupted (I'm the GroupWise Admin). Upon syncing I still got the "translation" message. A single task appear...

Upgrading 5.5.5 to 6.5.5
I am going to be upgrading from GW 5.5.5 to GW6.5.5 Anybody aware of any gotcha's or have any advice? LauraB@itdynamics.co.za wrote: > I am going to be upgrading from GW 5.5.5 to GW6.5.5 Anybody aware of > any gotcha's or have any advice? Not really. Before you upgrade rebuilt the post offices and domains or do at least a validate of the databases. If you are not really experienced I recommend to purchase the caledonia upgrade guide. -- Cheers, Edward ...

Saving datawindow from PB 11.5.1 into PB 11.1 format (syntax)?
Hello, Is there any possible way to save a datawindow created & written in PB 11.5.1 in the exact datawindow format/sytnax of previous version(s), namely 11.1? Reason being is that we have an application that is still not migrated from 11.1 to 11.5.1, and we have to write a custom report for it urgently. Out application can import the exported SRD datawindow report and store its syntax in the table & run it from there. Unfortunately, it complains about incorrect release number (11.5, rather than 11.1, and I have already tried just to change the version number - more...

Support of PB 11.5.1 datawindow syntax in DW.NET 2.5
Hello, we have migrated our PowerBuilder development to PowerBuilder 11.5.1. Until now, we were simultaneously using our datawindows (developed in PB for our main Client/Server app) in ASP.NET application with Datawindow.NET. Now, when trying to use datawindow from PB 11.5.1 in DW.NET, we are getting error: "Line 2 Column 65; incorect syntax." I assume that DW.NET 2.5 does not support PB 11.5.1 datawindow syntax yet. Is there any workaround for this issue, or will there be a newer DW.NET release supporting this new datawindow syntax? LM use C:\Program Files\Sybase\...

Smoke [5.11.5] v5.11.5-89-gab8e66c FAIL(XF) netbsd 5.0.2 (i386/1 cpu)
Automated smoke report for 5.11.5 patch ab8e66c141d8d7d892995deba69405e747204cf0 v5.11.5-89-gab8e66c p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.2 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 6 hours 40 minutes (average 50 minutes 3 seconds) Summary: FAIL(XF) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = ma...

Smoke [5.11.5] v5.11.5-82-g79b7484 FAIL(XF) netbsd 5.0.2 (i386/1 cpu)
Automated smoke report for 5.11.5 patch 79b7484367aeaeee65e60704dd06273cfca231b9 v5.11.5-82-g79b7484 p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.2 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 6 hours 37 minutes (average 49 minutes 43 seconds) Summary: FAIL(XF) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = m...

Smoke [5.11.5] v5.11.5-27-ga42901a FAIL(XM) netbsd 5.0.2 (i386/1 cpu)
Automated smoke report for 5.11.5 patch a42901aff3d8b1b6b3eecdf30fe579a4456c4ca8 v5.11.5-27-ga42901a p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.2 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 5 hours 50 minutes (average 43 minutes 51 seconds) Summary: FAIL(XM) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = m...

Smoke [5.11.5] v5.11.5-91-g0fa4a26 FAIL(XF) netbsd 5.0.2 (i386/1 cpu)
Automated smoke report for 5.11.5 patch 0fa4a26596a4646f9aae1dcd199a2f30933e6f01 v5.11.5-91-g0fa4a26 p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.2 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 6 hours 34 minutes (average 49 minutes 17 seconds) Summary: FAIL(XF) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = m...

Smoke [5.11.5] v5.11.5-51-gb09c05e FAIL(XF) netbsd 5.0.2 (i386/1 cpu)
Automated smoke report for 5.11.5 patch b09c05e65698d8bad3544ae2c60fdbf601f0fa72 v5.11.5-51-gb09c05e p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.2 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 6 hours 35 minutes (average 49 minutes 26 seconds) Summary: FAIL(XF) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = m...

PB 6.5.1 + Y2K Patch Regression Bug (was SQLAnywhere 5.5 Column Not Taking Integer)
After looking deeper into my problems (see 'SQLAnywhere 5.5 Column Not Taking Integer), I contacted tech support this morning. The bug affects not only UPDATE statements with a WHERE clause, but actually _all_ static SQL statements that have a where clause involving a comparison to a variable. This has been repeated with the AdaptSrvAny 6.0 backend. My system and the ASA system at Sybase are both using the _ODBC_ driver, so this appears to be the early culprit. This problem is verified as non-existant on initial PB 6.5 build. Obviously, this bug has occurred somewhere betwe...

SQLAnywhere 5.5.04ebf(1868), 5.5.05
Hello! I have recieved message from "owner-inews-tech-sqlanywhere@sybase.com" with Subject "Delphi users". Where can I obtain new ebf(s)? I found only 5.5.03 in the Software library. (http://support.sybase.com/esd/sqlany.html) ==== Subject: Bug Fix / Enhancement (PTrack 479443) - .... Summary: Delphi can't insert Blobs > 32k - SQLBindParameter only inserted the first 32k of a given buffer. Versions affected: 5.5.x Versions fixed: 5.5.04ebf(1868), 5.5.05 P4 change number: 52135, 52298 Modules affected: wod50 .... === You'll have to contact Tech ...

Smoke [5.11.5] v5.11.5-1-g79cf6d1 FAIL(F) MSWin32 Win2000 SP4 (x86/1 cpu)
Automated smoke report for 5.11.5 patch 79cf6d147ddb45df8d4a108b442c4a9707a= 4061d v5.11.5-1-g79cf6d1 perl-win2k: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz(~2672 MHz) (x86/1 cpu) on MSWin32 - Win2000 SP4 using cl version 14.00.50727.762 smoketime 4 hours 22 minutes (average 32 minutes 50 seconds) Summary: FAIL(F) O =3D OK F =3D Failure(s), extended report at the bottom X =3D Failure(s) under TEST but not under harness ? =3D still running or test results not (yet) available Build failures during: - =3D unknown or N/A c =3D Configure, m =3D make, M =3D m...

Web resources about - PB 11.5.1 and SqlAnywhere 5.5 - sybase.powerbuilder.datawindow

IBM Tivoli Storage Manager - Wikipedia, the free encyclopedia
IBM Tivoli Storage Manager ( TSM or ITSM ) is a centralized, policy-based, enterprise class, data backup and recovery package. The software enables ...

Archives - Caelum's Blog
Caelum's Blog Random Stuff Navigation Home - Articles Tags 256colors 64 64bit 8 activeperl activestate advent ajax alsa amd64 asa asus automation ...

keynote bingo - Google Search
Search Images Maps Play YouTube News Gmail Drive More Calendar Translate Mobile Books Wallet Shopping Blogger Finance Photos Videos Even more ...

Mobile and Wireless Partners - Partners - Sybase Inc
Thanks for visiting the Partners section of Sybase.com. Here you will find information about Mobile and Wireless Partners - Partners. For more ...

Datensynchronisierung - sqlanywhere
„Good Partner - quick and reliable answers! Fast "delivery" by Email. Everybody can count on them." Tímea Steigervald, Product Manager Kvazar-Micro ...

Browse file extension list beginning with letter A
Browse file extension list beginning with letter A - File-Extensions.org search page

OpenLink ODBC Adapter for Ruby on Rails: OpenLink ODBC Adapter for Ruby on Rails: Downloads
OpenLink ODBC Adapter for Ruby on Rails: OpenLink ODBC Adapter for Ruby on Rails: Downloads

Developer Edition - sqlanywhere
„Good Partner - quick and reliable answers! Fast "delivery" by Email. Everybody can count on them." Tímea Steigervald, Product Manager Kvazar-Micro ...

IBM - sqlanywhere
„Good Partner - quick and reliable answers! Fast "delivery" by Email. Everybody can count on them." Tímea Steigervald, Product Manager Kvazar-Micro ...

Datenaustausch - sqlanywhere
„Good Partner - quick and reliable answers! Fast "delivery" by Email. Everybody can count on them." Tímea Steigervald, Product Manager Kvazar-Micro ...

Resources last updated: 1/16/2016 5:58:11 PM