Hello, i have intalled ODBC Oracle 9. The connection test is ok in ODBC manager, but failed in SQL10. I will to connect a server proxy via my ODBC...

jc

11-28-2007 04:43 AM
jc

I repost my problem because nobody answered till now. I'm using Visual Studio 2005 express editions including VB, VC# and Web Developer. I...

Laszlo Mamrovits

11-27-2007 04:30 PM
Laszlo Mamrovits

Hi, I want to connect to ASA 8.0.3 using the ENP (EncryptedPassword) connection parameter. Does anyone know how to get the encrypted...

Iaacov

11-27-2007 03:11 PM
Volker Barth

I want to rebuild an ASA6 database with a specific CodePage (CP850) to SQL Anywhere 10.0.1 CP 1252. Workaround wit -ct switch for dbengine doesn't...

Mike

11-27-2007 02:04 PM
Frank Ploessel

I'm getting an error 453 when opening a database in vb.net using 10.0.1.3579: Unable to find entry point 'AsaConnection_IsAlive' in DLL dbdata.dll. ...

Jeffery Partridge

11-27-2007 01:01 PM
Nick Elson

Is there an option in SQL Anywhere 9.02 to specify the port a database starts off with? I know that the first database always starts off with port...

Omar

11-27-2007 12:52 PM
Nick Elson

