| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hello,
The Event is:
BEGIN
CASE WHEN @@SERVERNAME <> 'rmtraining' THEN
BACKUP DATABASE
DIRECTORY '\\RMBackup-robertv13\\Scheduled' HISTORY OFF;
END...
Robert Paresi
|
07-07-2009 06:13 PM
Robert Paresi  | 6 | 85 |
| | | I'm working on developing an understanding of implementing
the FIPS140.2 option. I understand the functionality
provided by the ENCRYPT and DECRYPT...
Kyle Danielson
|
07-07-2009 03:44 PM
Jeff Albion [Sybase iAnywhere] | 7 | 61 |
| | | hello,
i think this is a general ASA question, but i'm currently using both ASA
9.0.2 and ASA 11.0.1.
is there any way to take a string that reads...
Douglas M. Deram
|
07-07-2009 10:42 AM
Douglas M. Deram | 6 | 87 |
| | | Are there any plans to support named (vs positional) parameters to
stored procs?
c.callproc("name", { '@variable' : 'value' } )
How does one read...
python6009
|
07-07-2009 09:53 AM
Nathan Auch [Sybase] | 7 | 55 |
| | | For 11.x and ignoring the access frequency of individual columns and indexes
is it best for general performance to have "narrow colums" at the...
Carl Kayser
|
07-07-2009 09:02 AM
Carl Kayser | 0 | 45 |
| | | On 2 consecutive nights at about the exact same time, we received the
following assertion error:
E. 06/29 21:23:05. *** ERROR *** Assertion failed:...
Brian
|
07-03-2009 03:55 PM
Nick Elson [Sybase iAnywhere] | 1 | 52 |
| | | Is it possible in ASA 9 to create a list of local temporary
tables created with a statement like the one shown below so
as to delete one or...
Mark Shapiro
|
07-03-2009 11:10 AM
Mark Shapiro | 0 | 47 |
| | | Hello,
For workstation ODBC (Sybase 9.02) - what files do I need to work with.
Can I use:
dbcon9.dll
dblgen9.dll
dbodbc9.dll
Robert Paresi
|
07-02-2009 11:56 PM
John Smirnios [Sybase] | 1 | 81 |
| | | Mis-paste -- we are actually using 10.0.1.3415.
> We are using SQLAnywhere 10.0.1.3831.
Jen
|
07-01-2009 05:27 PM
Jen | 0 | 44 |
| | | We are using SQLAnywhere 10.0.1.3831.
iAnywhere.Data.SQLAnywhere.dll has version 10.0.1.38312.
..NET 2.0, Visual C# 2008.
I'm having trouble...
Jen
|
07-01-2009 05:21 PM
Jen | 0 | 57 |
| | | We have recieved the following error message in our dbvalid
report: Run time SQL error -- Foreign key
"FK_CUST_PART_TO_PART_MAST" has invalid or...
Mark
|
07-01-2009 02:46 PM
Bruce Hay [Sybase] | 1 | 52 |
| | | Hi,
Can someone remind me how to peform a similar operation to OUTPUT from a
stored procedure?
ASA 7.04, Windows
thanks
Ray Norrish
|
07-01-2009 11:24 AM
Ray Norrish | 2 | 74 |
| | | SQL Anywhere 9 or 11
In a stored procedure I would like to reference a table
which exists in a separate sybase engine. Is this possible?
Can...
Kyle Danielson
|
07-01-2009 11:03 AM
Found it Kyle Danielson | 2 | 33 |
| | | Hello,
Is this possible?
I need to run some EXE's at a scheduled time that will executed from a
triggered event. Is this possible?
When the...
Robert Paresi
|
07-01-2009 02:37 AM
Volker Barth | 3 | 74 |
 | | We have just moved from v7 to v10 and have noticed a difference in the
