Rating Thread / Thread Starter	Last Post	Replies	Views
Only digits as netuser How do I if I had to create a integrated login when netuser only have digits (ASA 9.02). KurtB	02-20-2006 09:54 AM Greg Fenton	1	90
ASA 9 OLEDB problem I posted this question to the PowerBuilder newsgroup and got no response. I am trying to use OLEDB rather than ODBC and I am running into... John Pollard	02-20-2006 09:53 AM John Pollard	2	95
How to initialize global autoincrement counter not to start at zero? The global autoincrement feature is starting to count id values starting from zero (within the partition). This is bad if there are rows... Markus KARG	02-20-2006 03:48 AM Markus KARG	7	126
Retrieve table names Is there a way to get a list of all tables in the database? (Not the system tables) TIA Using SQL Anywhere v9.0.2.3249 R.Brouwer	02-20-2006 03:07 AM Pavel Karady	3	91
Is ASA running on AMD64? We are using ASA on Windows x86 machines. Can we use ASA on Windows AMD64 (Opteron) machines? Is it running in 32 bit or 64 bit mode there? Is our... Markus KARG	02-20-2006 02:34 AM Markus KARG	2	99
The book is now available in Chinese For more information see http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html Breck -- SQL Anywhere Studio 9 Developer's... Breck Carter [TeamSybase]	02-18-2006 12:29 PM Breck Carter [TeamSybase]	0	84
Possible bug with build 9.0.2.3182 Running Windows 2000 Server with 4 Gig of RAM. Since applying this build, I'm getting an error Error: Database server connection limit exceeded... Michael Gould	02-17-2006 05:48 PM Joshua Savill	7	119
Returning month names in two languages ? Hello, when I do this: select dateformat(datefield, 'Mmmmmmmmmm yyyy') from table then it returns the month name in the "engine-server"... Andre Schild	02-17-2006 05:11 PM Andre Schild	0	88
Can Sybase 5.5 and SQLAnywhere 8.0 co-exist on the same server. Sybase 5.5 using Named pipes and 8.0 using tcpip? TIA Karson	02-17-2006 04:40 PM Andre Schild	2	93
Table not sorted by Primary Key 8.0.2.4339 I've got a table in a certain database which is no longer "sorted" by the primary key, which is the case in all of our other databases... Jon	02-17-2006 03:43 PM Jon	2	117
verify_password_function documentation? I see a very nice database option (or connection property?) named verify_password_function, but there is no documentation. Sounds like exactly what I... Mark Hampton	02-17-2006 03:33 PM Ian McHardy	2	96
Taking advantage of multiple processors ASA 8.0.2.4339 I'm looking for info on how to take advantage of multiple processors using SMP or multi-threading. I've found some info in the help... Jon	02-17-2006 03:26 PM Ian McHardy	3	84
ASA 8.03 Maintenance? I have a customer who is curious about the EBFs that were recently released for ASA 8.03. In general, I prefer to wait for maintenance release since... Andrew Wacker	02-17-2006 11:41 AM Breck Carter [TeamSybase]	2	90
Performance Question I'm using ASA 9.0.2 (3182) on Windows 2K3 Server. I noticed the databases running slow, so I checked the log file for any performance warnings. I... Cory Musselman	02-17-2006 10:59 AM Markus KARG	2	102
Problem With ASA .Net 2.0 Data Provider I've encountered this situation a couple times now and I can only imagine that it must be a bug. The following code works perfectly with the... Metal2You	02-17-2006 10:52 AM Metal2You	1	94
What do I need to evaluate Sybase database engines on Windows Mobile Devices Hi, I'm thinking on evaluating Syabse products, but I'm having some dificulties determining what do I need to download and install, or what is each... Alberto Silva	02-17-2006 08:22 AM Breck Carter [TeamSybase]	8	122
Reserved words Hi, i am using ASA9.0.2 but when try to create a table show it: Syntax Error for use the window word.....!!! At ASA 5 don`t have this problem for... Luis Telles	02-17-2006 03:31 AM krisztian pinter	2	87
Can't open db after restored Trans.log Good day all, Currently, I’m using ASA 7.0.2 1402 for testing purpose to do a backup & restore. According to subject above, I am facing a problem... Voski Hung	02-16-2006 08:55 PM Voski Hung	6	104
Exhausting dynamic memory Under CE (4.2), running Sybase 8.02.4392, I was iterating over all of our application tables something like: for each application table in the... Andrew Braunstein	02-16-2006 11:52 AM Tim	3	84
RTF > Text function Just before we settle down to write one, I don't suppose anyone out there has a Watcom SQL / TSQL function to strip the plain text out of rtf... Justin Willey	02-16-2006 10:45 AM Justin Willey	0	100
Sybase Replication mechanism Hi, Suppose you have the following tables: A - Customers B - CustomerAddresses C - CustomerContacts Table A would have a primary key on the... Alberto Silva	02-16-2006 10:36 AM Greg Fenton	7	120
802 -> 803 ( 1 2 ) Hi We currently use 8.0.2.4361. I have been testing the last 8.03 version (8.0.3.5307) and noticed the following difference: - we had a function... E. ten Westenend	02-16-2006 10:01 AM Breck Carter [TeamSybase]	11	153
ERROR MESSAGE Hi, i am using ASA9.02 and i need to read the database error message, for example: execute @ret_status = usp_ACT_HOROM... Luis Telles	02-15-2006 09:48 PM Greg Fenton	1	85
SQL error -685:Resource governor for ‘prepared statements’ exceeded We got this error message while importing data (with our own code): SQL error -685: Resource governor for ‘prepared statements’ exceeded File Name:... Mei	02-15-2006 03:57 PM Glenn Paulley	5	504
live backup question/problem We have one of our sites that is using the live backup option for their database. Occasionally (once a week or so), the secondary server blue... Alex Whitney	02-15-2006 03:33 PM Alex Whitney	2	96
ODBC Drivers error '80004005' We got Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’ once a while. The message is Unable to connect to database server: Database... Mei	02-15-2006 03:13 PM Mei	5	110
Sybase ASA 9.0.2 x64 and EBF Are the ASA Windows x86 EBF for ASA x32 and x64 Bit ? Franz Franz Griesser	02-15-2006 12:30 PM Joshua Savill	1	78
Sybase ASA x64 and EBF Are the ASA Windows x86 EBF for x32 and x64 versions ? Franz franz Griesser	02-15-2006 12:29 PM Joshua Savill	1	70
Unload / Reload - Making it faster We have a SQL Anywhere 7 production database that we would like to upgrade to 9. The problem is that this is an online system and we can't afford to... Kevin McGrain	02-15-2006 11:17 AM Thanks to All	8	96
Problem unloading 7.0.4.3519 & build 3541 C:\Program Files\Global Data Manager\Bin\BackupPurgeTuneExtract>dbunload -ar c:\global -c "dsn=KMIPurge;uid=dba;pwd=XXX" Adaptive Server Anywhere... Christopher Harn	02-15-2006 10:54 AM Breck Carter [TeamSybase]	3	92
Check for Forgeign keys and COMMIT What can be wrong when in a database the Foreign Keys are checked by an DELETE statement after COMMIT and not by the DELETE statement itselfs ..? In... Hans Groeneveld	02-15-2006 10:29 AM Breck Carter [TeamSybase]	4	107
Getting environment variable - HOWTO How can I get an environment variable into a Stored Procedure. I can use xp_cmdshell and 'echo %userdomain% > file.txt' but then I need rights to... Hans Groeneveld	02-15-2006 08:59 AM Breck Carter [TeamSybase]	1	85
Views on proxy tables Ver 9.0.2.2451 I have two proxy tables in an IBM DB2 DB. The Remote Server is setup and working and I can access the two tables. I am creating a... Eddie Sizemore	02-15-2006 12:04 AM Eddie Sizemore	2	93
How do I debug a dbinit failure on Linux due to a "Communication error" The following dbinit command doesn't create the database because of a "Communication error." dbinit -c -e -p 2048 -o trace.log -n temp.db The trace... Derek Reiger	02-14-2006 10:10 PM Greg Fenton	1	94
Error on CREATE EXISTING TABLE - continued ;-) Hi all, I'm having trouble trying to connect to remote tables from an ASA db to another ASA. The first db has an ODBC DSN named "bana03" and is... Luca Arena	02-14-2006 02:45 PM Nick Elson	4	89
using if in a statement ( 1 2 ) Hi i am using asa 9.0.2, it`s possible to use if in a select..? for example select a, b, if ( a > b, c , d ) from table_test Luis Telles	02-14-2006 01:12 PM Alex Whitney	10	137
BCP ASE IMAGE TABLE INTO ASA Cool! Could you post some technical details on how you accomplished this? I am sure it would be very helpful to future readers (this forum is... Scott Kellish	02-14-2006 10:08 AM Scott Kellish	3	116
How to get the starting log offset from an active log? Hi all, I'm running ASA 8.0.3.5324 and 8.0.1.3023 on Win 2K in a SQL Remote setup. For diagnostic purposes, I want to get the following values from... Volker Barth	02-14-2006 06:00 AM Volker Barth	2	83
Problem in remote servers Hi everyone, Situation : Remote DB : Microsoft SQL Server 2000 Active DB : ASA 9.0.1 build 1751 Problem : Canelas	02-14-2006 04:43 AM Canelas	2	85
Problems with shutting down ASA Windows Service I'm running ASA 9.0.2 (3182) on Windows 2000. I have a Windows Service for an ASA server that is built upon install of our application. That create... Cory Musselman	02-13-2006 03:04 PM Cory Musselman	0	80
problem and error with asa 9 doc with datepart hi there ASA 9.0.2.3249 and doc for 9.0.2 function datepart select datepart (caldayofweek, current timestamp), datepart (weekday, current... Martin Baur	02-13-2006 01:59 PM Martin Baur	4	95
Cursor problem after record update from C++ environment Hi, Our Visual C++ programs that use MFC libraries were working properly with ASA 7.0.4 during edit-update operations. In those programs, After... ahmet sahan	02-13-2006 01:43 PM ahmet sahan	0	86
Migrate data from MS SQL to ASA, howto ? Hello, we are in the happy case, that we can migrate a application with existing data from a MS SQL 2000 to a ASA 9.x server. Migrating the... Andre Schild	02-13-2006 10:41 AM Greg Fenton	4	77
Problem when unloading a database Hello, we are using Sybase Central version 4.1.1.1432, with Interactive SQL version 8.0.2 build 4372. We have a database with some procedures, in... jmromey@gmail.com	02-13-2006 08:26 AM jmromey@gmail.com	0	86
SA 5.5.05 on Win 2003 - any known problems? Hi all, we have a legacy application that has been running on SA 5.5.05 build 2817 on a NT4 box for years. The database is used as a consolidated DB... Volker Barth	02-13-2006 04:48 AM Volker Barth	1	104
Avoiding Contention 8.0.2.4339 I've got a situation where some intensive queries may be executing in one connection. In another connection, I'd like to be able to... Jon	02-13-2006 03:47 AM Pavel Karady	5	98
LOAD TABLE Statement failing. we are using PB9.0.1 Build 7096 and Sybase 8.0.2 Build 4299. Our application is running on one Windows 2003 Terminal Server and the database is... Darren Cameron	02-12-2006 01:49 PM Greg Fenton	6	94
MS SQL -> ASA: Any easy method? How may I move data and structures from MS SQL to ASA? I am running the Create Table scripts in Interactive SQL, but each script requires a lot of... hackerdeep	02-11-2006 08:59 PM hackerdeep	0	77
dbsrv9 on Windows CE Hi, having some experience with ASA on Windows PCs, I have almost none on Windows CE devices. I have just begun to play around with this under... Klaus P. Pieper	02-11-2006 04:18 AM Klaus P. Pieper	7	98
SQL Anywhere Developer's Corner The SQL Anywhere Developer's Corner is a forum for sharing thoughts, ideas and experiences about using SQL Anywhere in the form of high-quality... iAnywhere	02-10-2006 05:08 PM Breck Carter [TeamSybase]	2	73

Page 109 of 214

109

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off