Stack Overflow
Stack Overflow

Questions tagged [advantage-database-server]

Advantage Database Server is an embedded relational database management system from Sybase.

Advantage Database Server is a full-featured, easily embedded, client-server, relational database management system from Sybase, a subsidiary of SAP.

Some of the strengths of Advantage include:

  • Supports both ISAM (navigational) and SQL data access
  • Supports both the DBF and ADT (proprietary) data formats
  • No Administration
  • Easily Embedded
  • Supports Windows and Linux

Resources:

393 questions
0
votes
1 answer

No relationships when generating Entities from Advantage database

I am trying to add tables from an existing Advantage Database (recently upgraded from v8 to v10) to a .NET project via the Entity Framework. However, no matter what I do, the relationships between the tables are not being imported from the…
Bobson
  • 13,498
  • 5
  • 55
  • 80
0
votes
1 answer

Install Issues on Delphi XE2 (Advantage Delphi Components)

Installed Advantage Delphi Components on Delphi XE2 (Windows 7 Pro). We're getting error when opening Delphi XE2 showing the above dialog box. Tried compiling the adsDXE2dstudio package but failed. What are we missing here? Thanks in advance for…
user1441100
  • 3
  • 3
0
votes
3 answers

How to append text to memo field?

I'm using Advantage Database Server 9.10, and I want to append a text to Memo field. I tried this way, UPDATE myTable SET memo = cast(memo as SQL_VARCHAR(max)) + cast(' Appended string' as SQL_VARCHAR(max)) WHERE pk =…
Expert wanna be
  • 10,218
  • 26
  • 105
  • 158
0
votes
1 answer

Can I temporarily run ADS on both the old server and a new replacement server?

I am running advantage database server version 8.10.0.38 on a windows 2000 server. I want to replace the server with a new windows 2008 R2 server and migrate the ADS and application to the new server. I need to test the application on the new…
hream61
  • 1
0
votes
1 answer

How do you create a new user with admin permissions in ADS?

What is the command to make a new user with administrator privileges in the Advantage Database Server?
PRNDL Development Studios
  • 3,270
  • 2
  • 35
  • 50
-1
votes
1 answer

Finding column name in table using SQL

I am currently using Advantage database. I have a table with hundreds of headers. How do I use query to find a specific column name? Example - I am looking for a column header named "Marital Status", and the only details I have are the values…
Kenneth Sim
  • 1
  • 1
-1
votes
1 answer

LEFT JOIN is killing my query - how to speed up?

I have two tables: a list of documents created in our system (offers and invoices) when something is logged as…
egg
  • 373
  • 1
  • 7
  • 15
-1
votes
1 answer

Invalid operand for operator when doing a COUNT DISTINCT

I'm trying to count the number of unique invoice codes in table. The codes are numbers, but it might by that the field is a text field. I'm not sure how to check that. When I run this code: SELECT count(DISTINCT DAB050.REC_LIST) as…
egg
  • 373
  • 1
  • 7
  • 15
-1
votes
1 answer

How to implement TADSevent like functionality for SQL Server

I'm using Delphi 10.3 and Advantage DataBase. Here, I have used sp_SignalEvent method and then, used the TADSEvent which get triggered for all the ADS connected application and handled the operation based on the requests. Is there any similar…
Work 2 Enjoy - Enjoy 2 Work
  • 351
  • 7
  • 26
-1
votes
1 answer

Optimal Advantage SQL sub-query

I'm trying to optimize an SQL query for an Advantage 11 database. In short, I'm trying to build a query to calculate the total number of steps in a manufacturing sequence and the number of those that have been completed. The system supports…
James Anderson
  • 1
  • 2
-1
votes
1 answer

ODBC Call Failed between Access 2010 and Advantage database server Over a network

First and Foremost, I know zip, zilch, nada, about VBA, access, and Advantage database Server. I have a PC in one location that can connect and update with an Access 2010 file where every drive is mapped, e.g. \file\whatever The advantage…
John Hernandez
  • 1
  • 1
-1
votes
1 answer

How to connect to a Sybase Advantage Local DB with Java 8

We are developing an application and we need to migrate the data from the old db, a Sybase Advantage Local DB. Until now we were doing it with Java 7 and an odbc/jdbc bridge thanks to java.sql.DriverManager. Now we upgraded our application to java 8…
Dario Zamuner
  • 991
  • 2
  • 14
  • 28
-1
votes
2 answers

SQL Select from case or IF...Then logic?

I'm trying to eliminate making a post pass into the db and in doing so have encountered this problem. The scenario is that I need to join onto a table that has many rows per item. Think dated values, Item x has a value of n at date y. There's also…
null
  • 3,469
  • 7
  • 41
  • 90
-2
votes
1 answer

Possible limitation with updating a field in Advantage Database?

I'm trying to update a field in a table and am unsure if I'm just completely wrong or if it's a possible limitation of using Advantage Database. My Script: UPDATE myTable SET myField = REPLACE(myField,substring(myField,myNumber,mynumber),'<>') Where…
Cody G.
  • 53
  • 3
-2
votes
1 answer

Need a query for subtraction and division?

In my table column are like these msd_mon, msd_yea, msd_sva ... I want a query SELECT ((( SELECT SUM(msd_sva) FROM msdfc00 WHERE msd_yea IN ( SELECT DISTINCT msd_yea FROM …
Gopipuli
  • 393
  • 1
  • 12
  • 37
1 2 3
…
26
27