Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1374
| 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> |
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
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