Remote Network Connection

Remote Network Connection

Post by DickJone » Tue, 13 Aug 2002 08:05:53



Hi Guys,

Sorry I didn't get back sooner.  I got involved with another hot  project
that I couldn't drop right after I posted this question

Thanks for all the quick response , even though I didn't get to read it for
a while.

It appears that pcAnywhere or LapLink are required for an internet
connection.

There is pcAnywhere on the host network.  It is only  used for file transfer
now.  DSL is connected to the network switch so all the network computers
can use the DSL.

 I have an older version of LapLink on one of my computers.  I understand
that both ends must use the same system. Any preference??

I have started to look on the pcAnywhere knowledge base for internet
connection info.

I think I am understanding that the  pcAnywhere remote connection is
computer to computer,  not computer to network??   and to access other
computers on the network you must use separate IP address for each??

Can you use network neighborhood to MAP the IP address like another computer
name???

Thanks,      * Jones


Quote:> Hi,

> I need to connect a couple of computers at a remote location to the LAN at
> the main office.

> They need to access Pdox data on a win 98 peer to peer computer and on a
win
> 2000 server. both are on the same network in the office.

> In looking at the Windows manuals it appears I can set up dial up network
at
> both ends.  I would like to use the internet or DSLinternet to improve
> performance.

> 3-com said I just need a router/gateway at each end and turn on the
dial-up
> network.  They couldn't tell me how to connect through the internet.

> Anyone done this???  or know an appropriate network newsgroup or
website???

> Thanks,          Dick Jones

 
 
 

Remote Network Connection

Post by Steve Urbac » Tue, 13 Aug 2002 08:31:05




Quote:>Hi Guys,

>Sorry I didn't get back sooner.  I got involved with another hot  project
>that I couldn't drop right after I posted this question

>Thanks for all the quick response , even though I didn't get to read it for
>a while.

>It appears that pcAnywhere or LapLink are required for an internet
>connection.

>There is pcAnywhere on the host network.  It is only  used for file transfer
>now.  DSL is connected to the network switch so all the network computers
>can use the DSL.

> I have an older version of LapLink on one of my computers.  I understand
>that both ends must use the same system. Any preference??

>I have started to look on the pcAnywhere knowledge base for internet
>connection info.

>I think I am understanding that the  pcAnywhere remote connection is
>computer to computer,  not computer to network??   and to access other
>computers on the network you must use separate IP address for each??

Only the HOST computer needs a static IP address so that
the remote can "call" it. Having static IP at both ends
allows you to tighten the secutity by only accepting PCAW calls
from specified addresses.  PCAW win remotes can connect to PCAW dos
hosts. I just don't think this a needed feature for you <g>.I have
also used PCAW 8.x to 9.x with success.
I prefer Laplink tech, but you will probably find more PCAW
installations.

Happy connecting
Steve U

- Show quoted text -

>Can you use network neighborhood to MAP the IP address like another computer
>name???

>Thanks,      * Jones



>> Hi,

>> I need to connect a couple of computers at a remote location to the LAN at
>> the main office.

>> They need to access Pdox data on a win 98 peer to peer computer and on a
>win
>> 2000 server. both are on the same network in the office.

>> In looking at the Windows manuals it appears I can set up dial up network
>at
>> both ends.  I would like to use the internet or DSLinternet to improve
>> performance.

>> 3-com said I just need a router/gateway at each end and turn on the
>dial-up
>> network.  They couldn't tell me how to connect through the internet.

>> Anyone done this???  or know an appropriate network newsgroup or
>website???

>> Thanks,          Dick Jones

,        _
,       | \                           MKA: Steve Urbach
,       |  )erek                      No JUNK in my email please

,  / / /                            
         Running United Devices "Cure For Cancer" Project 24/7  
         Have you helped? http://www.veryComputer.com/

 
 
 

Remote Network Connection

Post by DickJone » Tue, 13 Aug 2002 09:42:47


Hi Tony,

The PIM and JSI appear to be Paradox to Paradox, Not Pardox to DataBase.
Am I misunderstanding something???

Thanks,  * Jones


>*,

> You might want to download PIM from thedbaddons.com. (Instant Messenger
for
> Paradox)

> It seems to demonstrate the concept of direct Paradox to Paradox
> communication best.

> But instead of 'talking', the 2 (or more) systems can use each other for
> querying each others data.

> --
> --
>  For the quickest and best Paradox support see:
>  http://www.veryComputer.com/

>  Tony McGuire
>  http://www.veryComputer.com/
>  http://www.veryComputer.com/
>  http://www.veryComputer.com/
>  http://www.veryComputer.com/(JSI)
> "I woke up and was able to get myself out of bed.
> Being that fortunate, what's to complain about?"
> _____________

 
 
 