way an IF statement executes,
the statement below would work on v7 but it...
Daz L
|
06-30-2009 09:08 PM
Ivan T. Bowman [Sybase iAnywhere] | 5 | 172 |
| | | Hi Volker,
Thank you for your response. (I apologize for the delay in responding.)
I assume you mean SQL Anywhere when you write "SA". That is...
Al Koch
|
06-30-2009 05:31 PM
Al Koch | 4 | 62 |
| | | Hello, I have a database created with an old system from
watcom. This database has 2 files : one with the extension
.db and the other with .cdb. I...
Pegase PC
|
06-30-2009 09:00 AM
Nick Elson [Sybase iAnywhere] | 3 | 65 |
| | | Hi,
Can I use the Python sqlanydb driver with ASE 15.0.2 database? I am
able to connect to the the database, but can't find my tables - I...
python6009
|
06-29-2009 09:02 AM
Nathan Auch [Sybase] | 1 | 163 |
| | | How does one enable/disable autocommits?
conn = sqlanydb.connect(userid='login', password='pwd', dsn='DBNAME')
Linux - RedHat EL5 - Python...
python6009
|
06-29-2009 08:41 AM
Nathan Auch [Sybase] | 1 | 214 |
| | | I have a stored procedure, which, when called, generates an error:
"sqlanydb.OperationalError: Not enough server threads available...
python6009
|
06-29-2009 08:21 AM
Nathan Auch [Sybase] | 1 | 148 |
| | | Hello,
You need to make sure you have an OEM license or a license agreement to set
the number of licenses properly per site.
You can then...
Robert Paresi
|
06-26-2009 11:13 AM
Sheila Harris | 1 | 60 |
| | | Hi guys,
I have one more issue I am finding going from V9 to V11 -- and then I should
be good to go. :-)
I have two servers serving up 9.02...
Robert Paresi
|
06-26-2009 08:22 AM
Robert Paresi | 8 | 181 |
| | | Hi
I have upgraded a ASA 9 database to ASA 11.0.1 build 2222. I have
problems with the backup procedure. Disk I/O is on 100% and no
connections are...
Tom
|
06-25-2009 12:56 PM
Bruce Hay [Sybase] | 2 | 61 |
| | | We are currently using ASA V9.0.2. We have adjusted the
number of licenses in a test environment. When attempting
to connect to the database...
Sheila Harris
|
06-25-2009 12:35 PM
Sheila Harris | 2 | 58 |
| | | ASA v 9.0.2
Sybase Central 4.3...
I should start by saying I am not a programmer....
I am trying to create a stored procedure that
1. Creates a...
Loya Kelso
|
06-25-2009 11:17 AM
Loya Kelso | 10 | 84 |
| | | Hi guys,
Could this error "I. 06/24 09:40:06. The address given is invalid.
The address must be a directory name with no path
separators." be cause...
kimtruong
|
06-25-2009 09:20 AM
Nick Elson [Sybase iAnywhere] | 1 | 47 |
| | | I use a 64-bit VISTA and need an ODBC connection to a SQLAnywhere 11
database. Some of the programs are 64-bit, others are 32-bit. The
problem is,...
at
|
06-25-2009 09:05 AM
George Brink | 1 | 130 |
| | | We are using ASA 11.0.1 build 2044 on a Windows2003 server. This box is the
db server for our web application. The db itself is 13GB and has a...
Tom Rolseth
|
06-24-2009 09:27 PM
Glenn Paulley [Sybase iAnywhere] | 1 | 70 |
| | | We currently use Adaptive Server Anywhere V9.0.2. Is it
possible to set the number of concurrent licenses during
installation or must this be done...
Sheila Harris
|
06-24-2009 11:33 AM
Sheila Harris | 0 | 55 |
| | | Hello,
Has there been any changes in the V11 Deployment Wizard in the last EBF (ie:
2222 -> 2250)
With regards to registering...
Robert Paresi
|
06-24-2009 10:07 AM
Robert Paresi | 0 | 55 |
| | |
FalseDawn
|
06-24-2009 09:48 AM
Jeff Albion [Sybase iAnywhere] | 2 | 48 |
| | | Hi all,
Does the SQL Monitor EBF 2250 (23rd June) need to be installed if the
standard EBF (9th June) has been installed (Win x86)?
cheers,
Shao
Shao Chan
|
06-24-2009 09:48 AM
Shao Chan | 2 | 55 |
| | | Because of the change described here
http://support.microsoft.com/?id=904953
You cannot change, add, or delete data in tables that are linked to...
Breck Carter [TeamSybase]
|
06-24-2009 04:49 AM
Breck Carter [TeamSybase] | 0 | 62 |
| | | I use a 64-bit VISTA and need an ODBC connection to a SQLAnywhere 11
database. Some of the programs are 64-bit, others are 32-bit. The
problem is,...
at
|
06-24-2009 02:45 AM
at | 0 | 65 |
| | | Hello,
This is a bug (?) which I've now been able to narrow down and reproduce. It
caused me a considerable amount of hours. I really would need...
Robert Paresi
|
06-23-2009 07:17 PM
Robert Paresi | 7 | 151 |
| | | 10.0.1.3673
Environment - ASP.NET Web app using NHibernate.
2009-06-22 19:39:32,981 DEBUG Error executing Enumerable() query...
PGP
|
06-23-2009 03:56 PM
PGP | 0 | 46 |
| | | Can a missing logfile be recreated? version10
I can start some db's without one and I have one that complains about it
missing.
Jack Walton
|
06-23-2009 03:22 PM
Reg Domaratzki [Sybase iAnywhere] | 5 | 156 |
| | | How do I INSERT to an Excel 2007 proxy table?
The INSERT in the following code fails with the following message...
=====
You cannot edit this field...
Breck Carter [TeamSybase]
|
06-23-2009 12:27 PM
Jeff Albion [Sybase iAnywhere] | 1 | 64 |
| | | 10.0.1.3673
Environment - ASP.NET Web app using NHibernate.
2009-06-22 19:39:32,981 DEBUG Error executing Enumerable() query...
PGP
|
06-23-2009 11:12 AM
PGP | 0 | 46 |
| | | 10.0.1.3673
Environment - ASP.NET Web app using NHibernate.
2009-06-22 19:39:32,981 DEBUG Error executing Enumerable() query...
PGP
|
06-23-2009 11:10 AM
PGP | 0 | 57 |
| | | Hello,
This is a bug (?) which I've now been able to narrow down and reproduce. It
caused me a considerable amount of hours. I really would need...
Robert Paresi
|
06-23-2009 07:35 AM
Robert Paresi | 0 | 51 |
| | | SQL Anywhere 11.0.0.1264
Using:
"Drop Table if exists dba.document"
I get the error:
"Syntax error ner 'IF' on line 1.
On the Sybase...
Rebecca Snyder
|
06-23-2009 07:28 AM
Rebecca Snyder | 8 | 183 |
| | | Greetings,
can anybody give me a final highlight of what's the difference between
view_def and source columns in sys.systable for views, ASA...
Pavel Karady
|
06-23-2009 05:15 AM
Volker Barth | 9 | 78 |
| | | In former SQL Anywhere releases it was possible to create EXCEL output
files. This feature was dropped. Unfortunately one of our customer needs
this...
Markus KARG
|
06-23-2009 01:38 AM
Markus KARG | 2 | 64 |
| | | We have found that dropping tables and views in SQL Anywhere
(10.0.1 Build 3613, and others) can be very slow - on the
order of 10-20 seconds per...
jbrauer
|
06-22-2009 03:55 PM
jbrauer | 5 | 71 |
| | | Hello,
Using Windows Vista Professional.
Sybase SQL Anywhere 11.1.2222
"Show welcome screen" is unchecked in SCJVIEW - however, it still...
Robert Paresi
|
06-22-2009 11:03 AM
Robert Paresi | 0 | 73 |
| | | Whom to send a stack trace after a crash of Sybase Central?
My productive server don't have general email access...
M. Westphal
|
06-22-2009 10:45 AM
M. Westphal | 2 | 56 |
| | | I have a small code
which loops from 1 to ~ 20
creates a new table
inserts ~ 20,000,000 rows
truncates the table, prints the dbsize and free page...
Vikrant
|
06-22-2009 10:15 AM
John Smirnios [Sybase] | 7 | 57 |
| | |
Robert Paresi
|
06-22-2009 10:12 AM
Chris Irie [Sybase] | 1 | 67 |
| | |
Robert Paresi
|
06-22-2009 09:04 AM
Nick Elson [Sybase iAnywhere] | 4 | 170 |
