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 thread. TAdsQuery objects are needed in the request threads. Will this work - that is, wil...
I have a master / detail table and want to update some summary values in the master table against the detail table. I know I can update them like this: update MasterTbl set TotalX = (select sum(X) from DetailTbl where DetailTbl.MasterID = MasterTbl.ID) update MasterTbl set TotalY = (select sum(Y) from DetailTbl where DetailTbl.MasterID...
How do I expose the functionality found in Advantage.Data.Provider.dll thru a wrapper. My goal is to install/deploy the COM+ into a 64 bit server. The Advantage.Data.Provider.dll is a 32 bit driver. Don't want to upgrade to Advantage Database Server 9 which does support 64 bit. I have created a serviced .NET Component in c#, no problem...
I am running into what seems to me to be a bug in the Advantage Database PHP Extension (I know, I know...). I've reported it as a bug, but still haven't heard anything back, so I thought I'd run it by you guys. Working Code: for ($i = 0; $i < 100; $i++) { $connection = ads_connect( 'DataDirectory=\\some\path\;ServerTypes=2;RightsCh...
I am in the process of upgrading a few in-house applications from ADS7.1 to 8.1. I was told a while back that there are changes in return values of the avg() function as well as some division calculations, but I cannot find any documentation on these changes. Does anyone know what I'm talking about or have a link that explains the detail...
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 correct version of an ADO.NET data provider that I was using. Only by including a version o...
My client is using Advantage Database Server and wants to move to SQL Server but obviously wants to move all his clients data as part of the upgrade over to SQL Server. I've thought about writing an app to do the transfer but thinking it might be more trouble than its worth. What would you recommend? ...
Does anyone know if the sybase ads vfp provider works in 64 bit? Currently we have to build our .NET applications targeting x86 to be able to use the vfpoledb provider that only runs in 32 bit. Any solutions or suggestions would be appreciated. ...
Hello, i'm creating a web app that's running on an Advantage Database server, not my personal weapon of choice but that's what the company uses. I have a couple of big lists that the end-users need to be able to view however i can't seem to find a way to page through the results in SQL. Is there something like LIMIT / OFFSET for Adva...
I am working with some data I obtained that is read with a program using an embedded Advantage Database Server. The program was not written by me and does not have all of the functionality that I need. I would like to convert this data to a different format so that I can work with it more freely, such as MySQL. I know that Sybase pr...
Title says it all. Sample connection string Provider=Advantage.OLEDB.1;Data Source=c:\Bugtest;ServerType=ADS_LOCAL_SERVER; TableType=ADS_VFP_TABLE Thanks in advance. Cetin ...
I have a client that currently uses a local Advantage Database on their PC along with an application. They are thinking of upscaling their setup to have multiple applications running communicating with a database server i.e/a client-server environment. They are now considering the best database for this approach. They are looking at t...
Does anyone know if there are any ORM tools or Code Generation tools that work against an Advantage Database? ...
In our report generation application, there's some pretty hefty queries that take a considerable amount of time to run. User feedback up until this point has been basically zip while the server chugs away at their request. I noticed that there's a tab on the ADA Management Utility that shows progress on the query both as percent comple...
Is it safe to update DBF files using Advantage Local Server .Net provider whilst a FoxPro application is running that may also be accessing the DBF files? i.e. does Advantage take care of row locking? ...
Hi, i try to create an AEP for my advantage Database. I create a AEP project on VS2008 and i,ve got the dll. I copy de .dll to the folder where is my datadictionnary. I tried to register my dll with regasm but i've always got the warning to give strong name, but i tried a lot of thing and i got this error again. So i tried to install the...
Hello, I am connecting to ADS through ODBC DSN. Everything works well until I tried out my Save Routine. Data is saved quite alright but I get an error that says - "Option value changed". What could this be? Can't find in the help file. The full error message is: ODBC - 2169 [iAnywhere Solutions][Advantage ODBC Driver] Option Value...
Hi, I am using C# and I am having trouble loading large files into a binary field use byte arrays. Basically, if I load a file that is too large, I get memory problems. Is there a way to load a file into a binary field without using large amounts of ram, i.e. avoid loading the file into memory first? If it helps, I am using Advantage...
I have a question about a performance of stored procedures in the ADS. I created a simple database with the following structure: CREATE TABLE MainTable ( Id INTEGER PRIMARY KEY, Name VARCHAR(50), Value INTEGER ); CREATE UNIQUE INDEX MainTableName_UIX ON MainTable ( Name ); CREATE TABLE SubTable ( Id INTEGER PRIMARY ...
Hello Edgar, 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. But I don't get this error when I am using MS Access. Here is my save rou...