Remote Network Connection

Post by DickJone » Tue, 13 Aug 2002 09:51:55


Thanks Dennis,

I have printed it and started to read it

Dick Jones


> You might want to check out the web ocx and let the remote users do it
through a
> browser interface as a good alternative to what the others have said.
Check out
> Tony McGuire's lessons on the Web Server OCX on our Paradox resources page
(link
> in my signature) or at thedbcommunity.com

> Denn Santoro
> President
> Resource Development Associates
> http://www.RDAWorldWide.Com
> Offices in the United States and Germany
> Providing solutions to health care, business, governments and non-profits
since
> 1982


> > Hi,

> > I need to connect a couple of computers at a remote location to the LAN
at
> > the main office.

> > They need to access Pdox data on a win 98 peer to peer computer and on a
win
> > 2000 server. both are on the same network in the office.

> > In looking at the Windows manuals it appears I can set up dial up
network at
> > both ends.  I would like to use the internet or DSLinternet to improve
> > performance.

> > 3-com said I just need a router/gateway at each end and turn on the
dial-up
> > network.  They couldn't tell me how to connect through the internet.

> > Anyone done this???  or know an appropriate network newsgroup or
website???

> > Thanks,          Dick Jones

 
 
 

Remote Network Connection

Post by Liz » Tue, 13 Aug 2002 10:12:28


Dick,

You'd have Paradox on the server side returning data to Paradox
on the client side which requests and uses the data.  So you'd
need a machine running Paradox at the end where the data is (just
like you'd need one running PCAW if you were going to go that
route).  JSI would be faster, IMO because you're just sending the
needed data, not an entire picture of the screen...  (But then I
haven't used PCAW for years... maybe they've sped it up.)

Liz


> Hi Tony,

> The PIM and JSI appear to be Paradox to Paradox, Not Pardox to DataBase.
> Am I misunderstanding something???

> Thanks,  * Jones

 
 
 

Remote Network Connection

Post by DickJone » Wed, 14 Aug 2002 08:32:43


Hi Liz,

I was concerned about that.  I was hoping that it would just make the
connection and let Pdox on the remote computer call for the data like it
does on a network connection.

Thanks,    Dick Jones


>*,

> You'd have Paradox on the server side returning data to Paradox
> on the client side which requests and uses the data.  So you'd
> need a machine running Paradox at the end where the data is (just
> like you'd need one running PCAW if you were going to go that
> route).  JSI would be faster, IMO because you're just sending the
> needed data, not an entire picture of the screen...  (But then I
> haven't used PCAW for years... maybe they've sped it up.)

> Liz


> > Hi Tony,

> > The PIM and JSI appear to be Paradox to Paradox, Not Pardox to DataBase.
> > Am I misunderstanding something???

> > Thanks,  * Jones

 
 
 

Remote Network Connection

Post by Liz » Wed, 14 Aug 2002 08:47:46


Dick,

Think about how Paradox works on a network (with shared files) -
that might be the easy way, but it's also the most band-width
intensive way.  When a table is in the data model of a Paradox
form or report, and a user opens that form/report, ****the entire
table is pulled to the local workstation****  That is why Paradox
requires so much band width!

So, if you alter your methodology to the commonly accepted
client/server or web methodology - where you request ***only the
data you need*** and return only the data that's changed (or that
was originally requested, however you choose), then you greatly
reduce the amount of data coming across the network (internet or
LAN) and thereby increase transmission speeds.

Liz


> Hi Liz,

> I was concerned about that.  I was hoping that it would just make the
> connection and let Pdox on the remote computer call for the data like it
> does on a network connection.

> Thanks,    Dick Jones

 
 
 

Remote Network Connection

Post by DickJone » Thu, 15 Aug 2002 02:45:17


Hi Liz,

I think what you are saying is that the remote paradox sends a request to
paradox on the server for data, not to the database, then paradox on the
server sends back the requested data.

If I understand you correctly, it sounds interesting and doable.   However I
don't think I have seen any examples of that.  Can you lead me to some
overview and examples???

I thought true client/server function was one of the reasons people were
using InterBase with OPal.

Thanks,  * Jones


>*,

> Think about how Paradox works on a network (with shared files) -
> that might be the easy way, but it's also the most band-width
> intensive way.  When a table is in the data model of a Paradox
> form or report, and a user opens that form/report, ****the entire
> table is pulled to the local workstation****  That is why Paradox
> requires so much band width!

> So, if you alter your methodology to the commonly accepted
> client/server or web methodology - where you request ***only the
> data you need*** and return only the data that's changed (or that
> was originally requested, however you choose), then you greatly
> reduce the amount of data coming across the network (internet or
> LAN) and thereby increase transmission speeds.

