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
0
votes
1 answer

Sybase ASE issue dropping unique constraint

When dropping a unique constraint both using Sybase Central or iSQL, the drop statement shown is as follows; alter table user_database.dbo.table_name drop constraint contraint_name But execution fails with different errors, like this: If constraint…
dnaranjor
  • 31
  • 7
0
votes
1 answer

Build a list of grouped values

I'm new to this page and this is the first time i post a question. Sorry for anything wrong. The question may be old, but i just can't find any answer for SQL AnyWhere. I have a table like Order | Mark ======|======== 1 | AA 2 | BB…
ductoyo
  • 3
  • 2
0
votes
2 answers

How to use Crystal Reports with parameters in PHP?

I would like to use Crystal reports with an ODBC (Sybase) data connection in PHP to display my database reports. I selected Crystal Reports because of its advanced features, professional abilities, and its support for Sybase databases. I also found…
TopDeveloper
  • 542
  • 2
  • 14
  • 43
0
votes
2 answers

Unable to add Tables/Views/StoredProcedures through EDMX

I'm using Visual Studio 2015 & Syabse ASA DB (ver 16.0.0.2222) alongwith EntityFramework 6.1.3. I add an ADO.NET Entity Data Model -> I choose EF Designer from Database -> Establish a New Connection -> Select the option to Include information in…
Ankit
  • 672
  • 6
  • 18
0
votes
0 answers

C# - Unable to read data from sybase database (SQL Anywhere) for longbinary datatype column

Below is my code: string ConnectionString = "Provider=ASAProv;Server Name=MyServer;Initial Catalog=MyCatalog;User id=MyUserID;Password=MyPassword;"; DataTable dt = returnTable(); lblTest.Text =…
Manu
  • 1
  • 3
0
votes
2 answers

Migrating Sybase 8 to Sybase 16

I'm hoping this question is appropriate for here, but, I'm running out of options. I have come across a Sybase 8 database from c. 2000. I'm being asked to get it up and running; however, even using Sybase Anywhere 16 won't allow me to connect to…
BtySgtMajor
  • 1,380
  • 10
  • 26
0
votes
0 answers

ASA database file data missing

I have a PowerBuilder app connecting to a ASA 8 database file via ODBC in location a. I then copy the same db file to location b, reconfigure ODBC to read the db file from location b, but now the data is gone. Whats up ? Is all the data stored in…
Alex Szlanina
  • 49
  • 7
0
votes
2 answers

Why will WHERE statement not work in sqlQuery in RODBC?

We keep all our laboratory data in a Sybase database. When I want to do data manipulation and analysis I read the data into R with RODBC. library(RODBC) channellab <- odbcConnect("Labdata") indivs <-sqlQuery(channellab,'SELECT * from…
Farrel
  • 10,244
  • 19
  • 61
  • 99
0
votes
1 answer

AseBulkCopy not available in list of commands

I am trying to bulk insert records in Sybase using C#. I have included Sybase.Data.AseClient.dll in my solution and able to create connection. But problem is there is no AseBulkCopy command available as shown in screenshot below. What could be the…
Frank Martin
  • 3,147
  • 16
  • 52
  • 73
0
votes
0 answers

Import multiple sybase .db files into SQL Server

I want to import multiple Sybase .db files into SQL Server 2014 at the same time. I have Sybase Adaptive Server Anywhere (ASA) v9 .db files, and Sybase SQL Anywher v11 .db files. I cannot use SSMA tool because of lower version of sybase. What is the…
Johnn123
  • 1
0
votes
1 answer

c# odbcconnection not closing

I've got a problem with the OdbcConnection in c#. I've written a class that wraps my connections and commands into a generic interface. The code looks basically like this (I've left out some unimportant parts) //connection, command, _connectionType…
JoeJoe87577
  • 512
  • 3
  • 17
0
votes
2 answers

Optimizing sybase query with aggregate sum function and grouping

I'm trying to improve an sql query made in sybase sql anywhere 5.5 (I know it's old but that's my task, and upgrading sybase version is not currently an option) select sum(pd.tax) as totaltax1,sum(pd.tax2) as totaltax2,sum(pd.tax3) as…
Dany Balian
  • 608
  • 7
  • 16
0
votes
2 answers

convert int to datetime in sybase

This works perfectly on the server (sql server 2012) for a julian date of 5 digits select cast (column1 as DATETIME) FROM mytable How to cast an int to datetime in sybase? And which would be the best way, since I have a large table and I have to…
CM2K
  • 833
  • 3
  • 18
  • 38
0
votes
1 answer

Connect to a SQL Anywhere 5.0 DB from java

I need to connect to a Billing system which is backed by a SQL Anywhere 5.0 DB and I am pretty much drawing a blank when I try to find a jodbc driver for this. I was successful in doing this with an upgraded version(SQL Anywhere 11) by using the…
Parikshit Iyengar
  • 37
  • 6
0
votes
2 answers

Could not parse sql timestamp string error message

At the point of posting a record to a database table I get the following error: Could not parse sql timestamp string. At the click of a button my code does the following: qry1.Open; qry1.Insert; qry1.FieldByName('files_uploaded').asdatetime :=…
Sharpie
  • 373
  • 2
  • 15
  • 34
1 2 3
…
10 11