VPN troubles

I am connecting into a clients computer over a VPN.  I can connect fine, however i am getting an error in a program because it can not connect properly.  The program is Ultimate Collection Control Client.  The error i am gettin is "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."  Any clue as to what this can be and how I can solve it?

Thanks in advance
securi-techAsked:
Who is Participating?
 
HypercubeTechConnect With a Mentor Commented:
And what type of router are you using.. some routers have a built in VPN server which makes things VERRRY easy..
0
 
MarakushCommented:
When you setup the user DSN via ODBC use the IP address rather then the host name.

Marakush
0
 
securi-techAuthor Commented:
I'm sorry but you lost me, could you elaborate a little more?
Thanks
0
Protect Your Employees from Wi-Fi Threats

As Wi-Fi growth and popularity continues to climb, not everyone understands the risks that come with connecting to public Wi-Fi or even offering Wi-Fi to employees, visitors and guests. Download the resource kit to make sure your safe wherever business takes you!

 
MarakushCommented:
To create a DSN

WIN XP
http://support.microsoft.com/default.aspx?scid=kb;en-us;305599

WIN2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;300596

The error that you posted, something is trying to connect to an SQL DB when you create the DSN use the IP of the SQL server rather then the Name of the SQL server. Because it sounds like it isn't resolving correctly.

Marakush
0
 
HypercubeTechCommented:
Marakush is right... Also check to make sure you can access folders on the network or if you can ping the server via name and not ip (or see if you can by both to make sure the connection is good).. Which VPN server are you using.

0
 
securi-techAuthor Commented:
Windows 2000, for some reason i dont think the vpn is configured right.  I can connect but no luck on pinging or finding anything on their side of the network!  I know this is not the right forum but any help will be appreciated.  I tried the above answer and still not working.
0
 
MarakushConnect With a Mentor Commented:
Well there is the problem if you can't ping it, or see it on the network that's a whole other problem.

We need to look at the VPN configuration to see what is going on, this issue will most likely be resolved when you  access the network on the other side.

Okay first things first.

How are you making the VPN connection? What is the configuration you are using?

Point to Point via routers? Client to Router? Client to Server? Hardware and software you are using? Also have to tested both connections and verified that both connections are up and running with net access?

Marakush
0
 
securi-techAuthor Commented:
It was client server, the machine was an old nt server.  I convinced the person to buy a vpn router.  Thank god...its a one more problem of my plate

Thanks for the help
0
 
HypercubeTechCommented:

No prob.. I have used some SMC ones.. older but under 100 bux   SMC7004FW i think it is
might be able to find them still..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.