Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #1374

Re: Accessing ADS file on internet

From "Willie Moore" <williem@wmconsulting.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Accessing ADS file on internet
Date 2011-06-13 07:43 -0500
Organization Aioe.org NNTP Server
Message-ID <it50m5$fo8$1@speranza.aioe.org> (permalink)
References <kcq4v65k2ntjpjg1g4vrca02b5vvpdd2jd@4ax.com>

Show all headers | View raw


Dick,

When you are trying to use databases over the internet, you have to make 
sure that your hosting site is configured correctly. The first thing that 
you must always check is that you have the ports (udp and tcp) enabled on 
the router. Most shops turn OFF all non-standard ports including the ones 
needed for MS-SQL. You have to make sure that they are enabled or your 
solution will not work.

Regards,
Willie

"D.J.W. van Kooten"  wrote in message 
news:kcq4v65k2ntjpjg1g4vrca02b5vvpdd2jd@4ax.com...

We try to access a databasefile on our website from a PC with ADS
Server loaded, but we most likely miss a step (or 2) because it fails
from the beginning. I try with a test program from Marc Verkade,
basically I did the following:

1 On the PC I created a data dictionary containing 1 dbf. Uploaded all
data (Add, dbf, cdx,ai and am) to our website. Enable internet access
is checked
2 On our Advantage Configuration utility we set up post 2001 to be the
internet port.
3 We  run the program. First the file is constructed like this:
sFile:="\\192.168.0.101:2001\adstest\adstest.add"

(where the ip address is the on of our website instead)

First, the test program asks for File(sFile)
I was wondering how that could work? In my case it didn't...

Then these 3 lines run:

// Check the connection:
usLoaded:=0
ulRetVal:=DWORD(_CAST,DBFAXSAdsIsServerLoaded(String2Psz(sFile),@usLoaded))


There I do get error 6420 = Unable to discover ADS

But ADS is active (not on the website which is supposed not to be
required, but the PC)!

The trying to connect:

AdsConnect60( String2Psz(sConnect) , ADS_AIS_SERVER,
String2Psz(sUser), String2Psz(sPass), ADS_DEFAULT, @hConnect

I get error
6610 No port specific in the connection string (which Idid supply)
followed by 5033 No connected server was found on the given drive
letter on trying to assign the server.

What step(s) do I miss

Dick 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

Accessing ADS file on internet D.J.W. van Kooten <public@ic2remove.this.com> - 2011-06-10 21:18 +0200
  Re: Accessing ADS file on internet "richard.townsendrose" <richard.townsendrose@gmail.com> - 2011-06-13 01:05 -0700
    Re: Accessing ADS file on internet D.J.W. van Kooten <public@ic2remove.this.com> - 2011-06-14 09:06 +0200
  Re: Accessing ADS file on internet "Willie Moore" <williem@wmconsulting.com> - 2011-06-13 07:43 -0500

csiph-web