Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ODBC connection via Internet

5 views
Skip to first unread message

jo...@getageek.com

unread,
Nov 9, 2000, 3:00:00 AM11/9/00
to
I am a consultant that is working for a client remotely. They use a Sybase
SQL Anywhere Network Server (version 5.5.04) for one of their applications.
I have remote access to this machine via PCAnywhere through TCP/IP. I
want to be able to simply access the database from my machine using an ODBC
data source to speed up the front end performance.

I cannot seem to find any ODBC drivers for this version...Only ASA stuff. I
downloaded an evaluation of ASA but cannot seem to get the ODBC DSN to
connect properly. The machine I use is behind a Windows ICS "proxy"
machine which is connected to the Internet via Cable Modem. My internal IP
address is 192.168.0.1 However, my external IP address (from ICS) is
24.25.95.190. The latter IP is what is trusted through the remote
firewall. I can access the machine directly (i.e. map a drive letter) as
well as through PCAnywhere.
I have tried many incarnations of parameter settings for the tcpip protocol
in the ODBC configuration...to no avail.

When using UDP broadcast packets, here is what the output gives me:

Thu Nov 09 2000 16:55
CONN: Attempting to connect with default DSN using:
UID=hammer;PWD=******;ENG=ht_h1112;ASTOP=YES;INT=NO;DBG=YES;LOG=c:\test.txt;DMRF=NO;LINKS=TCPIP{MyIP=NONE;DoBroadcast=NO;Host=38.211.126.235;Port=2638}
Looking for ht_h1112
Not performing a broadcast
Trying 38.211.126.235
Trying 38.211.126.235
No reply received
CONN: Cannot connect


Without the UDP parameter:

Thu Nov 09 2000 16:54
CONN: Attempting to connect with default DSN using:
UID=hammer;PWD=******;ENG=ht_h1112;ASTOP=YES;INT=NO;DBG=YES;LOG=c:\test.txt;DMRF=NO;LINKS=TCPIP{MyIP=NONE;DoBroadcast=NO;Host=38.211.126.235;Port=2638;UDP=NO}
Looking for ht_h1112
Trying 38.211.126.235
TCP/IP link, function connect(), error code 10061
CONN: Cannot connect

Is this scenario possible or am I just thinking to big?

0 new messages