I'm trying to deploy the Sybase SQL Anywhere 10 Runtime Engine, but I'm having some problems. When I run my application, I get an error: Error SQLSTATE = IM003 Specified driver could not be loaded due to system error 193 (cinema_ConfigurationDriver). OK According to my research, this is indicative of a missing DLL. I am lookin...
I have a table which contains sales order data (order number, product number, sales price, etc.). However, the table is littered with corrections and various other invalid data. One of the main issues is that corrections were entered by adding a new row with a negative total equal to the amount of a previous order. The sales people were...
Hi, how can I see the length of a table (in bytes) on SQL Anywhere? It's possible? Thank you ...
I am trying to set up a synchronization model to sync my consolidated Oracle database with a remote SQL Anywhere database. I have a couple Views on the consolidated Oracle database that I want to pull into the Sql Anywhere database as tables. I want to pull them over as they touch 4-5 tables (gotta love good normalization) and only ha...
I have a Sybase ASE server that I'm able to connect to with ASE iSql totally fine. The database definition in my sql.ini file looks like: [<NAME>] master=TCP,<servername>,<port> to connect with iSql, I can make the following command-line call and it works: isql -U <username> -P <password> -S <NAME> My ultimate goal is to use SQL An...
My situation: Table A ( ID Parent_Id TimeStamp ) The root has Parent_Id null and children has Id of its father. I simple want to get all LAST children of every Table A. Father and Children I don't want. (except last one). Is it possible to build a SQL to get this? PS: I'm on sql anywhere 11. Maybe an ansi sql can solve this, i'm no...
Ok so here is the scenario. We have two developers using the developer edition of Mobilink to sync to a consolidated Oracle DataBase using SqlAnywhere. The mobilink Version is Version 11.0.1.2331 Everything works fine in the two development environments. One dev environment is Windows 7 x64 and Oracle 11g r1. The other is xp x86 ...
I have a Sybase SQL Anywhere 11.0.1 database that I am using to sync with an Oracle Consolidated Database. I know that the SQL Anywhere database keeps track of all of the changes that are made to it so that it knows what to synchronize with the consolidated database. My question is whether or not there is a SQL command that will tell y...
How to connect to DSN created by SQlite Driver using SQL anywhere APIs from C++ code? I am using db_string_connect() to connect to sybase adaptive server anywhere. I want to use the same function to connect to the DSN created by SQLite Driver as well but db_string_connect() API is returning sqlcode -103 ["You supplied an invalid user ID ...
Hi there, I have to work with a legacy system based on SQL Anywhere 5, db access layer is in C++ using embedded SQL. The problem I have is not really a C++ problem, but embedded SQL forces us to SQL statements which cannot be dynamically generated. There are many tables containing a lot of columns having the datatype double. Though the ...
Hello, I've been handed a file which appears to me to be a Sybase database file from some older Sybase version. I have d-loaded the latest sybase package from sybase and tried using that to connect to the contents but failed. Can someone suggest to me how to determine which version of sybase (and perhaps even which sybase db product) my...
Hello I have two tables. One is article and the other structure. And the articles can be viewed as a tree with childnodes and so on. Like the Windows forms control TreeView. The structure table basically looks this: article_id article_above_id Article: article_id article_number I want to select from a maximum of five article_nu...
Hello! I am trying to import data into my table using INPUT INTO The problem is my decimals is using , as a delimiter, and it expects .. So it won't work! How can i change this? Search and replace in the input file is not an option! I am using SQL Anywhere 10 ...
My clients it department wants to move the database for my application to virtual partition. If you have done this what are the issues you ran into (performance, backups, replication). Currently running ASA 8 but upgrading to ASA 11 in near future. ...
For a table such as: create table foo (id int identity primary key) I would like to query the system tables to determine that id is in fact an IDENTITY column. The closest thing I found was: select tc.max_identity from systabcol tc join systab t on t.table_id = tc.table_id where t.table_name = 'foo' Unfortunately max_identity is 0...
Hi, I have installed sqlanywhere11 which inbuilt as ultraLiteJ. I have created an app Using the tutorial Part 1: Creating an UltraLiteJ application on BlackBerry. I have followed all the steps given in the tutorial 1. Create a Workspace. 2. Create a Project in the workspace 3. Add the UltraLiteJ JAR file to the project. 4. Ensured that...
I have a tablespace in SQL Anywhere 7 where I need to change it's name. Is there a way to accomplish this task? ...
I want to know domain type of scema for a select in SQL Anywhere. SQL: CREATE DOMAIN "followinteger" INTEGER NULL; CREATE TABLE "DBA"."test" ( "follow" "followinteger" NOT NULL, "test" INTEGER NULL, PRIMARY KEY ( "follow" ASC ) ); C# SACommand command = conn.CreateCommand(); command.CommandText = "SELECT * FROM USERS"; ...
hi, I'm trying to connect from my ms windows 7 via the odbc administrator to a remote sybase sqlanywhere 11 database server. But I get not connection, I'm not sure which configure option I have to specify. server-name = ip address of remote database server? startline ? portnummer ? Thank you, best regards, Alex ...
I develop am webservice based on apache tomcat 6.0.26, apache cxf 2.2.7, spring 3.0, hibernate 3.3 and sybase sqlanywhere 11. im using the latest JDBC Driver from SYBASE jconn.jar Version 6. The persistence layer is based on spring + hibernate dao, the connection is configured via a JNDI datasoure (META-INF directory). It seems that, d...