I've upgraded our test client from 9.0.1.1922 ( windows ) to 9.0.2.2451 and I'm seeing a couple of oddities. first: Our application uses the...

ericrad

12-07-2004 02:54 PM
ericrad

Assertion failed: 201117 (8.0.2.4501) help please I do applying log dbsrv8 base.db -a base.log E. 12/02 13:39:48. Error: Database cannot be started...

Sergey Kondratiev

12-07-2004 02:50 PM
Nick Elson

I need to get input from those using ASA 9 in a Netware environment, I would think there are many who do still use Netware but I may be wrong. If...

Steve Miles

12-07-2004 11:59 AM
Snelbert

I have a fairly complex (fully indexed) view that is being used in a number of reports. The full SELECT command works well when the report...

Erik Anderson

12-07-2004 10:16 AM
Glenn Paulley

Is it possible to generate SQL scripts from Sybase Central? If not, what's the best way to do that? Thank you

Jim

12-07-2004 08:37 AM
Paul Horan[TeamSybase]

Hi, The size of the Database Log File keeps on growing after every transaction. Is there any way of controlling this? Is it okay if this can be...

Krishna

12-07-2004 08:30 AM
Reg Domaratzki \(iAnywhere Solutions\)

I currently have a dozen distributed replicas of an Access database, all of which synchronize with the master database over the net. My server,...

Matthew Snook

12-06-2004 08:04 PM
Greg Fenton

Is it possible to suppress the error prompting with the INPUT function in ASA or to have it just log it to a log file? TIA Thomas

Thomas

12-06-2004 07:39 PM
Greg Fenton

Is it possible using the OUTPUT function to specify the source table without having to perform a select statement on the source table first?...

Thomas

12-06-2004 07:35 PM
Greg Fenton

Hi, I'm very new to Sybase Anywhere products, though I'm fairly comfortable with databases in general. My task at hand is to migrate a 7 gig version...

computer.cook@cox.net

12-06-2004 04:40 PM
computer.cook@cox.net

If you're trying to run this from ISQL, then yes - there's a limit to the size of the script that it can process. You get around that by saving the...

Paul Horan[TeamSybase]

12-06-2004 09:46 AM
Breck Carter [TeamSybase]

I am using ASA 8.0.2 on windows. In a stored procedure I have a type 'timestamp' variable. I need the month, day, and year of this timestamp to be...

Phil.

12-06-2004 09:09 AM
Reg Domaratzki \(iAnywhere Solutions\)

We have a fixed-length record flat file that we would like to import into an ASA database. Can the BCP.exe utility be used against an ASA database...

Thomas

12-06-2004 08:58 AM
Reg Domaratzki \(iAnywhere Solutions\)

We have a ASA 8.0.2 Database server runs on Windows 2000 with SP 3 machine. We feed 500 double values into a table with an long integer as the...

Yasmin Yapa

12-05-2004 09:39 PM
Greg Fenton

One of the columns returned by the sa_conn_info procedure has a column heading "UncmtOps", which looks to me like "Uncommitted Operations". In fact,...

Seth Krieger

12-03-2004 05:48 PM
Seth Krieger

Hi folks, where is possibile to get the ODBC drivers for create a connection from a windows client to a SQL Anywhere7 database hosted on Solaris 8.x...

Julius_72

12-03-2004 03:24 PM
Julius_72

I actually don't know if this is a .NET driver issue, but it certainly seems to be. I have a stored procedure that gets called from C#. This...

John Davison

12-03-2004 12:41 PM
siB

Not sure if this is the correct newsgroup to ask, but I'm working with an ancient product here and am grasping at straws... I have an old PC...

Mark Peterson

12-03-2004 11:51 AM
Breck Carter [TeamSybase]

ASA 8.0.2.4339 Windows 2000 Server I'm trying to find an easy way for our application to detect if the last DBValid (and DBBackup) run was invalid. ...

Scott Huerta

12-03-2004 07:29 AM
Dave Westphal

We have Sybase SQL Anywhere V.6.0.3 running on Windows 2000 server. We have a web based HR application that gets information such as employee's name...

Pathwary

12-03-2004 06:33 AM
Graeme Perrow

Hi, Can anyone help, i am trying to extract data in a specific sequence into an ASCII file. SELECT ditm_modifieddate FROM data_items ORDER BY...

Stephen

12-02-2004 10:22 PM
Richard Biffl

Version = ASA 9.0.2.2451 (Developer) Network Server running as a service on XP SP2 I am trying to finalise my clients upgrade approach from ASA 6.04...

GeoffAtDatagaard

12-02-2004 08:43 PM
GeoffAtDatagaard

I have a SQL Anywhere 5.5 database that I would like to convert to ASA 7 then convert to SQL Anywhere Studio 9. If someone could tell me the steps...

Sheldon Thompson

12-02-2004 06:54 PM
Greg Fenton

ASA 8.0.2.4454 Windows XP SP1 We have a customer that is running group policies and as far as he knows nothing is restricted that would affect ASA...

Scott Huerta

12-02-2004 03:58 PM
Scott Huerta

Hi, Currently we are using the ASA 9.0.1.1899. we are synchronizing the data from the Oracle. It were transferred 15051 records for a table. Mobilink...

Baskar

12-02-2004 01:13 PM
Greg Fenton

