Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ADS 7.1 International + Windows 2003 Terminal Services + 16-bit Visual FoxPro application

2 posts in Networking Last posting was on 2006-12-12 16:38:32.0Z
Kim Groves Posted on 2006-12-12 11:51:35.0Z
From: "Kim Groves" <kim_groves@bradycorp.com>
Newsgroups: advantage.networking
Subject: ADS 7.1 International + Windows 2003 Terminal Services + 16-bit Visual FoxPro application
Date: Tue, 12 Dec 2006 22:51:35 +1100
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 61.14.140.211
Message-ID: <457e96cc@solutions.advantagedatabase.com>
X-Trace: 12 Dec 2006 04:47:24 -0700, 61.14.140.211
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!61.14.140.211
Xref: solutions.advantagedatabase.com Advantage.Networking:673
Article PK: 1132093

Hi,

My company has an Advantage Database Server 7.x license. Our application is
a 16-bit windows application which I believe is compiled in
VisualObjects/Clipper/Visual FoxPro. It uses the dll files adsip16.dll and
AXCOMM16.DLL.

I recently updated ADS to version 7.1 by downloading the International setup
program from devzone.advantagedatabase.com.

However, as soon as I install ADS 7.1, my 16-bit applications stop working.
By "stop working", I mean that I double-click the application to launch it,
the cursor briefly changes to an hourglass, and then changes back to normal.
No error messages appear, the application window does not appear. There are
not entries in the event log and there are no error codes in ads_err.adt.

If I format the Windows partition and do a full reinstall of Windows Server
2003, I can install either ADS v7.0 or ADS v8.1 (with an evaluation license)
and these will both work correctly (note: ADS 8.1 will work for our
applications without updating the client drivers to version 8.1).

I have tried installing the Windows server several times and it is
definitely the installation of ADS 7.1 which is resulting in the glitch.

We also run some 32-bit applications which access the same database on
Advantage Database Server and these work without an error (unless I try to
access a database feature not supported by the backwards compatibility). One
particular program is running as a Windows Service. This program is
encountering an error where it will report that it has exceeded its'
MAX_POOL_SIZE and has run out of connections. Extended Systems have
acknowledged this as a bug in the 7.0 Data Provider and version 7.1 of the
.NET data provider is supposed to have resolved this issue.

I have checked rsop.msc, and the Compatibility policy that can disable
running 16-bit applications is not enabled.

Can anybody shed any light on this issue? I am getting quite frustrated. I
really want the Windows Service application to run without requiring
restarts during the day (to clear the connection pool), but I am in a
position now where I need to reinstall the database server because I tried
to install ADS 7.1 again. If there is a way to re-enable the clipper/16-bit
applications without reinstalling the OS I would be extremely grateful.

Regards,

Kim Groves
+61 2 8717 6448


Mark Wilkins Posted on 2006-12-12 16:38:32.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.networking
References: <457e96cc@solutions.advantagedatabase.com>
Subject: Re: ADS 7.1 International + Windows 2003 Terminal Services + 16-bit Visual FoxPro application
Date: Tue, 12 Dec 2006 09:38:32 -0700
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <457eda0c@solutions.advantagedatabase.com>
X-Trace: 12 Dec 2006 09:34:20 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Networking:674
Article PK: 1132092

Hi Kim,

Is it possible to send us a simple 16-bit application that demonstrates the
problem? I know that we ran 16-bit Clipper tests against the 7.1 release.
I'm not sure about 16-bit Windows, but I just now tested it with a 16-bit
Windows application and was able to connect (and open a table) using
adscom16.dll/adsip16.dll to both the original 7.1 release and the latest
service update (7.1.0.19).

Mark Wilkins
Advantage R&D

"Kim Groves" <kim_groves@bradycorp.com> wrote in message
news:457e96cc@solutions.advantagedatabase.com...
> Hi,
>
> My company has an Advantage Database Server 7.x license. Our application
> is a 16-bit windows application which I believe is compiled in
> VisualObjects/Clipper/Visual FoxPro. It uses the dll files adsip16.dll and
> AXCOMM16.DLL.
>
> I recently updated ADS to version 7.1 by downloading the International
> setup program from devzone.advantagedatabase.com.
>
> However, as soon as I install ADS 7.1, my 16-bit applications stop
> working. By "stop working", I mean that I double-click the application to
> launch it, the cursor briefly changes to an hourglass, and then changes
> back to normal. No error messages appear, the application window does not
> appear. There are not entries in the event log and there are no error
> codes in ads_err.adt.
>