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

Adding a Primary Key to an Existing Database in Advantage

What is the syntax to add a Primary Key to an existing Production database? I have inherited a database with no Primary Keys set for anything, and I need a primary key on each table to use my ORM for an application. I tried googling to no avail,…
PRNDL Development Studios
  • 3,270
  • 2
  • 35
  • 50
3
votes
3 answers

ASP.NET with Delphi 2007 for .NET. Could not load file or assembly … The located assembly's manifest definition does not match the assembly reference

This one’s a head scratcher. Here’s the deal. While deploying a beta copy of an ASP.NET application built with Delphi 2007 for .NET to a test server I encountered an odd problem. The application was unable to start because it could not load the…
Cary Jensen
  • 3,751
  • 3
  • 32
  • 55
3
votes
1 answer

many-to-one formula has table name appended to SQL keyword

I am working with a legacy database and am trying to convert a char to an int for a many-to-one mapping. I know this isn't a great idea but I'm stuck with the schema as it is. I have tried to do this with the following mapping but have found that…
mickfold
  • 2,003
  • 1
  • 14
  • 20
3
votes
1 answer

Advantage Database Error 5175

I'm trying to read data from an Advantage Database with Advantage .Net Data Provider. When I execute my app, I have the following error : "Error 5175 the index was created with a different collation sequence" A way to fix it is to open the table…
Azzedine Hassaini
  • 331
  • 4
  • 5
  • 16
3
votes
1 answer

Advantage Database Index Collation Sequence

I am converting a Delphi program from the BDE to Advantage Database. On weekends I work on a Win 7 machine using Delphi XE. During the week I work on a Win XP machine using Delphi 7. Advantage tables work fine on the Win 7 machine but when copied…
Graham Saint
  • 35
  • 1
  • 4
3
votes
1 answer

How do I keep Advantage Database connections from timing out?

I have a Windows Service that works with an advantage database and occasionally makes some http calls. On rare occasions these calls can be very long. To the tune that my database connection times out. I'm not using a Data Module or anything. …
Eric G
  • 3,427
  • 5
  • 28
  • 52
3
votes
1 answer

Error 5018 handle not recognized by Advantage in Delphi Project

I have a delphi project that somehow has become corrupted. I upgraded to Advantage 11.1 components (using XE) and now I'm getting the following error message when opening the project: acctTbl: Error 5018: The handle given was not recognized by …
SysJames
  • 411
  • 3
  • 10
3
votes
1 answer

Converting Date Format in Advantage SQL

I have a simple problem in Advantage Database SQL. I have dates in the format M/D/YYYY and want to convert them MM/DD/YYYY. Normally in SQL Server I would just use a convert(varchar(20), field, 101) but this does not work in Advantage. What is the…
KJ3
  • 5,168
  • 4
  • 33
  • 53
3
votes
1 answer

sp_RestoreDatabase and ADSSYS password

To restore a database using the procedure SP_RESTOREDATABASE or AdsBackup utility, you need to provide the ADSSYS password as a parameter. We have secured our database using encryption and access is resctrited to specific users. But anyone using…
Luc Desroches
  • 33
  • 3
3
votes
2 answers

ArgumentException: Unrecognized property 'user id' in connection string

I'm using: Advantage Database Server 10 Advantage.Data.Provider.dll (v.9.10.2.9) Everything works pretty stable on most of workstations, but today one of our new customers had reported that he experiencing troubles with our app. The logs shows the…
ie.
  • 5,982
  • 1
  • 29
  • 44
3
votes
1 answer

Advantage Database 9.1, Create Table with PK

create table WEBLOG ( ORDERNO CHAR(9) NOT NULL, USERNAME CHAR(50) NOT NULL, ACTION CHAR(255) NOT NULL, NOTE MEMO, UPDATEDATE DATE NOT NULL, UPDATETIME TIME NOT NULL, IP CHAR(15), PK CHAR(36) NOT NULL, PRIMARY KEY(PK) ) the above query does not…
Expert wanna be
  • 10,218
  • 26
  • 105
  • 158
3
votes
1 answer

Get the progress of an Advantage Database query in Delphi

I've searched and searched, but can't find out how to get the progress of a query in Delphi. I've found some information for the Advantage .NET data provider but could use some help with Delphi.
Eric G
  • 3,427
  • 5
  • 28
  • 52
2
votes
1 answer

Problems with subquery, field doesn't exist, but advantage is giving me results

I have a question on subqueries in advantage. As I was analyzing several SQL queries I stumbled upon a strange situation. When I executed the following SQL, I got these results: select * from orderlyn where OLWArtnr in (select OlwArtnr from…
Hanne
  • 39
  • 3
2
votes
3 answers

Safe to use TAdsSettings object in the main thread, and AdsQuery objects in other threads?

I have a Win-CGI application I am currently converting to ISAPI. The application uses the TDataset descendants for Extended Systems Advantage Database Server. As there can be only one instance of a TAdsSettings object, this must be in the main…
Graza
  • 5,010
  • 6
  • 32
  • 37
2
votes
1 answer

Changes in ads.ini not reflected in arc' connection repository

I just moved to win7 64bit from win xp. When in XP, I can changed the content of ads.ini (add or change the connection), and the changes will be reflected in arc connection repository. But now, nothing changes, the new database connection is not…
Tanu
  • 125
  • 2
  • 11
1 2 3
…
26 27