Hi Everybody, My question is very simple : "Is There possible to send message (who display on the screen) to a specific user ?". I'm in ASA 7 and...

Allo

12-02-2004 12:22 PM
Allo

Hi Guys, Here in my office we use Sql anywhere 8.0 , and, I have to copy some data in a specific table using out source data! I have Import that...

hema

12-02-2004 08:33 AM
Greg Fenton

How can I get the IP-Address of a connection in a stored procedure ? I want log the ip-address in a table, when a user deletes rows in a...

Peter Müller

12-02-2004 07:55 AM
Nick Elson

I need to be able to call dbshrink and dbexpand from PowerBuilder. Currently I'm running them in a DOS window through PowerBuilder's Run command. Is...

Thom Lamb [ISUG]

12-02-2004 07:07 AM
Chris Keating \(iAnywhere Solutions\)

Is it possible to use the import command to include sql subscripts inside a larger master script? This command seems to be used in ASA system...

Daniel Borgenicht

12-02-2004 03:27 AM
Daniel Borgenicht

What possible steps do you take to troubleshoot when a network setting is getting disconnected from a server? We are getting an error code -308, and...

Steve

12-01-2004 08:32 PM
Greg Fenton

Just now my ASA 9.0.2.2451 server died without any visible reason. I then stopped the service and started it again which failed. dbeng9 Error: The...

Martin Baur

12-01-2004 06:18 PM
Martin Baur

I have a jar file that uses the IAnywhere JODBC driver. Inside my IDE (JBuilder) the jar runs ok. If I try to run the jar from the commandline I get...

Preston

12-01-2004 05:52 PM
Preston

Hi group, Anybody knows where I can find an example of an external stored procedure implementation for ASA (7.x if it is posible)? TIA, Andy...

Andy Neagu

12-01-2004 03:16 PM
Andy Neagu

Anyone know of a way to drop all fk's in an ASA db instead of one at a time? Does such a command exist? TIA Greg

12-01-2004 02:10 PM

Hey everyone, I am running into a rather large problem (for me) in 9.0.2.2451. It seems that the Number(*) and Identity() methods no longer work...

John De Lello

12-01-2004 11:38 AM
Ivan T. Bowman

I. 11/15 14:34:44. Connection assigned handle 1570562704 I. 11/15 14:34:44. Connection ID 2: AppInfo is HOST=POSTE-09;OS=Windows XP Build 2600...

Frederic Hoornaert

12-01-2004 09:07 AM
Chris Keating \(iAnywhere Solutions\)

Can anyone tell me what happens internally when a table is renamed (ALTER TABLE RENAME ...) . We have a problem when renaming a table with...

Justin Willey

12-01-2004 08:39 AM
anil k goel

ASA v9.0.1.1949 ASA v9.0.1.1983 Changed the following options: -- these two options are for synchronizing with sql server. set Option...

sirB

12-01-2004 08:21 AM
sirB

Hi! How can I rebuild the statistics in ASA7.0.3? - There is no function like CREATE STATISTICS. Thanks for the tipps! Best regards Thomas

Thomas Kehl

12-01-2004 06:39 AM
David Kerber

ASA 7.0.4, Win2K I'm executing a set of isql commands from a windows NT .cmd file (like a ..bat file). When I do this, is each statement going to...

David Kerber

11-30-2004 10:59 PM
Greg Fenton

Please tell me if this is possible. I want to create a stored procedure that will call other stored procedures, but I don't want the commit to...

Rob Giordano

11-30-2004 11:57 AM
Chris Keating \(iAnywhere Solutions\)

Most readers of this forum won't look at attachments. Either work directly with support to address this issue or copy the relevant information...

Chris Keating \(iAnywhere Solutions\)

11-30-2004 11:43 AM
Chris Keating \(iAnywhere Solutions\)

Have 3 db's in different locations and all have 5 perseat licenses. But only on one db I keep getting the error of connection limit exceeded. Have...

MJN

11-30-2004 09:08 AM
MJN

The 'What’s New in SQL Anywhere Studio' document specifies that "Support has been removed for storing data as Java objects. Support is maintained...

Derek Reiger

11-30-2004 06:50 AM
David Kerber

Looking for some C++ code samples using ADO on PPC 2003 second edition and eVC 4.0. Links? PPC should sync with ASA 7.0.x desktop database. Not...

Johan Karl Larsen

11-30-2004 05:24 AM
Johan Karl Larsen

Are there any issues with upgrading from v5.5 to v8.0.2? Customer wants to limit downtime and I don't want any surprises.

Tom Sweet

11-29-2004 08:40 PM
Greg Fenton

Hi ASA 9.0.2.2451 I have this table CREATE TABLE "DBA"."TEMPLATE" ( "TEMPLATE_ID" integer NOT NULL DEFAULT autoincrement, "KUNDE_ID" integer NOT...

Martin Baur

11-29-2004 05:07 PM
Martin Baur

In a network setting with 2 clients and a server. While logged into our application, a ODBC error will display randomly. The error message is...

Steve

11-29-2004 04:55 PM
sTEVE

Hey folks I tried to use INPUT out of interactive SQL. I read in the manual that this command is only available in interactive SQL. So what's an...

Ravage

11-29-2004 12:25 PM
Breck Carter