Board index » delphi » Questions about using Delphi 3 with Advantage Server

Questions about using Delphi 3 with Advantage Server

Hello all,
  I'm coming from a Clipper/.dbf background, and have used the
Advantage product with great success in that environment.  I am using
Delphi 3, and have the latest Advantage server NLM's (NetWare, BTW),
as well as the latest client kits from Advantage.  When doing the
Clipper development, I kept duplicates of my .dbf/.ntx files on my
local drive for development, then moved the .exe files to the server
when they were ready for production.  My Clipper program checked for
the Advantage server and if found, opened the files using it (through
Advantage function calls), otherwise, the program just opened them in
regular-shared mode.  All that was required was to link in the
Advantage libraries when compiling.
  Moving to Delphi v2, I used the Apollo product for .ntx file
compatibility, but the Advantage version of Apollo didn't work with
Delphi 3.  I got the newest edition of the Delphi client software from
Advantage, but I'm having a hard time making it work like I had done
with the Clipper solution.  
  There is an ODBC driver and a Delphi client kit I got from
Advantage.  This is the first time I've mucked around with ODBC stuff,
and I'm wondering if it's required at all since I'm not doing anything
with SQL at this time.  
  I just want to access my .dbf and .ntx files on either my local
drive or my server's drive, and have the Advantage compatibility
turned on automatically when a program's being run on the server.
I've tried to set the ODBC driver and directories through the ODBC
manager and can get the program to run on my local drive and the
network drive, but I think it's accessing the data files on my local
machine all the time since I can't see the Advantage user connections
increase on the server's console (when the program is run on the
server).
  I tried to set a database to have (a) a path to the network
drive/directory and (b) no path at all.  This was done in the
Advantage 32-bit Delphi Configuration Utility.  I got the following
message when trying to run the program on the network drive, as well
as on my local drive. "Error 6418: Unable to open service connection."
I set the TAdsSettings to use both Remote and Local servers.
  In the ODBC control panel, I have tried setting the value to the
network drive/directory in the User DSN, the System DSN, and the File
DSN screens, and made sure they are using the Advantage driver.  I
just *know* there's something simple that I'm missing by being a
neophyte with it all.  
  Have any of you gone through this (or a similar situation) and come
out with a working solution?  Please let me know what you did!
Thanks,
Myron

 

Re:Questions about using Delphi 3 with Advantage Server


Re:Questions about using Delphi 3 with Advantage Server


Hello all,
  I'm currently running the Advantage server on a NetWare 3.12 server.
I have numerous apps written in Clipper that make full use of the
Advantage server, but programs written using Delphi 3 and the
Advantage client kit cannot see the server or connect to it in any
way.  I got a utility that checks the environment from the Advantage
people and that utility could only find the server occasionally.
  I got an eval of the Advantage server for NT and ran the same
program on the NT server and it worked every time.  My NetWare server
has the latest patches, too.  Has anyone run into difficulties that
may be sililar to these?  All info is appreciated,
Myron

Re:Questions about using Delphi 3 with Advantage Server


It will be interesting to see the log file generated by the environment
check utility when it failed to find the server.  It is locate in the same
directory as the enviro check utility.

If you can mail that to me, I'll take a look at it.  It will be helpful if
you also get the log file when it worked.

Alex Wong

Quote
C. Myron Ware wrote in message <352b7f45.5947792@news>...
>Hello all,
>  I'm currently running the Advantage server on a NetWare 3.12 server.
>I have numerous apps written in Clipper that make full use of the
>Advantage server, but programs written using Delphi 3 and the
>Advantage client kit cannot see the server or connect to it in any
>way.  I got a utility that checks the environment from the Advantage
>people and that utility could only find the server occasionally.
>  I got an eval of the Advantage server for NT and ran the same
>program on the NT server and it worked every time.  My NetWare server
>has the latest patches, too.  Has anyone run into difficulties that
>may be sililar to these?  All info is appreciated,
>Myron

Re:Questions about using Delphi 3 with Advantage Server


Hi,

I am due to receive the latest (version 5.0) evaluation copy of
Advantage Database in a couple days.  In the mean time I got some
references from teh company.  I checked with one person from Lucent
who uses it extensively and has nothing but high praise for the
product and their support.

I would ask you, knowing this SECOND HAND, have you called their tech
support for help ?

On Wed, 08 Apr 1998 14:26:03 GMT, sun...@usa.net (C. Myron Ware)
wrote:

Quote
>Hello all,
>  I'm currently running the Advantage server on a NetWare 3.12 server.
>I have numerous apps written in Clipper that make full use of the
>Advantage server, but programs written using Delphi 3 and the
>Advantage client kit cannot see the server or connect to it in any
>way.  I got a utility that checks the environment from the Advantage
>people and that utility could only find the server occasionally.
>  I got an eval of the Advantage server for NT and ran the same
>program on the NT server and it worked every time.  My NetWare server
>has the latest patches, too.  Has anyone run into difficulties that
>may be sililar to these?  All info is appreciated,
>Myron

Other Threads