Consider the table: create table mytable( id int primary key autoincrement, key varchar(20) not null, lang char(2) not null, country char (2)...

todd

11-27-2007 12:52 PM
Nick Elson

We are using SQLAnywherev9.02.3576 and occassionally (once every two weeks or so) get this error (or a very similar error): "Central01: *** ERROR...

bgreiman@bernicks.com

11-27-2007 11:24 AM
John Smirnios

Hi All, Is there a way to retrieve the value of @@identity global variable while in a stored proc with no risk of its value changing due another...

Bhaskar

11-27-2007 10:31 AM
Bhaskar

Sybase Adaptive Server Anywhere Database Engine Version 8.0.2.4258 Is it possble to start / stop the database service and the dbremote service from...

TPS

11-27-2007 07:44 AM
taroz

Dear all I want to write a SP to insert some new record and those new reocrd has input into an temp_table call "new_rec" So if I want to check...

K2

11-27-2007 06:28 AM
Dmitri

I have applied EBF 3581 for SQL Anywhere 9.02 and my Sybase based application can no longer connect to the database. The problem is in the connection...

Dominik

11-25-2007 06:24 PM
Dominik

In my book the trigger is not behaving correctly on either database. You seemed to have coded to a parser bug and are getting 2 different...

JSCARLSON

11-23-2007 05:13 PM
Nick Elson

Hi all, is it possible to create a materialized view based on some base table with computed columns based on a user-defined function? I thought...

Volker Barth

11-23-2007 09:48 AM
Volker Barth

I'd like create one server proxy in ASA10 to connect ORACLE 8i db remote. On Windows 2000 it's OK, but failed on XP pro sp2. on XP. Error message...

jc

11-23-2007 06:49 AM
jc

Dear all, I have an ASA9 server and now I want to output some sales data from the DB server to a text file. So how I can output a text file with a...

K2

11-22-2007 10:37 PM
K2

Hi I use database where globalid = 10 and one column is global autoincrement and this type is bigint. Now i can't adding record to this table because...

Fantom

11-22-2007 02:25 PM
Fantom

I buy ASA10 and i want use debug mode. I connect to database, select procedure, set breakpoints and button GO is inactive. What i must do ? Fantom

Fantom

11-22-2007 12:58 PM
Fantom

I write in first post : i have thousends statement of this type. Fantom

Fantom

11-22-2007 11:44 AM
Rob Waywell

Hi, What are the min. system requirements for sybase v10 with mobilink v10 running on a laptop? Can it be that 250Mb of int. memory gives...

john

11-22-2007 11:42 AM
Chris Keating (Sybase iAnywhere)

Hello everybody, I have a problem with my current installation of Sybase. When I press Start->Programs->Sybase Central the mouse cursor turns in the...

Elisabetta

11-22-2007 05:31 AM
liezlnel@gmail.com

ASA 9.0.2.3527 I wrote a script which opened a passthrough session, created a stored procedure for DBA and then created an event, with schedule, to...

youcantryreachingme

11-21-2007 06:16 PM
youcantryreachingme

If we have a stored procedure named dba.foo in database A, and dba.foo issues DML statements to a table in database B via a proxy table, is there any...

Laurie Johnson

11-21-2007 06:01 PM
Nick Elson

I would definitely suggest using ODBC over JDBC for performance reasons. In this sample, I'm assuming that the SQL Anywhere driver has been...

Jim Douglas

11-21-2007 04:56 PM
Jim Douglas

I have a table in my db (ASA 9.0.2.2451) that is getting its rows out of order. The db was originally ASA 7 and has been upgraded to...

Heather K.

11-21-2007 02:46 PM
Frank Ploessel

Hi we're running the SQL Anywhere 10 DB as HTTP server using stored procedures for business logic. When trying to authenticate the client connection...

Arthur Hefti

11-21-2007 09:52 AM
Arthur Hefti

I use function week but it always return incorrect week. example select week ('2007-01-01','2007-01-03') returns week 0 instead of week 1 select...

Raymundo Betancourt

11-21-2007 02:18 AM
Richard Biffl

I have upgraded a Netware 6.5 server from 5.5 sqlanywhere to 8.03 5444. For what seems like no reason at all the server now abends without warning. ...

Snelbert

11-20-2007 05:40 PM
Snelbert

Hi, I'm running a select statement on a view joined with a temp table. In 2 databases it's running very fast and in 1 database it's slow. I've found...

Frank Vestjens

11-20-2007 11:36 AM
Glenn Paulley

The problem in the slow plan is likely the sequential scan of the temp table AC on the right-hand side of the nested-loop join ........

Glenn Paulley

11-20-2007 09:43 AM
Glenn Paulley

How to drop dbspace that does not exists anymore (it was deleted in the file system)? Real world example: I had very large table in dbspace "blob"....

Andrei Iliev

11-20-2007 07:28 AM
Andrei Iliev

Drop .world in the ODBC service name. .world only has context in the TNS file AFAIK and I am somewhat surprised that it was able to work in 9.x with...

jc

11-20-2007 04:36 AM
jc

Hi when i profiled my database i get this data : Number of Invocations,Total Time,Maximum Time,Issued...

Fantom

11-20-2007 04:22 AM
Fantom

Hello everybody, sorry to bug again but I have some more information on my problem. I have installed Sybase SQL Anywhere 8 (Licensed version...

Elisabetta

11-20-2007 04:18 AM
Elisabetta

Hello, I would like to verify whether anyone seen an issue with using syqanwhere 10 and hibernate for paging once query large tables. I'm using the...

Amit Tropper

11-20-2007 03:20 AM
Amit Tropper

hi, I have a client-server application with 150 concurrent users and every client installed sql anywhere client I have 2 or 3 questions, 1.With...

Johnny

11-19-2007 01:55 PM
Johnny

Hi, I have two questions please. In my installation script I use dbsvmn50.exe to create a service for AS Anywhere 8 as I cannot find an equivalent...

Gerry

11-19-2007 01:53 PM
Gerry

Hi, Requirement, Position Sybase DBA Location Lewiston Maine

Jay_Lgx

11-19-2007 10:19 AM
Jay_Lgx

Hello! I programmed with ADO.NET named Sybase.Data.AseClient that version is 1.15.50.0 By the way, connecting the server, error occur 'Internal...

Diainwater

11-19-2007 07:48 AM
Chris Keating (Sybase iAnywhere)

eg. new row inserted into DB fires off a command line batch file ?

andy

11-18-2007 11:20 AM

We are investigating various ways of creating audit shadow tables. I was wondering is there is some facility to asscoate an application id with...

Glenn Barber

11-17-2007 06:38 AM
Giorgio Papagno

I believe it is because you are attempting to set it for PUBLIC and are not logged in as the DBA or have DBA resource. If your try setting it...

Nick Elson

11-16-2007 05:36 PM
Nick Elson

Hi, I don't know if this is a good place to ask this but I have a problem that goes like this: I have created a proc (Proc A) that will call...

Soulless

11-16-2007 02:25 PM
Paul Horan[TeamSybase]

Hi everyone, Sometimes when a user tries to synchronize the authenticate_user script takes over 15 minutes to complete. The script calls a stored...

Ross Shnaper

11-16-2007 02:02 PM
Ross Shnaper

A colleague is running the following in ISQL (for ASA9.0.2.3527) ---------- create variable current_transaction varchar(30); set...

youcantryreachingme

11-16-2007 09:49 AM
Bruce Hay

hello, we have a table which will regularly undergo heavy data modifications. this table is not used on remote sites, only on the consolidated....

krisztian pinter

11-16-2007 03:41 AM
krisztian pinter

A colleague is running the following in ISQL (for ASA9.0.2.3527) ---------- create variable current_transaction varchar(30); set...

youcantryreachingme

11-15-2007 07:14 PM
youcantryreachingme

I have been killing myselft to find a way to have the Windows Scheduler shutdown and startup my database which uses Adaptive Server Anywhere. Can...

Mark

11-15-2007 04:28 PM
John Smirnios

I have been killing myselft to find a way to have the Windows Scheduler shutdown and startup my database which uses Adaptive Server Anywhere. Can...

Mark

11-15-2007 02:15 PM
Mark

Hey guys! I am working on a sybase 9.0.2.3137 database which is working but keeps giving errors during validation. I know that the database is...

SybaseInvestigator

11-15-2007 01:07 PM
SybaseInvestigator