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
2
votes
2 answers

PHP PDO Connect to Advantage Database SQL Server

Our EMR software uses Advantage Database SQL server as its database and I'm creating various PHP projects which require interaction with this database. What is the best approach to connecting and working with Advantage DB SQL and PHP? I'd like to…
mraliks
  • 4,047
  • 3
  • 15
  • 10
2
votes
1 answer

Reproducing a table lock error in Advantage Table

I am running two instances of a program and they are both accessing a TAds table. I want to reproduce a table lock for testing, but am having trouble. I made a button that when clicked runs the code - SomeTAdsTable.Edit; When I click on the button…
Trevor
  • 16,080
  • 9
  • 52
  • 83
2
votes
4 answers

Row cannot be found for Locate?

I'm converting existing Advantage Database Server application to SQL Server 2005 using D2009, dbGo (ADO). Sometimes i experience the error row cannot be found for locating. I had googled it, according to results i needed to set Update Criteria…
Ertugrul
2
votes
1 answer

Where to download old versions of Advantage Database (Architect. Server...)

I'm wondering if there's a site where I can download older versions of the Advantage Database Server and the Advantage Database Architect. On this site only the newest version is avaialable. Unfortunately, the new versions are often unstable or…
egonLegon
  • 23
  • 1
  • 3
2
votes
1 answer

SELECT * FROM system.storedprocedures returns empty cursor if user is not ADSSYS

As stated on the title, the select statement to retrieve the list of all system.storedprocedures from an ADS DataDictionary only returns information when the user is ADSSYS. I suppose it is a matter of user permissions. The question then is, how do…
reinaldo Crespo
  • 113
  • 7
2
votes
4 answers

Detect if a table exists

In SQL Server you can write SQL to check if a table exists. How can I do that for ADS? I have a need to write some Delphi code to say if table exists do this else this...
Jon
  • 38,814
  • 81
  • 233
  • 382
2
votes
1 answer

Trying to access to a DBF file using Advantage OLE DB provider throws an exception when opening a connection

I have an ASP.NET MVC application which is trying to open below OLE DB connection: string conString = @"Provider=Advantage OLE DB Provider;Data Source=" + dbfFilePath + ";Extended Properties=dBASE IV;"; using (dBaseConnection = new…
Willy
  • 9,848
  • 22
  • 141
  • 284
2
votes
2 answers

Count occurence of distinct value without grouping?

I need a line-by-line extract without grouping all clientID's, see below. I'm writing a quick extract to find how many times our customers have booked a product so we can see what their second, 3rd or 4th booking is. select c.clientid, c.bookref,…
RockandGrohl
  • 33
  • 5
2
votes
1 answer

Error stopping Advantage service. Error code 172

When running the adsstamp.exe to update an Advantage license the following error appears: Error stopping Advantage service. Report this error to Advantage technical support. Error Code 172. Additional info: - Logged in as Admin (Domain admin) -…
Amy Hatfield
  • 23
  • 3
2
votes
2 answers

Advantage Database Server (ADS) CIChar data type ISNULL

Unfortunately we are using the Advantage Database Server Torture Edition Version 8.1. After I had finished my project, I heard that the data base is configured to be case sensitive. So I changed the table structure, all Char data types to CIChar,…
ibram
  • 4,414
  • 2
  • 22
  • 34
2
votes
1 answer

How can I join an Advantage ADT table to a DBF table in a single query?

How can I join an Advantage ADT table to a DBF table in a single query?
Bill Seven
  • 768
  • 9
  • 27
2
votes
2 answers

Create ERD for Advantage Database Server 10

I need to create an ERD for an ADS 10 database. Reverese Engineering would be nice, since the database already exists. Unfortunately, I didn't found a ERD-Tool which supports this database. Does anybody knows a tool which supports this features?
gonzales
  • 401
  • 1
  • 9
  • 20
2
votes
2 answers

Sql trigger to save changes to an audit trail table

I started on an ADS sql table trigger to store changes done on one particular table. Here is the idea: //-------- sql trigger to store changes on patients table to auditLog…
reinaldo Crespo
  • 113
  • 7
2
votes
2 answers

Error while extracting data from Sybase using OLE DB in SSIS

I am having problems extracting data from Sybase using Advantage 11 OLE DB Provider in SSIS (2017). I can connect to the database, see the list of tables, and, when selecting a table as a data source I can see the columns. However, when I click…
Tamila
  • 177
  • 1
  • 3
  • 17
2
votes
1 answer

How do I select records more than 30 minutes old in Advantage Database Architect

I'm trying to select records that have a field (processedDt) which is a timestamp field, where the records are less than 30 minutes old. I am brand new to Advantage Database, so what I would do in SQL Server is not working. Here is one of the many…
Rich Hopkins
  • 1,861
  • 15
  • 29
1 2 3
…
26 27