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
3 answers

sql distinct with multiple fields requried

I'm using Advantage Database Server by Sybase. I need to elimiate duplicate addbatch's from my report, but having trouble pulling up just distinct records. Any idea what I am missing? here is what I am using SELECT DISTINCT SI.[addbatch] as…
MateoGP
  • 23
  • 3
0
votes
1 answer

Error in ADS OleDB when inserting data into VFP Database?

I need some help with the ADS OleDB Provider for Visual FoxPro. I'm trying to insert data from an 64-Bit .net-Application into a FoxPro Database. The table in which the data will be inserted has about 130'000 records, 139 fields and 11 indexes.…
Feuerwehrler
  • 51
  • 5
0
votes
0 answers

ADS won't stop, used task manager still won't stop

I am not an IT person but I have to play one at work sometimes. I was about to run diagnostics on our EHR which I do weekly, I always stop the ADS and restart it before running the diagnostics. When I went to stop it this time I got an error box…
Whitney Wilson
  • 1
0
votes
3 answers

Money type field returns Dollar, but regional set to UK (Windows 7)

On a Windows 7 machine with Advantage Data Architect version 9.10.0.11, money type data is returned as Dollars, instead of Pounds. Sometimes, it will suddenly switch to Pounds, without me changing any settings. Everything else returns Pounds…
Gareth
  • 1
0
votes
2 answers

Is there any updated documentation for the field names and types for the system tables?

Is there any updated documentation for the field names and types for the Advantage Database system tables?
hsedidin
  • 452
  • 3
  • 8
0
votes
2 answers

Time comparison in Advantage SQL

Trying to do a time comparison in an advantage query. Haven't been able to find the answer in the Advantage documentation. Seems like it should be very simple. Table definition is: CREATE TABLE TBL ( ID AutoInc, Date Date, [T]…
Joshua Evensen
  • 1,544
  • 1
  • 15
  • 33
0
votes
1 answer

Concatenate rows in select query (in Advantage Data Architect)

How can I concatenate rows in select query? (in Advantage Data Architect) I tried run the following scripts: The first script: declare @str string; set @str = ''; select @str = @str + field_1 from my_table1 But I get a result where all rows contain…
netwer
  • 737
  • 11
  • 33
0
votes
1 answer

Advantage Database server connection

I am very new to Advantage Database Server. I am trying to connect to a ADS database using Java. Please give me a step by step solution how to do this. I installed the necessary JAR file, but still can not connect. Here is my connection…
ketan110
  • 171
  • 1
  • 1
  • 6
0
votes
1 answer

Rails app connection with advantage database

I'm trying to connect a Rails app 3.2.13 with an advantage database. I keep taking this error when I run rake db:create. Any suggestions what I could do to fix that? Thank you! C:\Users\Droste\rails_proj\lo_app>rake db:create --trace ** Invoke…
jose
  • 1
  • 2
0
votes
1 answer

Option Value Changed - ODBC Error 2169

Thank you for your response. I am using Powerbasic (www.powerbasic.com) as my compiler and SQLTools as a third party tool to access ADS through ODBC. I must stat that this error also appers when I take other actions like Update, Delete, Find, etc.…
Fredrick Ughimi
  • 11
  • 1
  • 3
0
votes
1 answer

Java + Advantage Database Server -> Login failed

this java app was working fine for years. It reads the data from an Advantage Database Server an accounting software uses. Since a recent update of that accounting software, all I get is a "Login failed" exception. As far as my knowledge goes,…
user3726329
  • 1
  • 1
0
votes
1 answer

Searching for ads asqlcmd utility

I'm using Advantage Database Server v10.10.0.6 I know there is a commandline utility known as ASQLCMD. It wasn't installed with the initial installation (1-1-2013) Can anybody tell me where to find it? Reason: I desperately need it for offline…
user3709857
  • 1
0
votes
1 answer

Add surrogate id key to keyless tables in legacy database; how might it affect business applications that talk to the database?

I am asking this because we worked with legacy database all the time and it can be a problem with you try to put an ORM on a table without primary keys. In this forum, many respondents to this problem have said (quite nonchalantly, in my opinion),…
delta2006
  • 425
  • 2
  • 4
  • 13
0
votes
1 answer

Subsonic and Advantage Database Server

Does Subsonic work with Advantage Database server and if so are there any TT files to generate the necessary code
Jon
  • 38,814
  • 81
  • 233
  • 382
0
votes
1 answer

AdsSys forget password -- how to reset?

I'm being assigned to maintain an Advantage-based Clipper program. I tried to use Advantage Data Architect program to connect to the database, but failed. I'm thinking the password I got is wrong... maybe the previous maintainer or somebody else…
user3448777
  • 33
  • 1
  • 4
1 2 3
…
26 27