having trouble creating ODBC to SQL server

I have a Win 2003 web server that has a VPN connection to an XP machine that's running SQL ver 8.0 and I need an ODBC connection.  I had it working at one point but had trouble with the VPN connection.  Since I have worked out that problem I have not been able to to connect the ODBC. I could use some help. I' very frustrated.  
lantervjAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LeandronnCommented:
What is the error you're receiving?
0
lantervjAuthor Commented:
Screen shot
SQL1.png
0
lantervjAuthor Commented:
BTW - thanks for being online tonight.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

lantervjAuthor Commented:
also
SQL2.png
0
lantervjAuthor Commented:
If I use the ip address of the XP machine via th VPN I get;
sql3.png
sql4.png
0
wmeerzaCommented:
in your servername put in \\ e.g \\thelmaspc\telemate

0
lantervjAuthor Commented:
Resulting error
SQL5.png
0
wmeerzaCommented:
oops my appologies, i think there should be no \\ or single \ at the server address, also when you select the drop down does it show any available servers?
0
lantervjAuthor Commented:
Results using IP address with \\
SQL6.png
0
lantervjAuthor Commented:
Yes, there are several servers listed. But, they appear to be ones I have tested.  All the failed attempts are in the list.
0
chkuehCommented:
try check your login name...
0
wmeerzaCommented:
have you tried servername without the backslashes
thelmaspc\telemate
Also I take it you VPN is currently connected (and you are sure of the password for sa)
0
lantervjAuthor Commented:
I have double checked the password by typing it in again and again. I showed test results above without the slashes. Yes, the VPN is connected. I can see the byte count climbing. It also show connected on the server and has assigned an IP address.
0
wmeerzaCommented:
can you see the server/machine you are connecting to? can you browse to it in explorer?
0
lantervjAuthor Commented:
While trying to connect the ODBC, I monitored the VPN connection on the server and it appears that no data is going out.
0
lantervjAuthor Commented:
No, I cannot see the server in explorer.
0
wmeerzaCommented:
can you ping the IP address? it's looking more like you do not have network access to it.
0
lantervjAuthor Commented:
No, I can't ping 192.168.222.11
0
wmeerzaCommented:
ok, your problem is not with odbc it's with access to the server, without knowing your network setup, is this server part of a domain that your VPN connects too? are there any other servers that you should be able to connect to to prove you have network access. Is the server in question on? (sounds stupid but i'm not familiar with your setup)
0
lantervjAuthor Commented:
I have a Win 2003 web server (hosted) that has Routing and Remote Access configured for VPN server. I only have two Win XP machines that need to connect to the VPN specifically for the web server to access the SQL 7 database on them.  I know that both of the XP machines can connect to the VPN server and internal IP addresses have been assigned. I know that the VPN server sees the static IP of the XP machines (192.168.222.11 and 12).
0
lantervjAuthor Commented:
The ODBC to 192.168.222.11 was working at one point.  That doesn't mean that the firewall on the web server hasn't changed, but I doubt it.  That's the one piece of the puzzle that I don't have direct control over.  I can see traffic on the firewall at the XP end.
0
wmeerzaCommented:
the fact that you cannot see the XP machine in question leads me to think you need to discuss this with the people who administer your web servers firewall. Looks like access has been removed somehow.
Perhaps try them and prove connectivity first then get back to the ODBC (which should be fine if you fix the connectivity issue)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lantervjAuthor Commented:
It was the firewall on my end.  I create  rule to access the XP SQL server directly (without the VPN) and had to allow ports 1433, 1746, 1748, and 1750.  It works just fine now.  Many, many thanks.
0
lantervjAuthor Commented:
Many thanks.
0
wmeerzaCommented:
no problem, glad you found it.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.