Hi all, We wish to use createcert in a script to automatically generate the ..pem/.crt files. However, the problem with calling createcert is that...

Shao Chan

03-20-2009 11:16 AM
Shao Chan

Is there any way of connecting to an OLEDB data provider with a Remote Server? I'm trying to access the Index Server OLEDB provider MSIDXS. I can...

Justin Willey

03-20-2009 11:13 AM
Karim Khamis [Sybase iAnywhere]

I have a user who is trying to install SQL Anywhere 10.0.1.3722. When the install wizard starts, they immediately get the following error...

Jon Owens

03-20-2009 10:41 AM
Jeff Albion [Sybase iAnywhere]

SQL Anywhere 11.0.1. + EEC Encryption bolt on. Hi all, I am slightly confused with partly the naming convention of certificates and keys for...

Shao Chan

03-20-2009 02:32 AM
Shao Chan

So I've been fumbling through our database trying to determine why the dbunload would not work using the -ar switch. Need to keep...

Jeff Gibson

03-19-2009 11:31 AM
Nick Elson [Sybase iAnywhere]

We plan to use database mirroring on ASA version 11.0.1.2044 and would like to know if the materialized view gets update on the mirror server...

Rachan Terrell

03-19-2009 10:41 AM
anil k goel [Sybase]

Hi - All, I want to be able to access the ENCRYPT and DECRYPT functions which are available in SQL. I want to use these functions outside of the...

Alastair Walker

03-19-2009 03:26 AM
Alastair Walker

Hi all, I am running mirroring across our WAN, ASA version 11.0.1.2044, synchronous mode, with DBRemote on Primary Server. The mirroring appears to...

falsedawn@hotmail.com

03-18-2009 01:09 PM
falsedawn@hotmail.com

SQL A 11.0.1 Hi all, We're looking into the possibility of using the OEM licence we have for authenticated databases. Upon database creation, we...

Shao Chan

03-18-2009 06:55 AM
Shao Chan

Hello, I'm using Windows 2003 Server ASA 9.0.2 Apache/2.2.4 (Win32) PHP/5.2.5 mod_jk/1.2.25 php-5.2.5_sqlanywhere9.dll The...

Peter56

03-18-2009 05:15 AM
Breck Carter [TeamSybase]

You can try to manually register the DLL using regsvr32. Did you reboot the machine after the install? -- Joshua Savill Sybase Inc. - Product...

Josh Savill [Sybase]

03-17-2009 04:18 PM
Tejo

