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]

152 questions
22
votes
3 answers

Get records from last hour

I have this query: SELECT Field1, OrderFor, Writeback, Actshipdate, Orderstatus, receivedate, receivetime FROM orderinfo, shippinginfo WHERE orderinfo.orderid = shippinginfo.orderid AND shippinginfo.custid = '37782' AND receivedate = …
JeffreyLazo
  • 689
  • 3
  • 11
  • 17
7
votes
8 answers

How to output data from iSQL to csv file _with_ headings?

I'm trying to query a Sybase ASA 8 database with the iSQL client and export the query results to a text file in CSV format. However the column headings are not exported to the file. There is no special option to specify that, neither in the iSQL…
Oliver Jakoubek
  • 376
  • 1
  • 2
  • 6
7
votes
4 answers

Sybase IQ - how to show stored procedure without wrapping text?

Using Sybase IQ v12.7. Executing sp_helptext ProcedureName shows the text of the stored procedure which is fine. However it wraps lines at 80 characters. The question is, how to show text text of a stored procedure without wrapping? In Sybase…
FuzzyWuzzy
  • 635
  • 1
  • 6
  • 11
4
votes
2 answers

How do I properly test my database performance with high load demand?

I have found a lot of topics about stress-testing web application. My goals are different, it's to test only database (sybase sql anywhere 9). What I need: Some tool to give a diagnostic of all sqls and find a bottleneck. I wish I could macro-view…
Ismael
  • 2,250
  • 1
  • 23
  • 37
4
votes
2 answers

Select TOP 1 * from Table Fails in Sybase Procedure

Am trying to Fetch Only one record from the Sybase Table without using the RowCount Function, even though "WHERE Condition" returns multiple results. SELECT TOP 1 EMPLOYEE_NAME FROM EMPLOYEES WHERE EMPLOYEEID > 50 Runs Successfully with one Record…
user2104391
  • 405
  • 4
  • 9
  • 17
3
votes
1 answer

Decode information from Sybase transaction log file

I am looking for a way to decode the information stored in a Sybase database transaction log file (all queries issued to the database). Can someone please help with this?
Gleeb
  • 9,244
  • 20
  • 79
  • 123
3
votes
1 answer

DSN-less ODBC connect string for legacy Sybase Adaptive Server Anywhere

This is a failed response to this article: Sybase, VB and ADO I just did a VB6 project connecting to a legacy ASA 7 database. After failing to use ASAProv OLEDB provider altogether (for one reason or another) and much research, here is the connect…
wqw
  • 10,921
  • 1
  • 30
  • 39
3
votes
1 answer

Sybase Anyware. SQL query to determine DB version

What query or command to determine Sybase SQL Anyware version? I use sqlsh + freetds as interactive client (in Emacs).
gavenkoa
  • 37,355
  • 13
  • 206
  • 248
2
votes
3 answers

password recovery for SyBase file

I have a .db file that I think is a Sybase database file that I have been tasked with extracting data from. Looking at the file in notepad shows that the data in not encrypted (I can read text strings from it) but I don't have the username/password…
BCS
  • 67,242
  • 64
  • 175
  • 277
2
votes
0 answers

NHibernate using ODBC to connect to ASA 9.0 pops windows on taskbar

I'm using NHibernate in a project where I need to access to different types of databases using DSNs. I configure NHibernate to use the following parameters: connection.probider: DriverConnectionProvider dialect:…
Carl
  • 1,164
  • 2
  • 17
  • 34
2
votes
1 answer

Decrypt DSN password ENP to PWD

I have a file dsn containing encrypted password. I need to get the decrypted password and perform the steps). We are not storing password anywhere else. Is there any way to get the PWD using some routine or sybase tool? We are using Sybase version…
Vineet
  • 75
  • 3
  • 9
2
votes
1 answer

Restricting access to remote database

I am using Sybase ASA version 9.0.2. I can access the remote DB using the dbisql utility by providing HOST as remote system IP address. I am starting the database using the dbsrv9.exe utility. Is there any way to restrict the remote access on this…
Vineet
  • 75
  • 3
  • 9
2
votes
2 answers

Enable/Disable Trigger in Sybase

What's wrong with that query? alter table TableName enable trigger 'TriggerName' Error is Line 1, column 30 Could not execute statement. ASA Error -131: Syntax error nera 'enable' on line 1
Mauro
  • 1,983
  • 2
  • 24
  • 47
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
3 answers

How can I connect with Sybase 17 ASA in .NET Core, using ODBC?

We have a Sybase 17 ASA server and want to connect using an ODBC driver. Our goal is to use the full .NET Core 2.1 and above, not .NET Standard or .NET Framework 4.x.
MeanGreen
  • 2,638
  • 5
  • 34
  • 55
1
2 3
…
10 11