> Liz


> > Hi Liz,

> > I was concerned about that.  I was hoping that it would just make the
> > connection and let Pdox on the remote computer call for the data like it
> > does on a network connection.

> > Thanks,    Dick Jones

 
 
 

Remote Network Connection

Post by Tony McGuir » Thu, 15 Aug 2002 02:49:08


: If I understand you correctly, it sounds interesting and doable.   However
I
: don't think I have seen any examples of that.  Can you lead me to some
: overview and examples???
:

http://www.thedbaddons.com/jsip/

That's how JSI works.  OPAL control on both ends.  Full GUI for the client.

(Up to) 128bit encryption of your data WITHOUT SSL.

--
 Tony McGuire
 http://www.thedbaddons.com
 http://www.thedbcommunity.com
 http://www.thedbcommunity.com/inet/
 http://www.thedbaddons.com/jsip/ (JSI)
"I woke up and was able to get myself out of bed.
Being that fortunate, what's to complain about?"
_____________

 
 
 

Remote Network Connection

Post by DickJone » Thu, 15 Aug 2002 05:22:04


Hi Tony,

I have just started to read the JSI and PIM stuf I printed.

My first approach to this whole thing was to treat it like we are now doing
by taking the Laptop back and forth each month.  All the data is updated in
home office, loaded on the laptop just before it is needed, send it to LV
for a couple of days of activity, send the laptop back home.  I have some
code to collect any changes that were made at LV and transfer it to the
database on the server.  With activity to start each week I thought we could
just copy the updated DB (about 40 MB)each Friday before the activity starts
using pcAW, then transfer the small set of changes (about 3 to 5 MB) back
after the weekend.  However the users wanted network connection.  Sometimes
you try to do what the user wants even if it is wrong. (I remember telling
my kids "your mother is not always right, but she is always your mother").

This JSI might work for us.  I will try to understand it better.

Thanks,    * Jones


Quote:

> : If I understand you correctly, it sounds interesting and doable.
However
> I
> : don't think I have seen any examples of that.  Can you lead me to some
> : overview and examples???
> :

> http://www.veryComputer.com/

> That's how JSI works.  OPAL control on both ends.  Full GUI for the
client.

> (Up to) 128bit encryption of your data WITHOUT SSL.

> --
>  Tony McGuire
>  http://www.veryComputer.com/
>  http://www.veryComputer.com/
>  http://www.veryComputer.com/
>  http://www.veryComputer.com/(JSI)
> "I woke up and was able to get myself out of bed.
> Being that fortunate, what's to complain about?"
> _____________

 
 
 

Remote Network Connection

Post by Tony McGuir » Thu, 15 Aug 2002 08:46:42


: This JSI might work for us.  I will try to understand it better.

If you have specific questions feel free to e-mail me; you can also use our
forums:
http://www.jedstar.com/forums/

With JSI that data can be updated 'live' from multiple sites - to multiple
sites (or just have a central server); day to day, minute to minute or
transaction to transaction.

--
 Tony McGuire
 http://www.thedbaddons.com
 http://www.thedbcommunity.com
 http://www.thedbcommunity.com/inet/
 http://www.thedbaddons.com/jsip/ (JSI)
"I woke up and was able to get myself out of bed.
Being that fortunate, what's to complain about?"
_____________

 
 
 

Remote Network Connection

Post by DickJone » Fri, 16 Aug 2002 03:17:57


Hi Tony,

The first page of the JSI suggested reviewing Hercules in Pdox 8 or 9, and
Tony McGuire's Internet Lesions.

I found the tables and forms for Hercules. I have not found any discussion
on it yet.  I copied your Internet lesions and will start reading them soon.

Thanks,      * Jones


Quote:

> : This JSI might work for us.  I will try to understand it better.

> If you have specific questions feel free to e-mail me; you can also use
our
> forums:
> http://www.veryComputer.com/

> With JSI that data can be updated 'live' from multiple sites - to multiple
> sites (or just have a central server); day to day, minute to minute or
> transaction to transaction.

> --
>  Tony McGuire
>  http://www.veryComputer.com/
>  http://www.veryComputer.com/
>  http://www.veryComputer.com/
>  http://www.veryComputer.com/(JSI)
> "I woke up and was able to get myself out of bed.
> Being that fortunate, what's to complain about?"
> _____________

 
 
 

Remote Network Connection

Post by Tony McGuir » Fri, 16 Aug 2002 03:24:17


Quote:> I have not found any discussion

Go to the -web groups on pnews and cnews.  Unfortunately, a LOT of great
stuff was deleted from cnews (July 2000, at least 1,000 posts were lost).

