Stack Overflow
Stack Overflow

Questions tagged [sybase-asa]

Sybase Adaptive Server Anywhere, is an RDBMS by SAP, that runs as an embedded database. Since version 10, ASA is developed under the name [SQLAnywhere]

162 questions
2
votes
2 answers

Row_Number Sybase SQL Anywhere change on multiple condition

I have a selection that returns EMP DOC DATE 1 78 01/01 1 96 02/01 1 96 02/01 1 105 07/01 2 4 04/01 2 7 04/01 3 45 07/01 3 45 07/01 3 67 09/01 And i want to add a row number (il'l use it as a primary id) but i want it…
das9999
  • 35
  • 6
2
votes
1 answer

How to clear transaction log in sybase15.7?

I'm using Sybase15.7, after many transactions I'm getting an error like The transaction log in database fims is almost full. Your transaction is being suspended until space is made available in the log. Help me resolving this. Thanks in advance
Raja Shekhar
  • 31
  • 1
  • 5
2
votes
2 answers

Does Adaptive Server Anywhere not support subqueries in the FROM clause?

I am trying to execute an SQL query on an Adaptive Server Anywhere database. Here it is: SELECT count(*) AS s FROM ( SELECT column1, count(*) AS n FROM table1 GROUP BY column1 HAVING n > 1 ) In the subquery, I want to get all the…
YWE
  • 2,849
  • 28
  • 42
2
votes
3 answers

Is there a way to connect to an ASA database with Powerbuilder without deploying the ODBC or OLEDB drivers?

What I want is a Powerbuilder application that runs on Windows that runs from a CD (or some other external disk) that can read from an ASA database whose file is located on the same disk. But I want to do so without deploying the ODBC or OLEDB…
YWE
  • 2,849
  • 28
  • 42
2
votes
3 answers

SQL error on ORDER BY in subquery (TOP is used)

I am getting Syntax error near 'ORDER' from the following query: SELECT i.ItemID, i.Description, v.VendorItemID FROM Items i JOIN ItemVendors v ON v.RecordID = ( SELECT TOP 1 RecordID FROM ItemVendors iv …
ce_nort
  • 168
  • 1
  • 16
2
votes
1 answer

Is it possible to return a list of numbers from a Sybase function?

I'm trying to overcome a very serious performance issue in which Sybase refuses to use the primary key index on a large table because one of the required fields is specified indirectly through another table - or, in other words; SELECT ... FROM…
ps_rs4
  • 21
  • 2
2
votes
2 answers

Connect to SQL Anywhere - dblgen12.dll not found

I try to connect to a SQL Anywhere 12 database with the iAnywhere.Data.SQLAnywhere.v4.0.dll. On the database server this connection is successful, however on any other PC's I get the error Language Ressourcefile not found
Florian
  • 1,827
  • 4
  • 30
  • 62
2
votes
1 answer

SQl Output to CSV WITHOUT single Quotes

I am running a query on Adaptive Server Anywhere v7. select customerinfo.customerid, Name, Address1, Address2, City, State, ZIP, Country from customerinfo, addressinfo where customerinfo.customerid = addressinfo.customerid and MEMBER =…
JeffreyLazo
  • 813
  • 4
  • 13
  • 17
2
votes
1 answer

Change c# WebReference url address

Hi, I have 2 clients with 2 different servers. After generating wsdl classes I change url address for clients accordingly in SoapHttpClientProtocol consructor. from this.Url = "http://10.0.3.5:88/SomeName/dish to this.Url =…
koziol
  • 21
  • 2
2
votes
2 answers

Row count column count in all tables in Sybase database

I have a database name ATs . In this database 150 tables. I want to create a statement that return the row count and column count all tables on the database . I have created a store procedure For SQL SERVER 2008 but i don't know how to write this…
Abhishek
  • 299
  • 2
  • 5
  • 18
1
vote
2 answers

How to obtain the database schema from a Sybase ASA 11 Database

I am working on a project where I need to programmatically validate and/or compare a database schema between product releases. I am using Perl and am looking for a cross-platform method to collect the database schema. I am currently able to perform…
Brad Krusemark
  • 503
  • 1
  • 4
  • 10
1
vote
3 answers

How to export data with Arabic characters

I had an application that used a Sybase ASA 8 database. However, the application is not working anymore and the vendor went out of business. Therefore, I've been trying to extract the data from the database, which has Arabic characters. When I…
Firas
  • 41
  • 1
  • 6
1
vote
1 answer

nhibernate with Sybase asa9 with named parameters

Trying to get NHibernate working with Sybase ASA9 and having trouble with named parameters throwing an error: Invalid index 0 for this AsaParameterCollection with Count=0. I've tried with the NHibernate ODBC driver and currently the ASA driver. I…
Vince Bray
  • 53
  • 2
  • 8
1
vote
1 answer

How to use Microsoft Unity in such case?

Suppose I have an IBookRepository interface and implemented by SybaseAsaBookRepository and XMLBookRepository. SybaseAsaBookRepository constructor requiers 2 parameters, database user id and password, both values could be retrieved by an…
athos
  • 6,120
  • 5
  • 51
  • 95
1
vote
2 answers

Gui Tool for Adaptive Server Anywhere v7.0 (sql anywhere?)

I have a database I need to work with which is Adaptive Server Anywhere version 7.0. I would like to run some queries and such into this database using a GUI tool. I have access to the .db file so I need to know how I can work with this. What tools…
Roeland
  • 3,698
  • 7
  • 46
  • 62
1
2
3
…
10 11