Sybase Sql Anywhere Studio 9.0.2
admin 6/6/2019
Migration asa 7.0.4 a asa 9.0.2
I'm making a sybase migration 7.0.4 to sybase 9.0.2, I already made the migration of the database but when trying to connect, with you line them next, it leaves the error -75, and says that I don't have permits. I'm using codewarrior 8 int ConectarDB (void) /*********************/ { db_init (&sqlca); ULEnablePalmRecordDB( &sqlca ); EXEC SQL CONNECT 'dba' IDENTIFIED BY 'sql'; return (SQLCODE); } I'm making something bad. 'Luis Ponce Ibarra - Hotmail' <luisponceibarra@hotmail.com> wrote in ..
PDM: Modify ASA 7.0.4 and ASA 9.0.4
Hi everyone, I need to use a single PD Model to generate modifications for both ASA7 and ASA9. Since ASA 9 supports a CLUSTERD INDEX, and the query optimizer uses indexes differently from ASA7 (not always for good), I would like to generate clustered indexes for ASA9, but stay with the standard index when generating for ASA7. Has anyone ever tried something alike? tia Reimer You can't use a single model this way. Each model has to have a single DBMS target. -- Mike Nicewarner [TeamSybase] http://www.datamodel.org mike[at]datamodel[dot]org (can you figure what to..
ASA 7.0.0 to asa 7.0.3
How can I upgrade ASA 7.0.0 to ASA 7.0.3? Can I download ASA 7.0.3 full install if I've got ASA 7.0.0 full install package? Yuri Isaenko ICQ#: 114279655 Download the 'Adaptive Server Anywhere - Maintenance Release (English), Upgrade of 7.0.x to 7.0.3' from my.sybase.com. You will have to increase the 'Time Frame' value to see it. Breck On Thu, 9 May 2002 00:26:09 +0200, 'YI' <yi@gor.kv.energy.gov.ua> wrote: >How can I upgrade ASA 7.0.0 to ASA 7.0.3? >Can I download ASA 7.0.3 full install if I've got ASA 7.0.0 full inst..
rebuild in ASA 9.0.2 after transition from 7.0.4.
Hi again, Firstly, thanks for your replies. However, I guess that I mentioned the problem wrongly. I successfully transferred our old 7.0.4. Database to 9.0.2. environment (unload in 7.0.4.=>create a new db in 9.0.2.=>reload in 9.0.2.). All our programs run almost properly with this new version DB. After one week, I wanted to apply unload/reload operation in 9.0.2. environment for this upgraded database. I used Sybase Central v4.3 for unload and the active user had DBA authority. During this operation, several errors occured. 1. during reload, It says that some system tab..
ASA 7.0.2/ 1462 replicating vias RS 12.5 to ASA 7.0.2 / 1462
Greetings group, I need your help. Working on setting up Subscription based replication in the following manner: ASA 7.0.2 / 1462 (aka PDB) Repserver 12.5 ..
ASA 9.0.0 and 9.0.2 On the Same Computer
Is it possible to maintain two versions of ASA on the same computer? I need to have 9.0.0 and 9.0.2 on the same server. Do you want to run both versions at the same time? -- Reg Domaratzki, Sybase iAnywhere Solutions Sybase Certified Professional - Sybase ASA Developer Version 8 Please reply only to the newsgroup iAnywhere Developer Community : http://www.ianywhere.com/developer iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do -> Choose SQL Anywhere Studio -> Set filter to &q..
Migrating ASA 9.0.2 to SQL Anywhere 12.0.0
Hello all..Does anyone know if it is possible to directly migrate ASA 9.0.2 to SQL Anywhere 12.0.0? Hello Mark, 'Directly' is a bit of a loose term, but yes, you can migrate ASA 9 'directly' to SA 12. You will have to minimally rebuild your 9.0.x databases to be run on 12.0.x database servers. We also would expect that you thoroughly regression test your application against the new software version as there have been many behaviour changes and enhancements made since 9.0.2. I'd highly recommend reading the 'Changes and Features' section in ..
Is ASA 7.0.4 the last maintenace release or is there going to be a ASA 7.0.5?
There are no specific plans at this time to release a 7.0.5 patch. Is there something specific that you are looking for? -- ----------------------------------------------- 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://casexpress.sybase.com/cx/cx.stm SQL Anywhere Studio Supported Platforms and S..
Cursor problem migrate ASA 6.0.2.2188 --> ASA 8.0.2.3601
Hi, I resubmit this problem that I cannot solve. I resubmit a bit of code too. The following procedure worked fine with a ASA 6.0.2.2188 database. Specification of the server : Win2000. Database converted succesfully from 6.0.2.2188 to 8.0.2.3601 I was only one working with these tables. No other parallel task. Only this procedure. The main problem is that I read data in a cursor from 2 diffrent Tables. Then, I update 1 of the 2 table by an positionned update. The cursor is correctly read. The procedure blocked at the update statement. The only way to..
question : upgrade from ASA 9.0.1 build 1975 to ASA 9.0.2 build 2551
This is a multi-part message in MIME format. ------=_NextPart_000_004A_01C51418.8836CAB0 Content-Type: text/plain; charset='iso-8859-1' Content-Transfer-Encoding: quoted-printable When upgrading from ASA 9.0.1 to ASA 9.0.2 is it critical that the = database be unloaded and reloaded or can just the software be updated? Thanks, Dave ------=_NextPart_000_004A_01C51418.8836CAB0 Content-Type: text/html; charset='iso-8859-1' Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.0 Transitional//EN'> <HTML..
Found many bugs in ASA 7.0 / Difference between ASA 7.0 and ASA 6.03
Hello, I plan to upgrade my database from ASA 6.03 to ASA 7.0. I have made some compatible tests before I will upgrade and so I have found some bugs respectively difference between ASA 6.03 and ASA 7.00. I should remark that I have installed the 'Emergency Bug Fixes' for ASA 7.00. 1. The dbs returns wrong table name by a join statement over two tables. Example: select a.field1 from a, b where a.field1 = b.field1 The table name of the first field must be 'a.field1' but the dbs returns 'b.field2'. 2. Field name is distorted in views. This is dependen..
No Timezone Selectable using TB 2.0.22, Contacts Sidebar 0.7.1 , Lightning 0.9 & Ubuntu 9.0.4
Hi, In several new TB 2.0.22, I noticed that you can not select the TimeZone. I'm Using the following add-ons for Linux: Contacts Sidebar 0.7.1 Lightning 0.9 I'm get TB using apt-get install thunderbird Using Ubuntu 9.0.4 32bit The following erros occurrs: When I open TB the calendar toolbar doesn't open automatically. I cannot select the TimeZone, when I open TB It doesnt show the Date Column correctly. Look at those images: No Timezone selectable image: http://img12.imageshack.us/img12/4828/screenshotthunderbirdpr.png or http://yfrog.com/0cscreenshotthunder..
Converting UL/ML/ASA 7.0.2 application to ASA 8.0
Hello, I'm currently running an UltraLite/Mobilink/ASA 7.0.2 application, and I am trying to upgrade to ASA 8.0. The Ultralite application is running on a PocketPC Symbol PPT 2840. After running the ASA 8.0 and MobiLink 8.0 engines against the 7.0.2 db, and not changing any of the previous ultralite code or mobilink scripts, I am getting the following from the MobiLink server. Immediately after the synchronization request I am getting an ODBC error. I can not determine what is wrong. Any information you can provide would be very much appreciated. I. 05/29 14:25:30. Adaptiv..
[Fwd: Re: No Timezone Selectable using TB 2.0.22, Contacts Sidebar 0.7.1 , Lightning 0.9 & Ubuntu 9.0.4]
Hi Stefan, I installed the required packages and works. Thanks, Paulo S�rgio Correia Warning: This e-mail attachments can contain the ODF format (Open Document Format) / ABNT. Before asking the attachments in another format, you can install OpenOffice (http://www.openoffice.org) or the following Plugin for Microsoft Office (http://www.sun.com/software/star/odf_plugin/get.jsp) Protect the Forest and your money: only print if necessary. Use the Econofont (http://www.ecofont.eu/ecofont_en.html). Not to Monopoly: Use Programs Open Source / Freeware. Linux user # 490..
I'm making a sybase migration 7.0.4 to sybase 9.0.2, I already made the migration of the database but when trying to connect, with you line them next, it leaves the error -75, and says that I don't have permits. I'm using codewarrior 8 int ConectarDB (void) /*********************/ { db_init (&sqlca); ULEnablePalmRecordDB( &sqlca ); EXEC SQL CONNECT 'dba' IDENTIFIED BY 'sql'; return (SQLCODE); } I'm making something bad. 'Luis Ponce Ibarra - Hotmail' <luisponceibarra@hotmail.com> wrote in ..
PDM: Modify ASA 7.0.4 and ASA 9.0.4
Hi everyone, I need to use a single PD Model to generate modifications for both ASA7 and ASA9. Since ASA 9 supports a CLUSTERD INDEX, and the query optimizer uses indexes differently from ASA7 (not always for good), I would like to generate clustered indexes for ASA9, but stay with the standard index when generating for ASA7. Has anyone ever tried something alike? tia Reimer You can't use a single model this way. Each model has to have a single DBMS target. -- Mike Nicewarner [TeamSybase] http://www.datamodel.org mike[at]datamodel[dot]org (can you figure what to..
ASA 7.0.0 to asa 7.0.3
How can I upgrade ASA 7.0.0 to ASA 7.0.3? Can I download ASA 7.0.3 full install if I've got ASA 7.0.0 full install package? Yuri Isaenko ICQ#: 114279655 Download the 'Adaptive Server Anywhere - Maintenance Release (English), Upgrade of 7.0.x to 7.0.3' from my.sybase.com. You will have to increase the 'Time Frame' value to see it. Breck On Thu, 9 May 2002 00:26:09 +0200, 'YI' <yi@gor.kv.energy.gov.ua> wrote: >How can I upgrade ASA 7.0.0 to ASA 7.0.3? >Can I download ASA 7.0.3 full install if I've got ASA 7.0.0 full inst..
rebuild in ASA 9.0.2 after transition from 7.0.4.
Hi again, Firstly, thanks for your replies. However, I guess that I mentioned the problem wrongly. I successfully transferred our old 7.0.4. Database to 9.0.2. environment (unload in 7.0.4.=>create a new db in 9.0.2.=>reload in 9.0.2.). All our programs run almost properly with this new version DB. After one week, I wanted to apply unload/reload operation in 9.0.2. environment for this upgraded database. I used Sybase Central v4.3 for unload and the active user had DBA authority. During this operation, several errors occured. 1. during reload, It says that some system tab..
ASA 7.0.2/ 1462 replicating vias RS 12.5 to ASA 7.0.2 / 1462
Greetings group, I need your help. Working on setting up Subscription based replication in the following manner: ASA 7.0.2 / 1462 (aka PDB) Repserver 12.5 ..
ASA 9.0.0 and 9.0.2 On the Same Computer
Is it possible to maintain two versions of ASA on the same computer? I need to have 9.0.0 and 9.0.2 on the same server. Do you want to run both versions at the same time? -- Reg Domaratzki, Sybase iAnywhere Solutions Sybase Certified Professional - Sybase ASA Developer Version 8 Please reply only to the newsgroup iAnywhere Developer Community : http://www.ianywhere.com/developer iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do -> Choose SQL Anywhere Studio -> Set filter to &q..
Migrating ASA 9.0.2 to SQL Anywhere 12.0.0
Hello all..Does anyone know if it is possible to directly migrate ASA 9.0.2 to SQL Anywhere 12.0.0? Hello Mark, 'Directly' is a bit of a loose term, but yes, you can migrate ASA 9 'directly' to SA 12. You will have to minimally rebuild your 9.0.x databases to be run on 12.0.x database servers. We also would expect that you thoroughly regression test your application against the new software version as there have been many behaviour changes and enhancements made since 9.0.2. I'd highly recommend reading the 'Changes and Features' section in ..
Is ASA 7.0.4 the last maintenace release or is there going to be a ASA 7.0.5?
There are no specific plans at this time to release a 7.0.5 patch. Is there something specific that you are looking for? -- ----------------------------------------------- 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://casexpress.sybase.com/cx/cx.stm SQL Anywhere Studio Supported Platforms and S..
Cursor problem migrate ASA 6.0.2.2188 --> ASA 8.0.2.3601
Hi, I resubmit this problem that I cannot solve. I resubmit a bit of code too. The following procedure worked fine with a ASA 6.0.2.2188 database. Specification of the server : Win2000. Database converted succesfully from 6.0.2.2188 to 8.0.2.3601 I was only one working with these tables. No other parallel task. Only this procedure. The main problem is that I read data in a cursor from 2 diffrent Tables. Then, I update 1 of the 2 table by an positionned update. The cursor is correctly read. The procedure blocked at the update statement. The only way to..
question : upgrade from ASA 9.0.1 build 1975 to ASA 9.0.2 build 2551
This is a multi-part message in MIME format. ------=_NextPart_000_004A_01C51418.8836CAB0 Content-Type: text/plain; charset='iso-8859-1' Content-Transfer-Encoding: quoted-printable When upgrading from ASA 9.0.1 to ASA 9.0.2 is it critical that the = database be unloaded and reloaded or can just the software be updated? Thanks, Dave ------=_NextPart_000_004A_01C51418.8836CAB0 Content-Type: text/html; charset='iso-8859-1' Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.0 Transitional//EN'> <HTML..
Found many bugs in ASA 7.0 / Difference between ASA 7.0 and ASA 6.03
Hello, I plan to upgrade my database from ASA 6.03 to ASA 7.0. I have made some compatible tests before I will upgrade and so I have found some bugs respectively difference between ASA 6.03 and ASA 7.00. I should remark that I have installed the 'Emergency Bug Fixes' for ASA 7.00. 1. The dbs returns wrong table name by a join statement over two tables. Example: select a.field1 from a, b where a.field1 = b.field1 The table name of the first field must be 'a.field1' but the dbs returns 'b.field2'. 2. Field name is distorted in views. This is dependen..
No Timezone Selectable using TB 2.0.22, Contacts Sidebar 0.7.1 , Lightning 0.9 & Ubuntu 9.0.4
Hi, In several new TB 2.0.22, I noticed that you can not select the TimeZone. I'm Using the following add-ons for Linux: Contacts Sidebar 0.7.1 Lightning 0.9 I'm get TB using apt-get install thunderbird Using Ubuntu 9.0.4 32bit The following erros occurrs: When I open TB the calendar toolbar doesn't open automatically. I cannot select the TimeZone, when I open TB It doesnt show the Date Column correctly. Look at those images: No Timezone selectable image: http://img12.imageshack.us/img12/4828/screenshotthunderbirdpr.png or http://yfrog.com/0cscreenshotthunder..
Converting UL/ML/ASA 7.0.2 application to ASA 8.0
Hello, I'm currently running an UltraLite/Mobilink/ASA 7.0.2 application, and I am trying to upgrade to ASA 8.0. The Ultralite application is running on a PocketPC Symbol PPT 2840. After running the ASA 8.0 and MobiLink 8.0 engines against the 7.0.2 db, and not changing any of the previous ultralite code or mobilink scripts, I am getting the following from the MobiLink server. Immediately after the synchronization request I am getting an ODBC error. I can not determine what is wrong. Any information you can provide would be very much appreciated. I. 05/29 14:25:30. Adaptiv..
[Fwd: Re: No Timezone Selectable using TB 2.0.22, Contacts Sidebar 0.7.1 , Lightning 0.9 & Ubuntu 9.0.4]
Hi Stefan, I installed the required packages and works. Thanks, Paulo S�rgio Correia Warning: This e-mail attachments can contain the ODF format (Open Document Format) / ABNT. Before asking the attachments in another format, you can install OpenOffice (http://www.openoffice.org) or the following Plugin for Microsoft Office (http://www.sun.com/software/star/odf_plugin/get.jsp) Protect the Forest and your money: only print if necessary. Use the Econofont (http://www.ecofont.eu/ecofont_en.html). Not to Monopoly: Use Programs Open Source / Freeware. Linux user # 490..
Sybase Sql Anywhere 10 Download
Wind river workbench. Dec 11, 2015 - sybase.sqlanywhere.general 32637 articles. Documentation if you haven't already: What's New in SQL Anywhere Studio Upgrading Software. Adaptive Server Anywhere 9.0.2 Contents. Adaptive Server Anywhere Database Administration Guide; Adaptive Server Anywhere Error Messages; Adaptive Server Anywhere.