Most of us now participate on the -web group on pnews; cnews -web has kinda
died.

Those recommendations were for overall familiarization, tho.  Which the
articles should mostly accomplish as to basics of OPAL and the ocx.

--
--
 For the quickest and best Paradox support see:
 http://www.veryComputer.com/

 Tony McGuire
 http://www.veryComputer.com/
 http://www.veryComputer.com/
 http://www.veryComputer.com/
 http://www.veryComputer.com/(JSI)
"I woke up and was able to get myself out of bed.
Being that fortunate, what's to complain about?"
_____________


: Hi Tony,
:
: The first page of the JSI suggested reviewing Hercules in Pdox 8 or 9, and
: Tony McGuire's Internet Lesions.
:
: I found the tables and forms for Hercules. I have not found any discussion
: on it yet.  I copied your Internet lesions and will start reading them
soon.
:
: Thanks,      * Jones
:
:


: >
: > : This JSI might work for us.  I will try to understand it better.
: >
: > If you have specific questions feel free to e-mail me; you can also use
: our
: > forums:
: > http://www.veryComputer.com/
: >
: > With JSI that data can be updated 'live' from multiple sites - to
multiple
: > sites (or just have a central server); day to day, minute to minute or
: > transaction to transaction.
: >
: >
: > --
: >  Tony McGuire
: >  http://www.veryComputer.com/
: >  http://www.veryComputer.com/
: >  http://www.veryComputer.com/
: >  http://www.veryComputer.com/(JSI)
: > "I woke up and was able to get myself out of bed.
: > Being that fortunate, what's to complain about?"
: > _____________
: >
: >
: >
:
:

 
 
 

Remote Network Connection

Post by DickJone » Sat, 17 Aug 2002 06:54:14


Thanks Tony,

I am certainly finding enough to study.  Now I need to put some of it
together and see if  I can make it work.

I am sorry that cNews has fallen off.. I still read it, a lot of the
regulars still respond there.  I don't believe there is nearly the amount of
traffic that there was in '96 or '97 when I first started reading the news
group.

When I first started using Pdox in '86 or '87 , and I think it was with Pdox
1 (maybe 2),  I used PAL-Programmer to start my first applications.  I
thought it was hard to change so I opened the code and started reprogramming
it  The PAL-Programmer was not what I would have liked but it worked to get
me started.

Thanks,  * Jones


Quote:

> > I have not found any discussion

> Go to the -web groups on pnews and cnews.  Unfortunately, a LOT of great
> stuff was deleted from cnews (July 2000, at least 1,000 posts were lost).

> Most of us now participate on the -web group on pnews; cnews -web has
kinda
> died.

> Those recommendations were for overall familiarization, tho.  Which the
> articles should mostly accomplish as to basics of OPAL and the ocx.

 
 
 

Remote Network Connection

Post by Tony McGuir » Sat, 17 Aug 2002 07:06:38


Yes.  Kinda like Application Framework that came with p9 and earlier.

A learning tool, perhaps, but hard to modify.  Still, you could inspect the
code it wrote and get SOME idea of what was going on.

--
--
 For the quickest and best Paradox support see:
 http://www.thedbcommunity.com/support/

 Tony McGuire
 http://www.thedbaddons.com
 http://www.thedbcommunity.com
 http://www.thedbcommunity.com/inet/
 http://www.thedbaddons.com/jsip/ (JSI)
"I woke up and was able to get myself out of bed.
Being that fortunate, what's to complain about?"
_____________

 
 
 

1. Remote Connection Error "General Network Error"?

If anyone has ever run into this error before I would really appreciate the
fix to my problem.

I am creating an application in VB that connects to my remote SQL Server at
the office. In my connection string I'm using a provider of SQLOLEDB with
the DATA SOURCE of my IP address on the server.

This application works fine when connecting on my LAN but remotely via
TCP/IP I get a "General Network Error" of note I also get this error when
using DTS Import wizard using this IP address and senario.

Is my Server's TCP/IP settings in SQL Server configured improperly? Again
any input would really help me out.

Merry Christmas,
Trent from
CANADA

2. 2nd RFD: comp.databases.berkeley-db

3. MS SQL connection string for remote internet connection?

4. Index Out Of Date !!! (HELP!)

5. 8,000 Records...Out of Memory? Help!

6. Strange Connection Performance (remote DSL connection faster than local network?)

7. How to modify access database column propertiy "Required" using SQL

8. connecting Enterprise manager to remote server in the network

9. VB6, Remote Con: Client Network Utility??

10. Network traffic generated by Stored Proc (local, and remote)

11. Stored procedure generated network traffic (local, and remote)