Sybase ODBC驱动程序不能通过VPN工作

我需要在本地计算机上运行客户端软件,并通过VPN链接(Team Viewer VPN)进行通信以连接到实时数据库,以便将debugging程序附加到客户端软件,并解决客户端遇到的一些问题。

当客户端networking上的任何一台计算机连接它工作正常。 这是驱动程序debugging信息的输出。

Sun Aug 05 2012 15:06:10 15:06:10 CONN: Application information: 15:06:10 "HOST=WORKSTATION36;OS=Windows XP Build 2600 Service Pack 3;PID=0x11a0;THREAD=0xdcc;EXE=C:\abba\dbisqlc.exe;VERSION=7.0.4.3472;API=DBLIB" 15:06:10 CONN: Attempting to connect using: UID=abdbo;PWD=*****;DBN=abba;ENG=abba;ASTOP=YES;DBG=YES;LOG=C:\log\odbcLog.txt;DMRF=NO;LINKS=TCPIP{} 15:06:10 Trying to start TCPIP link ... 15:06:10 Loading wsock32.dll 15:06:10 Loading ws2_32.dll 15:06:10 TCP using Winsock version 2.0 15:06:10 My IP address is 192.168.0.111 15:06:10 My IP address is 127.0.0.1 15:06:10 TCPIP link started successfully 15:06:10 Trying 192.168.0.2:2638 15:06:10 Found database server abba on TCPIP link 15:06:10 Client connected 15:06:10 CONN: Connected to the server 15:06:10 [1174510859] CONN: Connected to database successfully 15:06:10 [1174510859] Client disconnected 

但是,如果我尝试连接使用我的VPN链接,它不起作用。

 Sun Aug 05 2012 17:13:26 17:13:26 CONN: Application information: 17:13:26 "HOST=CONVERSIONVM;OS=Windows 2003 Build 3790 Service Pack 2;PID=0x878;THREAD=0x98c;EXE=C:\abba\dbisqlc.exe;VERSION=7.0.4.3472;API=DBLIB" 17:13:26 CONN: Attempting to connect using: UID=abdbo;PWD=*****;DBN=abba;ENG=abba;ASTOP=YES;DBG=YES;LOG=C:\log\odbcLog.txt;DMRF=NO;LINKS=TCPIP{} 17:13:26 Trying to start TCPIP link ... 17:13:26 Loading wsock32.dll 17:13:26 Loading ws2_32.dll 17:13:26 TCP using Winsock version 2.0 17:13:26 My IP address is 7.192.193.89 17:13:26 My IP address is 10.0.1.106 17:13:26 My IP address is 127.0.0.1 17:13:26 TCPIP link started successfully 17:13:26 Looking for abba 17:13:26 I am in a class A network 17:13:26 Sending broadcast 17:13:26 Using broadcast address of: 7.255.255.255:2638 17:13:26 I am in a class A network 17:13:26 Sending broadcast 17:13:26 Using broadcast address of: 10.255.255.255:2638 17:13:26 I am in a class A network 17:13:26 Sending broadcast 17:13:26 Using broadcast address of: 127.255.255.255:2638 17:13:27 No reply received 17:13:27 Resending 17:13:28 No reply received 17:13:28 Resending 17:13:29 No reply received 17:13:29 Resending 17:13:30 No reply received 17:13:30 Resending 17:13:31 No reply received 17:13:31 CONN: Cannot connect 

我认为可能出现的一些问题是Team Viewer希望我通过它的特殊IP路由stream量,而不是通过它传输广播。 我试图告诉TCP / IP连接使用服务器的IP和端口,但是这也没有解决问题

 Sun Aug 05 2012 17:29:29 17:29:29 CONN: Application information: 17:29:29 "HOST=CONVERSIONVM;OS=Windows 2003 Build 3790 Service Pack 2;PID=0x13c;THREAD=0x810;EXE=C:\abba\dbisqlc.exe;VERSION=7.0.4.3472;API=DBLIB" 17:29:29 CONN: Attempting to connect using: UID=abdbo;PWD=*****;DBN=abba;ENG=abba;ASTOP=YES;DBG=YES;LOG=C:\log\odbcLog.txt;DMRF=NO;LINKS=TCPIP{IP=7.192.141.131;PORT=2638} 17:29:29 Trying to start TCPIP link ... 17:29:29 Loading wsock32.dll 17:29:29 Loading ws2_32.dll 17:29:29 TCP using Winsock version 2.0 17:29:29 My IP address is 7.192.193.89 17:29:29 My IP address is 10.0.1.106 17:29:29 My IP address is 127.0.0.1 17:29:29 TCPIP link started successfully 17:29:29 Looking for abba 17:29:29 I am in a class A network 17:29:29 Sending broadcast 17:29:29 Using broadcast address of: 7.255.255.255:2638 17:29:29 I am in a class A network 17:29:29 Sending broadcast 17:29:29 Using broadcast address of: 10.255.255.255:2638 17:29:29 I am in a class A network 17:29:29 Sending broadcast 17:29:29 Using broadcast address of: 127.255.255.255:2638 17:29:29 Trying 7.192.141.131 17:29:29 Trying 7.192.141.131 17:29:30 No reply received 17:29:30 Resending 17:29:31 No reply received 17:29:31 Resending 17:29:32 No reply received 17:29:32 Resending 17:29:33 No reply received 17:29:33 Resending 17:29:34 No reply received 17:29:34 CONN: Cannot connect 

有一点我注意到端口没有列在Trying 7.192.141.131即使我明确地告诉它使用那个端口,工作日志中的同一行显示包含Trying 192.168.0.2:2638的端口。

防火墙在客户端和服务器上都是禁用的,所以问题与此无关,我想这是因为端口号没有设置,但我不知道我在做什么错误导致它不被设置。

这是使用Adaptive Server Anywhere 7.0驱动程序。