SSL VPN
Reply
Regular Visitor
cangeles
Posts: 6
Registered: ‎05-28-2009
0

ODBC through WSAM

We are trying to configure an ODBC connection to an MS SQL server through WSAM.  We create a System DSN using the SQL Server driver.  The connection will only work if we use the IP address.  It won't work if we use just the hostname or the FQDN.

 

I look at the WSAM log on the client and it shows that it resolves the name (via NetBIOS for just the hostname and via DNS with the FQDN) but the connection test only succeeds by IP.

 

We have two SA-4000's in an A/P cluster running v6.0r6.  We have an upgrade to v6.3r5 scheduled for next week.

 

Any thoughts on what I can look at to resolve this?

 

Thanks!!

Distinguished Expert
firewall72
Posts: 825
Registered: ‎05-04-2008
0

Re: ODBC through WSAM

Hi,

 

It sounds like you have a name resolution issue.  How is the name specified in the client application?  Typically, I use IP's within WSAM since it doesn't have to match the client.  Once WSAM detects the IP and the destination port it will route it via the tunnel.  Is there an issue with using an IP in the WSAM config or are you changing the client app as well?

 

-John

John Judge
JNCIS-SEC, JNCIS-ENT,

If this solves your problem, please mark this post as "Accepted Solution". Kudos are appreciated.
Copyright© 1999-2013 Juniper Networks, Inc. All rights reserved.