I cannot compare the two queries because they are different and they return different number of rows (V10 returns 17,262, while V11 returns...

Rachan Terrell

03-17-2009 02:20 PM
Rachan Terrell

ASA v 10.0.1.3835 ASP.NET 2.0 app with NHibernate 2.0.1.400 We have 2 customers having similar errors when accessing ASA database through web apps....

PGP

03-17-2009 02:15 PM
Andrei Iliev

Does anyone know if the LOG file in Sybase Adaptive Server Anywhere would be VSS compatible? I assume it is becasue it's a simple log file but...

Johnny Lightning

03-17-2009 01:19 PM
Breck Carter [TeamSybase]

ASA 8.0.3.5574 Hi, I installed a dbsrv8 server on a win 2008 server and then registered it as a service with dbsvc.exe. Actually the service is...

Fabian Knauf

03-17-2009 09:08 AM
John Smirnios [Sybase]

The MobiLink 10 Performance white paper has been released: http://www.sybase.com/detail?id=1009664 -- Joshua Savill Sybase Inc. - Product Manager

Josh Savill [Sybase]

03-17-2009 08:01 AM
Josh Savill [Sybase]

I have a stored procedure which inserts a row into a table and then uses @@identity to get the identity of the last inserted row. However, @@identity...

Ralph

03-17-2009 07:23 AM
Ralph

We have a client that uses Pervasive SQL 9. We tried to create a remote connection to the database using the ODBC driver they supplied to a...

Bill Williams

03-17-2009 06:50 AM
Karim Khamis [Sybase iAnywhere]

SQL Anywhere 11.0.1. Hi all, I am using createcert to create a certificate. I can type: createcert < myEntries.txt to redirect input from a text...

Shao Chan

03-17-2009 03:34 AM
Shao Chan

Sometimes, the dbsrv10 service will become stuck in a "starting" or "stopping" status. Then the sqlany service cannot be started nor stopped. Is...

Doug Stone

03-16-2009 04:33 PM
Breck Carter [TeamSybase]

Hi, Is it possible to use the ianywhere.data.sqlanywhere version 11 .net data provider in a .net app to access a version 9 engine and...

Josh Schwalm

03-16-2009 02:00 PM
Nick Elson [Sybase iAnywhere]

I've had a few messages going. Thought I would start a new one since I've probably down to my last few options. We have a consolidated database...

Jeff Gibson

03-16-2009 10:52 AM
Jeff Gibson

Am 16 Mar 2009 08:25:23 -0800 schrieb Jeff Albion : Thanks for your answers. So first point (db icon is not visible) is clear, but second and...

Fabian Knauf

03-16-2009 10:25 AM
Jeff Albion [Sybase iAnywhere]

I typically code stored functions where I need a single, scalar value returned. f(a) = b I use stored procedures when I need to return a multi-row...

Paul Horan[Sybase]

03-16-2009 10:17 AM
Paul Horan[Sybase]

I am using version 11.0.1.2044 of Sql Anywhere. I have a stored procedure which inserts a row into a table and then uses @@identity to get the...

Ralph

03-16-2009 10:06 AM
Volker Barth

On sybase site I only could find SQL Anywhere 11.0.0 Developer Edition (http://www.sybase.com/detail?id=1055872). I know I can install 11.0.0 and...

Andrei Iliev

03-16-2009 09:44 AM
Andrei Iliev

Hi All, I’m currently building an Installer for SQL Anywhere 11 but I’m having trouble getting Sybase Central to work correctly. I have been...

IQX

03-16-2009 09:05 AM
IQX

You need to run those in dbisql and capture the output. The screens captured do not show the blocking. The Overview tab will show how many...

Igor Karpekin

03-16-2009 08:27 AM
Nick Elson [Sybase iAnywhere]

Jeff, I'm sorry for the repost but the thread was getting old and I thought maybe my post was missed. My customer has put together the following...

David DeRam

03-16-2009 07:37 AM
Jeff Albion [Sybase iAnywhere]

Greetings, not sure if this has been fixed or not - Index Consultant in ISQL of 9.0.2.3632 has no problem recommending two clustered indexes on one...

Pavel Karady

03-13-2009 01:35 PM
Pavel Karady

We have a consolidated database that is heavily involved in replication. Long story short, an assertion was occurring (101412 - page number does...

Jeff Gibson

03-13-2009 12:00 PM
Bruce Hay [Sybase]

I am in the process of needing to unload an reload a consolidated database that is involved in replication. (Needing to clean up a corrupt...

Jeff Gibson

03-13-2009 11:02 AM
Jeff Gibson

I think what I want to do is quite simple, but i can't seem to solve it... I have a simple select statement as below: SELECT * FROM openxml(...

MagicLava

03-13-2009 09:55 AM
Kory Hodgson [Sybase iAnywhere]

Can anyone translate a mini_core file for me (or point me to where I can find out how)? Our Sybase DB, SQL Anywhere V 10.0.1.3807, has crashed...

Mitch

03-13-2009 08:28 AM
Bruce Hay [Sybase]

I am just starting to use remote servers.. I have tested connections between several ASA 11 db:s running on win 2003. Everything works incredibly...

Anders

03-13-2009 08:24 AM
Anders

Our client data is loaded via a PB application that runs 24/7. Every 15 minutes, the application will loop through our clients and if a new set...

Tom Rolseth

03-13-2009 07:21 AM
Bruce Hay [Sybase]

When you do a database backup in Windows and then copy and restore that database to Linux; the –ds database option does not work correctly. The...

Marvin

03-13-2009 06:20 AM
Stephen Rice [Sybase]

I am using a column in a datawindow not exist in a table using the sql as given Select salaryamt,0.00 as overhead from salary; In the above example...

POLACHAN

03-13-2009 05:53 AM
Chris Keating [Sybase iAnywhere]

Our customer upgraded to version 11 of SQL Anywhere from 9. There are a number of tables that compose a master detail relationship. The database...

Randy

03-12-2009 03:11 PM
Glenn Paulley [Sybase iAnywhere]

Unloading v9 db into a new v11 db Using Sybase Cetral tools ( SQL Anywhere version is 11.0.1.2044) Stpes fly by in the "Unloading Database"...

Bob Higgins

03-12-2009 07:36 AM
Kurt Lichtner

We recently started receiving an error when the backup of our database was being validated. Here are the order of scheduled tasks and what happens...

Jeff Gibson

03-11-2009 10:42 AM
Jeff Gibson

Hi all, is there any way to downgrade a 11.01 database to 8.03? Unload and reload doesn't work because of different syntax. Regards, Axel

Axel Siepmann

03-11-2009 01:30 AM
Axel Siepmann

Likely not needed at this point but I will suggest that you review it with the changes you have made. If the Prefetch settings are not appropriate,...

Luca Arena

03-10-2009 01:29 PM
Luca Arena

Please work with BlackBaud (BB) on this issue. BB should have some mechanism to extract the user data. I know that BB does not provide direct access...

Chris Keating [Sybase iAnywhere]

03-10-2009 09:14 AM
Chris Keating [Sybase iAnywhere]

Hello - I am a bit confused about how to go about the following: I would like to compare the results of a select statement to data in a table....

punnknacity@gmail.com

03-09-2009 09:45 PM
punnknacity@gmail.com

Hi! Building an MSI file using the deployment wizard to get build 10.0.1.3831 out to my remote DBs is awesome but I do have a question about using...

jenniferdewolfe@gmail.com

03-09-2009 06:14 PM
Calvin Allen

Hi, I am having issues with Sybase Central. I just installed 11.0.1, on XP with all the latest updates. Every time I try to connect I get an Internal...

falsedawn@hotmail.com

03-09-2009 03:06 PM
Andrei Iliev

Hi, we are running Sybase SQL Anywhere V8 server and 10 client computers. My question is, should I ever restart the server (once a month or so?). ...

Aron Y.

03-09-2009 12:44 PM
Chris Keating [Sybase iAnywhere]

Hello, I am currently having an issue where the Isolation level I set in my ODBC connection profile is being ignored by the server when I use...

steve.lacagnina

03-09-2009 12:13 PM
Ian McHardy [Sybase iAnywhere]

How to create the MBO(Mobile Bussiness Object) in the sybase workspace 1.0 and we are using blackberry 4.2.1 simulator. in my local C: \Program...

Mytecsoft

03-09-2009 11:31 AM
Stephen Rice [Sybase]